Power Automate - Condition to "update item" for "when created or modified"?

Question

I am trying to update manager's name and unable to find the condition to stop the infinite loop it goes into.

Here is the background on the issue: Sharepoint to Sharepoint - Power Flow: How to update "manager's name" based on user's name in the *same* item when item is created or modified?

My trigger is when item is created or updated and it stop with updating item but that is again taken as a trigger to update. How do I break it?

Here are the screenshots of what I am trying to achieve.

Answer 1

Please following steps:

Solution A：

1.Add column to your list. For example, add [Status] (Choice column) and set default value is Pending.

2.In order to avoid endless loops, you can set conditions: update item when [Status] is Pending, and change [Status] to Completed. Then it will jump out of the next cycle.

Solution B：

Add Condition action to the Microsoft Flow:

• Manager's Name Claims is equal to null

Or

• Manager's Name Claims is not equal Display Name

======================= Updated Answer ========================

In My Testing:

1.Create new item:

2.Microsoft Flow

3.Result

======================= Updated Answer ========================

Get user profile (V2) User (UPN): Engineer's Name Email

Condition: Manager's Name DisplayName is not equal to Display Name

The Flow will be triggered twice, because as long as the value of the item is modified, the flow will be triggered. However, if the Manager's Name Displayname is equal to the Get manager Display name, the item will not be updated and break out of the loop.

Answer 2

To break the loop, use a Power Automate (PA) Trigger Condition. Please refer to this link for details.

Here are the steps that I would use to break the loop in PA:

1. Add a [Status] column to your list with a default value Pending. When the PA is triggered for the first time and the corresponding item is updated (Manager's name, in this case), update the [Status] column's value as well to something like Updated.

2. Set the Trigger Condition in PA. The expression would be like ([Status] is a Choice Type Column in the example)

@equals(triggerBody()?['Status']?['Value'], 'Pending')

3. The PA should only trigger when the [Status]='Pending'