Unanswered

How to use data from sql server to build a excel?

(0) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Using connectors

I have the same question (0)

All responses (8)

Answers (0)

lbendlin 8,551 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Do you want to start from an Excel template copy, or from scratch (creating a blank Excel file and creating a table) ?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

my recommendation would be to use the Graph API.

Write data to an Excel workbook - Microsoft Graph | Microsoft Learn

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The Graph API is for the "write to Excel" part. To download data from an SQL source you can use a standard connector.

Was this reply helpful? Yes No