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 / Multiple Flows updatin...
Power Automate
Unanswered

Multiple Flows updating One Master Data Excel workbook

(0) ShareShare
ReportReport
Posted on by 5

Hi all,

 

I am new to Power Automate and Flows.

 

I have created a scheduled flow which Succeeded, the flow is to list all rows within the master data table within the first workbook and the same for the 2nd, it then applies an "Equal to" query to identify the same rows in both data tables. If matched I've asked for it to update the multiple rows/ Cells from the 2nd table so that the master table is updated.

 

My question is that I need to create 57 versions of this as we have 57 workbooks that need to update the master file.

 

Just one flow took 4 Hours, if I run all 57 flows in parallel (At the same time of day) does it have to wait for each flow to finish? or would it run at the same time?

 

Each table has a unique ID that matches the master table so there will be no conflicting Unique ID's within the 57 data tables.

 

Any advice would be appreciated.

Categories:
I have the same question (0)
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @GarethLynch 

     

    All Parallel branch run on same time. You can update master sheet with parallel flow.

    Annotation 2020-07-02 131417.jpg

    Thanks

    Hardesh

  • GarethLynch Profile Picture
    5 on at

    Thank you for getting back so quickly @Hardesh15 

     

    My flow is set out as below, I would create 57 of these and they could all run at the same time?

    GarethLynch_0-1593676712296.png

     

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @GarethLynch 

     

    Your design is a sequential flow. As per your requirement you can create parallel flow. While clicking on + sign select add parallel branch and add a compose (temporarily) and drag these action under parallel branch. once you dragged it delete compose action.

     

    Thanks

    Hardesh

     

  • GarethLynch Profile Picture
    5 on at

    Thank you very much

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @GarethLynch 

     

    if this solve your problem. please mark this as solution to help others.

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 957

#2
Valantis Profile Picture

Valantis 847

#3
Haque Profile Picture

Haque 609

Last 30 days Overall leaderboard