Power Platform Community Forum Thread Details

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!

Categories:

Building flows

@Quantum123

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