I try to accomplish the task to export a sharepoint list on a regularly basis (weekly) into an excel file. In sharepoint, you have the option in the menu "Connect & Export" to "Export to Excel" which works well. However, I didn't manage to build a flow which can do the same and save the file on my desktop (ideally) or my onedrive folder.
I managed to get the template/example "Copy SharePoint list items into a CSV each week" to run. However, the download looks terrible. It contains all the formatting, for example each cell looks like:
Can you help me with the flow to download a csv file without all the formatting/source information or a flow which resembles the "export to excel" command?
Thank you for your help
Just try to customize the columns in the action Create CSV Table. Select Custom for Columns and Yes for Include headers, then specify values for corresponding header.
Please check the following screenshot.
I have made a test on my side and it works fine.
Hi Mabel Mao,
thank you very much for your suggestions!
I tried it out, but the formatting is still the same as if I export all cells automatically. It works correctly if I use the manual export to excel option, but I guess the beauty of flow is supposed to make life easier and do it automatically.
it shows in a cell:
instead of just: XXX
Any input appreciated.
that works for me, very helpful. I have been wondering how to get items from a SP list into excel and then send out to a team. The flow worked in test and I hope it will in anger to. The only thing I need to add is apply to each to write the multiple line of the SP list.
Was wondering if you were able to find a solution for this. I am currently facing the same issue
Thank you in advance!
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.