Send Email when Criteria is Met but not if change is made after

(0) Share

Report

Posted on by NP-18101421-0

237

Hi,

I have a workflow that sends an email when a column is checked "ready for review". Once the request is ready for review the users sometimes need to make a change after, however I do not want another email triggering because the workflow was modified. How can I avoid additional emails from triggering?

The Ready for Review column is a yes/no checkbox

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

michael0808 304 on at

Like (0)

Report
Copy link

Link copied!

You could try something like this, using the "Get Changes for an item or file" action. This action will return true or false for each column that was changed.

I hope it helps!

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report
Copy link

Link copied!

IF I use this approach and the user unchecks the box, then that would also trigger another email right? Should I add another condition within the existing condition to check for the value of the column?

Was this reply helpful? Yes No
Verified answer

michael0808 304 on at

Like (0)

Report
Copy link

Link copied!

So you only want it to trigger when it is the only column that has changed, and that column is checked, or equals yes, etc.

If the user unchecks it, the flow would run, it would evaluate as true for the "Has Column Changed", but because you also are checking against the column value, the condition would be false and it would not send the email.

If the user modifys that column again, it would trigger another email.

Hope this helps!

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report
Copy link

Link copied!

Thank you!

That worked. It took some playing around with the YES/NO Checkbox condition. Apparently using "Yes" or "No" as the criteria doesn't work. So you either use 0(no) or 1(yes) OR true or false. It also seemed that using "Not equal to" worked better than equals to.... weird but I found others with the same issue.

Thanks again!

Was this reply helpful? Yes No