Export Sharepoint list to Excel and save in Teams channel

Like (0) Share

Report

Posted on 27 Oct 2023 19:07:43 by Quantum123

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!

All responses (1)

Answers (0)

Michael E. Gernaey 45,169 Super User 2025 Season 2 on 28 Oct 2023 at 06:26:10

Like (0)

Report

Re: Export Sharepoint list to Excel and save in Teams channel

@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