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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,967)