Send email when item in SP list is updated parsing single line of text field

[dgillespie]

I want to trigger an email every time one column in a SP list is updated with the value "yes."  The name column is a single line of text field and the Dashlane Deployed column is Yes/No field (this is the one I want Flow to look at). 

So flow should:

1) watch the Dashlane Deployed column in this SP list

2) if the value is yes, it should look at that row, get the name in the name column, translate that to an email address and send an email

3) if the value is no, the flow should terminate

Here are my steps but all my results are Cancelled.  Thoughts?

Step 1condition = yescondition = norun results

[ScottShearer]

@dgillespie 

Try entering true rather than Yes in your expression.  Please let me know if that works for you.

[dgillespie]

Thanks for the reply @ScottShearer - my results are still Cancelled after changing the value to true.

[ScottShearer]

@dgillespie 

Can you verify that you are actually using a Yes/No column and not an option column?

[dgillespie]

Yes:

[ScottShearer · Accepted solution]

@dgillespie 

Not sure why true doesn't work for you - it should...

Try one more thing - enter true in the expression window - see my example below where I enter true as text and also in the expression window - both work.

[dgillespie]

@ScottShearerthat worked!  Thanks for the help!  I have also included my edited Send Email section - we added a Person or Group field column and used it to pull email instead of the Single Line of Text column.

true variable works

email working