Update a cell

Update a cell in Excel using Flow

When you try to update a cell in Excel using Microsoft Flow you could use the Update a row action. In the past I’ve used MS Graph to do things with Excel spreadsheets with Flow.

Update a cell in Excel

When you use the update a row action, 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.

Update a cell in Excel in a Flow

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

The text has been updated in Excel

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.

When the key is not unique only the first item found is updated

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

4 thoughts on “Update a cell in Excel using Flow

  1. 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

    1. 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.

  2. 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?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: