CODEWITHSUNDEEP
power-automate
coder101
coder101

Reputation: 35

Update a cell in Excel Sheet using Power Automate

I'm trying to update the "Email Sent" column once an email has sent. Once an email has been sent I want it to say "Sent" instead of "No"

I'm using the "update a row" action however, can't seem to have it updated. I'm not sure what I should enter for the "Key Value" because email can be sent for multiple rows at once. This is what I have so far but it is not working:

enter image description here enter image description here

My Excel table:

enter image description here

Upvotes: 0

Views: 28446

Answers (1)

carlosherrera
carlosherrera

Reputation: 187

When you use "Update a row", you need to specify a key column (the one with a unique id or value) so Power Automate can search a single row and update it.

Field "Key Column" is the column name where said ID is stored. Field "Key Value" is the value to search for.

For example, in the following table:

Mentor ID Email Email_Sent
A001 [email protected] No
A002 [email protected] No

If you wanted to update the first row, you'd need to specify Key Column = Mentor ID, and Key Value = A001.

Upvotes: 1

Related Questions