Hi All,
I have made an automate to get data from sql server, and it returns a table. Then how can I use this table to build a excel and put it on the sharepoint?
Hi All,
I have made an automate to get data from sql server, and it returns a table. Then how can I use this table to build a excel and put it on the sharepoint?
The Graph API is for the "write to Excel" part. To download data from an SQL source you can use a standard connector.
In fact, I need to click a button in a powerapp to download data from sql server, did the Graph API work in the powerapp?
Hi , @Anonymous
If you want to rename the created file name , you can just modify the fileName in the create file action:
If you want to rename the worksheet name , you may need to use the office script, for this , you can refer to :
Solved: Rename excel worksheet from script - Power Platform Community (microsoft.com)
If this reply can help you , you can click mark this reply as solution, thanks in advance!
Best Regards,
Yueyun Zhang
my recommendation would be to use the Graph API.
Write data to an Excel workbook - Microsoft Graph | Microsoft Learn
Both are acceptable, and I also want to rename the sheet name (A fixed name).
what I want to do is, each time use this automate, I can get a new excel file in sharepoint.
Sum up, I want to get data from sql server and put them into an excel in sharepoint so that I can download it
Both are acceptable, and I also want to rename the sheet name (A fixed name).
what I want to do is, each time use this automate, I can get a new excel file in sharepoint.
Sum up, I want to get data from sql server and put them into an excel in sharepoint so that I can download it
Hi , @Anonymous
According to your description, you have got an array from sql server in Power Automate.
If you want to export to Excel dynamically, you can follow this video to create the flow. You need first create a blank Template Excel file.
Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Email - YouTube
If this reply can help you , you can click mark this reply as solution, thanks in advance!
Best Regards,
Yueyun Zhang
Do you want to start from an Excel template copy, or from scratch (creating a blank Excel file and creating a table) ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.