Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Infinite Loop

Posted on by
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:

  1. The flow triggers when the list is created or modified.
  2. The flow checks if the ETA field is not empty.
  3. 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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard