Unanswered

Reference n rows of Parse JSON object

(0) Share

Report

Posted on by 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!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@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/td-p/1715338

Was this reply helpful? Yes No
nalhcal 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
nalhcal 4 on at

Like (0)

Report

Bump

Was this reply helpful? Yes No