cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tea_Programmer
Advocate I
Advocate I

Create an Excel File and table

Hi,

 

I want to create an Excel file and then create a table from a SharePoint list. How can I achieve this and save it in a document library?

 

Regards,

Ruben 

4 REPLIES 4
Brad_Groux
Community Champion
Community Champion

The Add a row to Excel when a new item is added in SharePoint List template can get you started with the basics and is quite easy to setup and configure. You'd use those basic functions along with a Create file action.

Instead of when a When an Item is created trigger, you can Manually trigger a flow, or you can Run flows on a schedule. Your final Flow could look something like this:CreateXLSXCreateTableFromList.PNG

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hi @Brad_Groux ,

 

Can you show the function settings? 

What should I put in File Content in Create File?

 

Regards,

Ruben

 

Hi @Tea_Programmer ,

First, I am afraid you need create a excel file with the table you want manually.

Then you can use the flow to insert the data from the list to excel file.

In flow, you can only deal with the already exist excel file.

With the 'Add a row into a table' action, you need Select an Excel file through File Browse and Select a table from the drop-down.

Capture10.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 


@Tea_Programmer wrote:

Hi @Brad_Groux ,

 

Can you show the function settings? 

What should I put in File Content in Create File?

 

Regards,

Ruben

 


Create File allows for four parameters be set: 

Site Address string
Example: https://contoso.sharepoint.com/sites/sitename.
Key:dataset

Folder Path string
Must start with an existing library. Add folders if needed.
Key: folderPath

File Name string
Name of the file.
Key: name

File Content binary
Content of the file.
Key: body

In this step you'd type in the Site AddressFolder Path, and File Name of the file you would like to create. They are all strings, so they are basic text entry boxes. Put in the site and folder path where you would like the file stored, and the file name (including the extension) of the file you'd like to create.

You can leave File Content blank, and it will create a blank file. Then in the subsequent steps, you could call the file that you created. 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,316)