cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tinalamkey
Helper I
Helper I

Only want email to send when marked 'complete.'

I only want the email to trigger if the column changes to 'complete' - right now it's sending if it changes to 'complete' or 'incomplete'.  What do I need to change here?

tinalamkey_0-1656175581191.png

 

5 REPLIES 5
Pstork1
Dual Super User
Dual Super User

Add another line to your condition that checks the value of the column is equal to "Complete".  That way it will only send the email if that column has changed and if the column value is "Complete". If the column changes to incomplete it won't send the email.  If the column value is complete, but it didn't change then it also won't send the email. 



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

Not totally sure what this is supposed to look like.  Can you give more specifics?  When I type in 'equals' into the expression it gives me parenthesis...thanks!

 

tinalamkey_0-1656182812131.png

tinalamkey_1-1656182910358.png

 

 

in the left side of the condition choose the field value you want to be equal to Complete. The field that you are checking in the first line of the condition to make sure it has changed.



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

Any chance you can show me via a screenshot what this might look like?  Thank you!

Like this

image.png



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

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
Top Kudoed Authors
Users online (5,205)