How to update Bulk/More items

(0) Share

Report

Posted on by Community Power Pla...

Hi Mates,

i have written a flow that will read (from excel)and write in Table.

yes its updating if 10,20,30 items but if more (5k) then items taking more time to update,

also i can not see any items in SQL table

it updating from 30 min but still i can see only 30 items out of 5k.

also flow has been divided in to multiple actions.

In-fact this is a important activity in this project, but it seems like roadblock for us.

your help would be highly/really appreciate on this issue.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

v-litu-msft on at

Like (1)

Report

Hi @Anonymous,

12 hours later, are these runs still running?

If you don't mind inserting records randomly out of order, you can turn on the Concurrency control and turn up parallelism, it could make the Apply to each action run faster:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-litu-msft ,
i tried with earlier it self but still its its taking hours and hours but i can see only 42 items has been updated in SQL,
i really don`t understand what is the issue here.
after some time it throws error to powerapps above error, but flow status is Running, also items are not getting updating.

have you ever tried to update more than 2000k records ..? how much time it takes ..?
Can we update bulk records(5000) using flow ...?

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report
Hi @Anonymous,

Could you share the whole structure of your Flow?

If you are extract data from Excel table, have you changed the limitation of return rows?

And if there are 2000k records in the SQL table, I think it is impossible to update all, there is the limitation of SQL connector:

#known-issues-and-limitations

The response size limit is 8MB through on-premises SQL server.

The request size limit is 2MB through on-premises SQL server.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Like (0)

Report

Anyone facing similar performance issues can also try using this batch SQL CRUD template:

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

It should be much faster & more efficient.

Was this reply helpful? Yes No