How can I prevent an infinite loop in Power Automate when updating a SharePoint "ETA Reminder" column based on changes to an "ETA" column?
I have a SharePoint list with two columns: ETA and ETA Reminder.
- When the ETA column is newly created, I want to set the ETA Reminder column to two days before the ETA value.
- When the ETA is modified, I need to update the ETA Reminder column to reflect the new ETA (again, set to two days before the new ETA value).
However, my flow keeps running in an infinite loop because:
- The flow triggers when the list is created or modified.
- The flow checks if the ETA field is not empty.
- It then updates the ETA Reminder field if ETA field is not empty, which in turn triggers the flow again, causing it to loop endlessly.
I even tried using a Terminate connector at the end of my flow, after updating the SharePoint list, to stop the flow from continuing. Unfortunately, the flow still gets automatically triggered and runs again when I view the Run History.
How can I adjust the flow conditions to prevent this infinite loop while still updating the ETA Reminder correctly when the ETA is created or modified?