You’re offline. This is a read only version of the page.
Announcements
11
I want to build a flow to export a sharepoint list each week and save on Teams. I was able to export into a CSV file but this export has a lot of OData junk and is not structured.
Is there a way to export in excel and save in a folder on Teams through Power Automate?
Thank you!
You can only save to Excel, if you have a pre-existing file in it. You could then dynamically add a sheet and add a Table (which is required to write data to Excel).
So however you are writing to the CSV, instead loop through your data and use the Add rows to a Table (for excel) and write all your data.
Now since this file has to pre-exist, you would store it somewhere, then make a copy of it IN the location (which is a OneDrive location (as it is the backend for Teams storage).
So, have an excel file
Make a copy in the ONedrive location that matches your Team Channel
Loop through your data and write it into the rows of the table on your worksheet
Done.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Share
Report
All responses (
Answers (
