web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : tnmvAQHTtLxhEsYgeL97vn
Power Automate - Building Flows
Unanswered

Terminate Control Does Not Stop Multiple Email Notices

Like (0) ShareShare
ReportReport
Posted on 2 Apr 2020 15:27:21 by 299

Morning!
Hopefully the third request for help will be the charm. I've finally mastered the email error I was experiencing with the Delay control. Now I need to prevent multiple email notices from generating each time the file is 'modified.' I created 3-separate Flows for each time a file is modified. 1) When the User changes the 'Employee Review' column to 'Yes'; 2) When the 'Suzanne Approved' column is changed to 'Yes'; and 3) When the 'Will Approved' column is changed to 'Yes.' I have a 'Trigger Condition' in the 'When a file is created or modified (properties only)' Settings > Trigger Conditions field.

 

Employee Review: @equals(triggerBody()?['Employee_x0020_Review_x0020_Complete'], bool('True'))
Suzanne Approved: @equals(triggerBody()?['Suzanne_x0020_Approved'], bool('True'))
Will Approved: @equals(triggerBody()?['Will_x0020_Approved'], bool('True'))

 

I have a 'Terminate' control at the end of each Flow, but it does not prevent the generation of all email notices each time a column is changed. Is there another method I can use to stop the flood of email notices? Once again, thank you for any assistance or suggestions.

 

PVLove

 

FlowReview1.pngFlowReview2.png

  • yashag2255 Profile Picture
    24,647 Super User 2024 Season 1 on 13 Apr 2020 at 09:29:48
    Re: Terminate Control Does Not Stop Multiple Email Notices

    Hi @PVLove 

     

    The problem here is, whenever the item is getting modified, the trigger conditions of all the flows are being evaluated. For example, if employee review was set to yes, the employee review flow has triggered. Now, when suzzane approved is yes, both the employee and suzzane approved columns are true that satisfy the other conditions and therefore are triggered. 

     

    You might want to add an update action in the flows to update these columns to no when the respective flow runs are completed for the specific item.

     

    Hope this Helps!!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS! 

  • PVLove Profile Picture
    299 on 03 Apr 2020 at 16:14:33
    Re: Terminate Control Does Not Stop Multiple Email Notices

    Hi @yashag2255,

     

    Thank you for the response.  The columns are Yes/No, but the suggested Trigger Condition didn't work.  I changed the condition in the Settings for each Flow, but it didn't terminate the multiple email notices when the Yes/No column is changed for a single file.

     

    PVLove

  • yashag2255 Profile Picture
    24,647 Super User 2024 Season 1 on 03 Apr 2020 at 07:02:49
    Re: Terminate Control Does Not Stop Multiple Email Notices

    Hi @PVLove 

     

    Can you update your expressions to have just true in the trigger condition? something like this: 

    @equals(triggerBody()?['Employee_x0020_Review_x0020_Complete'],true)

    Assuming that the above column is a Yes/No column in SP

     

    Hope this Helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete