Only 500 rows added in SQL

[Anonymous]

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?

[Pstork1 · Accepted 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.

[Anonymous]

Thanks a lot for quick response!

Could you please show or tell some example for share point list?

[RezaDorrani]

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