Update row if cell equals yes...key values!

[jlambo]

Hi all,

My flow is:

• If excel file modified
• Get the rows
• If any cells in "Scheduled?" column = "YES"
• update "Scheduled?" column to = "DONE"
• update corresponding "Completed" column to = "YES"

The "Key Values" are giving me a hard time....

Thank you!

J

[RobElliott]

@jlambo your key column needs to have unique values, it can't work with Yes or No as those won't be unique. So for your key column make sure you have cells which will always be unique.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[v-alzhan-msft · Accepted solution]

Hi @jlambo ,

You should refer to screenshot below to create the flow:

Note:

1. Use action "List rows present in a table" instead of "Get a row".

2. You could choose the Appointment column as the Key column. Please make sure every value in the Appointment column should be unique.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.