使用Logic Apps将表SQL元数据从Azure SQL数据库传输到Sharepoint库 [英] Transfer table metadata from Azure SQL Database to Sharepoint library using Logic Apps

问题描述

您好，

我正在处理的要求应该使我们能够将表数据从Azure SQL数据库传输到Sharepoint库（ not List）使用Azure逻辑应用程序。

为此，我将Azure SQL表格数据转换为CSV表格格式，然后将其上传到Sharepoint库。

但是，我的要求是上传从SQL表中提取的Excel文件，然后上传到Sharepoint库。

那么，有什么办法可以将这个CSV文件转换为使用Azure Logic应用程序的Excel？

或者，还有通过Excel工作表将Azure SQL数据库表数据传输到Sharepoint站点的任何提示？

任何帮助会非常有用。  

解决方案

您好Sahil，

您可以生成使用azure函数的excel文件，然后从您的逻辑应用程序调用它：

ħ ttps：//www.syncfusion.com/kb/10260/create-excel-file-in-azure-functions

我在互联网上找到的另一个选项是第三方连接器，不确定100％但值得一试：

https://plumsail.com/docs/documents/v1.x/flow/how-tos/documents /create-xlsx-from-template.html

Hello,

I am working on requirement which should enable us to transfer table data from a Azure SQL database to a Sharepoint Library (not List) using Azure logic apps.

For this, I converted the Azure SQL table data into CSV table format and then uploaded it on the Sharepoint library.

However,my requirement is to upload an Excel file extracted from the SQL table and then subsequently into the Sharepoint library.

So,is there any way that i can convert this CSV file to Excel using Azure Logic apps?

Or also, any tips to transfer Azure SQL db table data onto the Sharepoint site via Excel sheets?

Any help would be really helpful.  

解决方案

Hi Sahil,

you can generate excel file using azure function and then call it from your logic app:

https://www.syncfusion.com/kb/10260/create-excel-file-in-azure-functions

The other option that i found on the internet is a third party connector, not sure 100% but worth giving a try:

https://plumsail.com/docs/documents/v1.x/flow/how-tos/documents/create-xlsx-from-template.html

这篇关于使用Logic Apps将表SQL元数据从Azure SQL数据库传输到Sharepoint库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！