web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update a row running v...
Power Automate
Answered

Update a row running very slow

(0) ShareShare
ReportReport
Posted on by 43

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:

70000075_0-1664002070009.png

70000075_3-1664002241659.png

 

Run History:- 

70000075_4-1664002370157.png

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!

Categories:
I have the same question (0)
  • Sundeep_Malik Profile Picture
    6,495 on at

    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:

    Sundeep_Malik_0-1664003568296.png

    After that open the concurrency option.

    Sundeep_Malik_1-1664003625430.png

    And increase the degree of parallelism to max, that is, 50.

    Sundeep_Malik_2-1664003848273.png

     

    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.

  • 70000075 Profile Picture
    43 on at

    Didn't work, no any improvement

    70000075_0-1664005576006.png

    70000075_1-1664005635321.png

     

  • Sundeep_Malik Profile Picture
    6,495 on at

    @70000075 

    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.

  • 70000075 Profile Picture
    43 on at

    Ok thanks, but run flow completed 1hr 5 mnt

    70000075_0-1664010491118.png

     

    Is there any another way to reduce the running time?

  • Verified answer
    takolota1 Profile Picture
    4,978 Moderator on at

    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

     

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

  • 70000075 Profile Picture
    43 on at

    Wow! Awesome Thank you very much...

    it's working very well...

     

    Once Thank you!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard