Announcements
I have a list in SharePoint that contains 400 000 items. What is the most effective way of exporting this list to CSV using PowerAutomate?
Hi @GuttormG ,
To export your Sharepoint list to a csv file you can use the following flow:
The connector Create file will create a file in the allocated location. Don't forget to add the file extension ".csv".
Let me know if this helped.
Regards,
Sara Nunes
Thanks for your reply. It is the size of the list that is the matter; Get items will only return the first 5000. What is the best way to recieve all 400K elements?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 432 Super User 2026 Season 2
Mohsin Ali 347
WarrenBelz 254 Most Valuable Professional
