Unanswered

Creating weekly CSV file from SharePoint List

(0) Share

Report

Posted on by IrishBaritone

I'm using this Flow template to create a CSV file base on a SharePoint list: Copy SharePoint list items into a CSV each week | Power Automate (appsplatform.us)

It is only pulling 101 rows of data, but the list contains over 5,000 rows of data. Any ideas? Someone mentioned that I might need to add a "loop" but I'm not sure where to start with that. I do think it has something to do with Automate timing out because it is taking so long for each row of data to generate, or something like that. Thanks for your help!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

What did you specify in the advanced options?

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report

Hi @IrishBaritone ,

You can open Pagination in the settings and change the limit to 5000, but the Get items action in power automate can only take up to 5000 records from the Share point.
Learn more through the links below.
Solved: SharePoint Get Items Maximum Row Limit - Power Platform Community (microsoft.com)
If you want to get more than 5000 records, you can first get 5000 in ascending order, then get 5000 in descending order, and finally use union() to merge them.
I have a test for your reference.

Best Regards,
Dezhi

Was this reply helpful? Yes No