Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by 231

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

 

NPatel12498_0-1700148777002.png

 

  • NP-18101421-0 Profile Picture
    231 on at
    Re: Send Email when Criteria is Met but not if change is made after

    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!

     

    NPatel12498_0-1700153024961.png

     

  • Verified answer
    michael0808 Profile Picture
    304 on at
    Re: Send Email when Criteria is Met but not if change is made after

    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.

    michael0808_0-1700150544515.png

     

    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!

     

  • NP-18101421-0 Profile Picture
    231 on at
    Re: Send Email when Criteria is Met but not if change is made after

    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?

  • michael0808 Profile Picture
    304 on at
    Re: Send Email when Criteria is Met but not if change is made after

    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.

    michael0808_1-1700149963436.png

     

    I hope it helps!

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492