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)

Sort by

Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

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,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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
Copy link

Link copied!

Bump

Was this reply helpful? Yes No