You’re offline. This is a read only version of the page.
5
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!
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
#1
WarrenBelz
146,609
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
