Hi,
When I am loading items from share point to SQL it loads only 500 rows but my share point list has more than 8000 lines.
Any idea how to solve this?
Solved! Go to Solution.
By default Flow connectors only handle a maximum of 500 records. If you want to process more than that then you need to add a loop and process the records in batches of 500. For a SharePoint list the easiest way to do this is by filtering on the ID field in the list.
By default Flow connectors only handle a maximum of 500 records. If you want to process more than that then you need to add a loop and process the records in batches of 500. For a SharePoint list the easiest way to do this is by filtering on the ID field in the list.
Thanks a lot for quick response!
Could you please show or tell some example for share point list?
Hi @Anonymous
You can go to settings of the Get Items action and set limit to 5000
This should fetch 5000 records
Same thing for the for loop
If you have Flow P1 or P2 license you can expand this threshold to 100,000
Since you have 8k records you would have to fire get items query in a loop
example - fetch 5000 items first
then process it into sql
then again run same loop for next 5k items and process
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
12 | |
10 | |
10 | |
9 | |
6 |
User | Count |
---|---|
26 | |
20 | |
12 | |
10 | |
7 |