I am trying to build a flow and have tried different options with the triggering method and have ended up with some epic fails the biggest with having dozens of flows triggered sending repetitive emails.
In SharePoint 2010 I have a flow that was triggered on ‘When the item is modified’ every time something was edited it would re-start the same flow
In PowerAutomate every time something is edited it will trigger a new flow, unless there is a way not to trigger a new flow that I am not aware of….
Basically I have a SharePoint library that contains many columns, the two primary columns are StartDate and EndDate; the EndDate and all the other columns can be modified multiple times.
I need the flow to email a notification (through various edits of the item) when the difference between EndDate and StartDate returns TOTDays greater than 7.
I believe the below chart is my best though to build the flow; the flow will be triggered by When an item or file is modified this is because I already have a trigger When an item is created that will immediately update certain columns and therefore this flow will trigger.
However I have realised that the flow will not trigger if when the item is created the TOTDays is already greater than 7 as the Get changes for an item or file will not pick up the change and therefore not progressing the flow. The below chart could be the right approach, however it seems to me a pretty complicated flow; are there other steps that I might not be aware of that may simplify the flow efficiently?
