Hi,
I have a SharePoint list with lots of columns (~60) and has ~ 10 different flows to trigger at different times depending what the value of my status column is currently.
All of these flows start with the trigger "When Item is Created or Modified" because I cannot see a more specific one.
The first action in each flow is to check that the status column has the value they are looking for, if not then it finishes -> if it is the right status may send an email to the manager then change the status to a new value[so the flow doesnt get stuck in a infinate loop] (which modifies the SharePoint item and all flows try to run again until the first check.)
It is taking almost 10 minutes before some flow runs.
I have a status saying "Sent for Review" and a flow that checks for this status and then depending on a "Review response" column decides to change status the column to "waiting for implementation" or "rejected".
In this scenario my Item stays at the status "Sent for review" when the "Review response" has already been changed to rejected for about 10 minutes before the flow runs and changes the status. Users are complaining that it is not clear where they item is in the process because it is not updated instantly and they cant instantly see in their list which ones they have responded to right away
Is this because all my flows try and run when the item is created and only one can be active at a time? Does each flow that is set to activate run sequentially? If so how long is the delay before the next flow is called and is there any way to run in parralel?
The flows only edit the item if their specific status matches so I know they arent trying to cause save conflicts.