Categories: Microsoft Flow

Update cells in Excel using Power Automate Flows

When you try to update cells in Excel using Power Automate you could use the Update a row action. 

Update a cell in Excel

In the past I’ve used MS Graph to do things with Excel spreadsheets with Flow.

When you use the update a row action to update cells in Excel, like with all other actions in this connector, you will need a table in your Excel spreadsheet. One additional requirement is needed for the update a row action.

You will need a key column with unique values.

In my example below I created a column key and populate this column with a number.

Now as I run my flow my row with the key equals 1 is updated.

Unique Key column

It is important that you have a Key column that is unique. When I updated the row with Key set to 1 while I had multiple rows having a key of 1 only the first row was updated.

Therefore make sure that you key column is unique and then this update a row action can be very useful.

Share
Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

View Comments

  • i need to know what's the last key value for row in key column .. i need to create a flow . one excel file updated with new row .. or any cell updated .. to send me Notification by email

    • Hi Tamer,

      i noticed that too. When you create a 3 column table in Excel the Power Platform adds another column with a unique key. I don't think that the values really matter as long as that column is unique within the table.

  • Hi Pieter,

    Good post. This is close to what I’m trying to do myself, but not quite. I simply want to update all rows in an Excel table using “List rows present in a table” followed by “Apply to each”. However it appears that the only way to then update the row is to use “Update a row”.

    The problem with using “Update a row” is that is that you have to define the location of the table again after having just done so for “List rows present in a table”. And in the process having to provide a key to uniquely identify the row to be updated. This makes no sense to me. It should already know what row is to be updated, i.e., the current row in “Apply to each”. And by having to define what table and row again, you can only update tables that have an unique value column.

    What am I missing here?

  • Hi Pieter,
    When updating a row of excel, I am using the dynamic SharePoint address from power apps. My table name is fixed always. I want to give the document Library as a custom Value. If i give the custom value as ID of the document library Table or its name like "Documents". It doesn't work. It is having some unique ID like this "b!IBThIWvJLE2cpXR4vXSgWAz4mAwzdOFMtFvvN_BOStD_-L5GIQ_WQY2RKhBib1nu".

    Is there any way to fetch that??

Recent Posts

Filter Query in SharePoint Get Items in Power Automate

Have you tried the experimental version of Filter query in the SharePoint Get Items action…

2 days ago

3 Ways to add a column to an array in Power Automate

When you have an array in Power Automate and you would like to add a…

6 days ago

Patch any field type in a SharePoint list item using Power Apps

In Power Apps the Patch function is very important when you work with data. In…

1 week ago

Call flows from a model driven app

Wouldn't it be great if you could call flows from a model driven app? Well…

2 weeks ago

Variables or Compose? Consider neither in Power Automate

The question is Variables or Compose actions in Power Automate? Variables Sometimes you need a…

2 weeks ago

Your 1st lesson in Power Apps, in a few easy steps!

1st lessons can be so important when you want to get started with Power apps.…

4 weeks ago
%%footer%%