cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

MS Flow - Export Sharepoint List content to Excel

Hello together,

 

Its really pitty, that there is no easy solution to create simple Excel table from content of Sharepoint List items.

 

My approach is generating no desired outcome:

 

1. When an item is created (In Sharepoint list)

2. Get Items (from Sharepoint List)

3. Create CSV Table (no option to create Excel table with the content from Connector Get Items 😞 ...)

4. Create File (In Sharepoint directory)

 

Outcome is messy File without formatting, which is just generating additional work to me...

 

Any Idea How to export such Excel table the easy way to the Sharepoint  ?

e.g. same as is Export to Excel button on the top of the Sharepoint List...

 

I think Im not the only one asking for this basic functionality, any hint shall be really valuable. Thanks.

 

 

5 REPLIES 5
frederikbisback
Advocate V
Advocate V

@Anonymous

 

This is possible.

Created a quick example. In this example I trigger with button

Microsoft Flow Community - 01.png

I will get all the files located in the Document library. Select your SharePoint site address and library name.

Next we will put this in a excel file in OneDrive. Prepare first your excel with a table and table name.

Microsoft Flow Community - 03.pngMicrosoft Flow Community - 04.png

Adding for each item a rows to your table in excel

Microsoft Flow Community - 02.pngAdd the corresponding value to your column items in you table.

 

This is an example result.

Microsoft Flow Community - 05.png

 

 

I hope this can help you.

 

Regards 

 

Frederik Bisback

 

 

v-yamao-msft
Community Support
Community Support

Hi @Anonymous,

 

Are you trying to create an Excel file on SharePoint library using Flow?

In the action Create CSV table, we could enable Custom Columns to customize the table. After getting the CSV table, create a CSV file in SharePoint library. On SharePoint site, we could select open the csv file in Excel Online or Excel.

I have made the following test, please check it for a reference.

1.PNG2.PNG

If you need the feature to create an Excel file directly, please feel free submit a request on Flow Ideas Forum at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@frederikbisback 

Hello! Now, how would this look if I wanted 3 Sharepoint lists to fit into one Excel Sheet?

@v-yamao-msft  Hi Mabel Mao,

I've been using this since there was no faster choice,

However the issue with csv is when I open the data into Excel, it always breaks at the "delimiter" that I dont want 

Like sometimes I might note something with a comma, but import csv to exel with commo in tour data does not feel like a good solution

@Anonymous ,

 

You can use "Microsoft Graph" to approach it.

The way is to use the connector "Invoke an HTTP request", you can get/paste/delete the data from the worksheets.

John Liu has a tutorial of this, you can refer to below video:

https://www.youtube.com/watch?v=FqGhuJ00aPA&feature=youtu.be

 

Microsoft Graph explanation:

https://docs.microsoft.com/en-us/graph/api/resources/worksheet?view=graph-rest-1.0

 

ilu989

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 (1,045)