I am trying to create a Flow that generates a single email notice when three separate columns are modified in a SharePoint document library. However, I cannot prevent multiple email notices from generating each time the file is modified. There is an initial notice when the 'Employee Review Complete' column is set to 'Yes' (the employee changes this column). The second notice should trigger when the Admin changes the 'Suzanne Approved' column to 'Yes.' The last notice should generate when the 'Will Approved' column is set to 'Yes.' The original email notice is generated with each subsequent notice each time the file is modified.
I am using the 'When a file is created or modified (properties only) trigger for the files in the document library. I added a parallel branch to the Flow with 3-conditions. In an attempt to stop the multiple email notices with each file modification, I added a Terminate control to the first condition with a 'Cancelled' status. It works great for the first two conditions, the first and second email notices generate as expected with no duplication. However, the flow skips the third condition and the last email notice fails. I have tried various approaches to this flow and cannot stop the repeated email notices. Thank you in advance for any assistance and or suggestions.