Reference n rows of Parse JSON object

[nalhcal]

Hi guys, I am encountering an issue with the 5000 limit maximum for looping in Microsoft Flow. I have a Parse JSON object with 30,000 rows which are each to be placed into an 'Insert Row' SQL action. I am wondering whether it is possible to reference the first 5000 rows, and put them into the SQL action, and then rows 5001 to 10,000. Any ideas? 

Thanks! 

[Sundeep_Malik]

Hey @nalhcal 

I have not tried it the thing I am going to tell you with sql, but I have done it with sharepoint.

So, for the 1st one, keep top count as 5000.

Next perform whatever you want to perform.

After that add another Get rows action and in that give top count 5000 and skip count as 5000.

So, now it will read from 5001 to 10000.

And keep doing it till you read all 30000 rows.

[takolota]

@nalhcal @Sundeep_Malik 

You can also try using this batch SQL query flow to send most of the data at once without as much intermediate batching or looping.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/...

[nalhcal]

Hi @Sundeep_Malik , this appears only to apply to the 'get rows' function rather than insert. 

[nalhcal]

Bump