You’re offline. This is a read only version of the page.
I want to update a row Excel to Excel only tow column and 1400 row, but gating very slow running for flow...
Flow looks like below:
Run History:-
Does anyone know how can I optimize the mechanics of the Flow, in order to reduce the running time?
Any help would be appreciated.
Thank you!
If you have access to Office Scripts & you’re willing to put in a little extra work to implement the template, then there is this Batch Update & Create Excel template that should speed things up at least 50x
Atleast try it fully. Originally your update row is taking 26 minutes. Maybe concurrency improves that by a few minutes.
Btw the speed also depends on different licenses. A free license takes a lot time if compared to purchased license.
Hey @70000075
There are many methods to improve the performance.
The easiest I know is to open the option of concurrency.
Click on three dots of apply to each. Then click on settings:
After that open the concurrency option.
And increase the degree of parallelism to max, that is, 50.
So, what it does is, normally the loop will go to the value at 0 index or the 1st value, then to the 2nd value, then 3rd and so on. But with concurrency it checks all the things at the same time. So, setting it to 50 will check 50 items at the same time.
Just a note:
Dont use concurrency with variables, only use compose action.
Sometimes increasing it to 50 might slow down the process. So, find the value that suits best to you. You can keep it low to 10 also, or make it to 20, 25 or 30. Just find the appropriate value for yourself.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
