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 multiple Excel ...
Power Automate
Unanswered

Update multiple Excel files from a master Excel sheet

(0) ShareShare
ReportReport
Posted on by 6

Hello All,

 

I am new to Power Automate and attempting to conceptualize a workflow which automates a batch update for multiple excel files. Essentially, I have a single "master" excel file (stored within a sharepoint folder) and need to automatically update multiple excel files (in an alternative sharepoint folder) files when the master file is updated or configured. Each of the sub-files which I need updated also contain the same table sheet within them. Is there anyway to do this with power automate? Any information or insight would be greatly appreciated!

 

Thanks

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,716 Super User 2026 Season 1 on at

    Do you want to do this in the Power Automate service or with PAD (Power Automate Desktop)  ?

  • Woodhouse Profile Picture
    6 on at

    I'm working within the Power Automate Service

  • lbendlin Profile Picture
    8,716 Super User 2026 Season 1 on at

    This would be your trigger

    lbendlin_0-1664138462069.png

     

    and here are the actions you can perform (plus a couple more)

     

    lbendlin_1-1664138526940.png

     

    You will now need to decide if you want to copy the entire master file, or if you want to harvest the data changes and apply them to the dependent files too.

  • Woodhouse Profile Picture
    6 on at

    I went ahead and made some preliminary flows which did what I wanted them to do, however, it seems I've ran into a roadblock trying to get a data validation that table 2 is equal to table 1 which ends the do until/apply to each loop I have setup. Below are some pictures of this particular flow, it is manually triggered now as that works better with what I needed (batch update wise). Flow overviewFlow overview

     

     

    Apply to each/Do Until LoopApply to each/Do Until Loop

    As of right now, the loop is set to perform the updates until the value of table two equals table one, but it runs infinitely and never validates this for some reason. Ideally, I want it to first apply any updates and then check that the values are equal so the apply to each/do until loop can be ended. Any help would be greatly appreciated on how to accomplish this!

     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 378

#2
Valantis Profile Picture

Valantis 329

#3
David_MA Profile Picture

David_MA 283 Super User 2026 Season 1

Last 30 days Overall leaderboard