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.
This is possible.
Created a quick example. In this example I trigger with button
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.
Adding for each item a rows to your table in excel
Add the corresponding value to your column items in you table.
This is an example result.
I hope this can help you.
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.
If you need the feature to create an Excel file directly, please feel free submit a request on Flow Ideas Forum at here:
@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
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:
Microsoft Graph explanation:
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.