cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jlambo
New Member

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

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

 

msautoflow.png

 

Thank you!

J

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @jlambo ,

 

You should refer to screenshot below to create the flow:

1.png

 

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.

View solution in original post

2 REPLIES 2
RobElliott
Super User
Super User

@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
Community Support
Community Support

Hi @jlambo ,

 

You should refer to screenshot below to create the flow:

1.png

 

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,548)