cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dgillespie
Advocate II
Advocate II

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

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 1Step 1condition = yescondition = yescondition = nocondition = norun resultsrun results

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

YesNo.jpg

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

6 REPLIES 6
ScottShearer
Super User
Super User

@dgillespie 

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

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

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

@dgillespie 

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

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Yes:

 

dd-column.jpg

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

YesNo.jpg

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

@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 workstrue variable works

email workingemail working

 

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 (1,598)