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

Update multiple tables at the same time in the same excel file

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have a flow that takes a row from a sharepoint list and applies the value to two or three separate tables, depending on the preceding condition step. As seen below, I've had to put in a delay step in between table updates because once a file is accessed in SharePoint, it's seen as "checked out" or being used for a few minutes afterwards. Without the delay steps, I will continually get an error saying the table is not found (because the flow finds the file is "checked out" or locked in some way). Is there a way to build the flow so that it essentially says (1) open this file, then (2) update these tables all at once? 

I previously had these table-update steps working in parallel together but  received the same type of error, since each step is trying to access the file separately at the same time.

 

CMolitor_0-1692722917779.png

 

Categories:
I have the same question (0)
  • Unknown geen idee Profile Picture
    1,757 on at

    Dear C,

     

    I have no problem in various flows to update multiple rows in the same file/table continuously at the same time. In one particular flow I have parallel 40 updates to rows in the same table without issue.

    What in see in your screenshot is that you are actually not just updating an existing table ... but you are creating a new file and then updating a new table in that file ...  As you experienced, new files take some time to become 'available' in the flow .. this is your key issue (not the multiple rows updates in the same table).

     

    Suggest you review your flow and consider if you need all the new files.

     

    Happy flowing,

    Koen

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @Koen5 - Let me clarify, as I was not clear in my original post - The Create File step is completely separate from the Add a row into a table, and Update a row steps. The file created in the Create File step is a different file. The file is the same for the two separate tables (one table referenced in the Add a row into a table step, and another table referenced for the Update a row steps). Since both the separate tables are in the same file, the "locked" issue is occurring. 

  • Unknown geen idee Profile Picture
    1,757 on at

    Dear C,

    Do you have to work on Sharepoint or would OneDrive also be suitable? Reason for asking is that I am running flows in which continuously parallel I update several different tables within the same file. I am thinking this maybe something particular to Sharepoint?

    If not, then I would look at file/site settings for updating and/or search this forum for 'locked' file issues.

     

    Happy flowing,

    Koen

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I must use sharepoint and not onedrive, as we have many people triggering this flow everyday. 

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 664

#2
Haque Profile Picture

Haque 460

#3
Valantis Profile Picture

Valantis 357

Last 30 days Overall leaderboard