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
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!
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
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!
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2