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.
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?


Report
All responses (
Answers (