Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Terminate Control Does Not Stop Multiple Email Notices

(0) ShareShare
ReportReport
Posted on 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,442 Super User 2024 Season 1 on at
    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 at
    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,442 Super User 2024 Season 1 on at
    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

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 >