Flow Creating Multiple SharePoint Versions Due to Loop

(0) Share

Report

Posted on by Tanveer

Hi everyone,
I’ve built a Power Automate flow that tracks status changes in a SharePoint list item:

When the Status column changes from "Pending" to "In Progress", it captures the current date in the Start Date column.
When the Status changes from "In Progress" to "Completed", it captures the date in the End Date column.

The date capture works perfectly. However, the issue is that the flow keeps running in a loop and creates thousands of versions of the SharePoint item.

Here’s what I’ve already tried:

I added a trigger condition:
@equals(triggerOutputs()?['Body/Status/Value'],'In Progress')
I also added a condition block inside the flow to check the status before updating.

Despite this, the flow still updates the item and retriggers itself, causing version bloat.

Question:
How can I prevent the flow from updating the item unnecessarily and stop it from looping?

Any help or suggestions would be greatly appreciated!

Categories:

Building flows

Versions.jpg

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Rohit Jagadale 16 on at

Like (0)

Report
Before updating, check if the column is empty: This prevents unnecessary updates and retriggering.

If Start Date is blank → update it. Else → do nothing.

Was this reply helpful? Yes No
Tanveer 16 on at

Like (0)

Report

@Rohit Jagadale
Thank you for your response, I did not understand your answer, could you please explain it with more detailed steps please.

Was this reply helpful? Yes No
Rohit Jagadale 16 on at

Like (0)

Report
1. When item is created (Status = In Progress) => capture Start Date

Condition: Status = In Progress AND Start Date is empty

Action: Update only the Start Date column with utcNow()

2. When Status changes to Completed => capture End Date

Condition: Status = Completed AND End Date is empty

Action: Update only the End Date column with utcNow()

Was this reply helpful? Yes No
Tanveer 16 on at

Like (0)

Report

@ Rohit Jagadale

Thanks again for responding to my post, see below is the complete flow details, is there any mistake in my flow?

The revisions are created without stopping, i am 100% sure this is happening from this flow only. If i turn off the flow the revisions are stopped and if i turn on the flow, then again, the revisions are restarted.

Was this reply helpful? Yes No