Unanswered

Flow Issue - Infinite Trigger Loop

(0) Share

Report

Posted on by Kmakhanya

Good Day,

I have a flow created that should update file properties on SharePoint after specific conditions are met. The issue that I am facing is that it runs the flow and the updates are made, however, the flow keeps looping/running and asks me for approval after it has been granted.

I've tried using the control Terminate, however that still doesnt help.

Categories:

Using flows

I have the same question (0)

All responses (13)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @Kmakhanya,

Can you share a couple of screenshots of your current flow setup?

Was this reply helpful? Yes No
Kmakhanya 13 on at

Like (0)

Report

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Kmakhanya,

Thanks for sharing the screenshots.

Just to double check. It looks like you have a yes/no field in SharePoint called must it be approved, correct?

Are you updating the value of that field to No in the update file properties: if approved & if rejected actions?

Was this reply helpful? Yes No
Kmakhanya 13 on at

Like (0)

Report

Hi @Expiscornovus

Yes, there is a field in SharePoint called "must it be approved"

No, that field doesnt need to be updated. The flow should only run if the following conditions are met on sharepoint:
(1) "Status" field is equal to Final
(2) "Must it be approved" field is equal to Yes

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Kmakhanya,

Ok, thanks for clarifying that.

In that case can you share a screenshot or just copy/paste the raw inputs of one of the flow runs which shouldn't happen. So, we can check which values it had and why it is still meeting your condition action and asking for approval.

Was this reply helpful? Yes No
Kmakhanya 13 on at

Like (0)

Report

Hi, please find below screenshots

Was this reply helpful? Yes No
Kmakhanya 13 on at

Like (0)

Report

Sorry, please swap the second and last image (with regards to the order)

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Kmakhanya,

Just to double check. I see you are setting the items to either Approved or Rejected in the update file properties action. However, in your condition action your are using the values Approve or Reject. That looks like a typo, is that correct?

Secondly, I was looking for the values which you were using. You can see those when the flow has run. Go to the history of the one which was failing/didn't work property. Expand the trigger action and look at the outputs (I said inputs in my previous reply, I should have said outputs 😁)

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

Normally to solve this you need to add a trigger condition that prevents the flow from running a second time. The easiest way to do that is to create the flow using a service account and then add a trigger condition to keep it from firing if the Modified By field is the service account. You can get specific details here:
How to avoid infinite trigger loop in Power Automate (tomriha.com)

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Thanks for sharing @Pstork1, that is definitely a great approach, a trigger condition based on the modified by field.

I was trying to find a solution with the current setup, a trigger condition based on the status field. However, I was still collecting all the details for that 😁

Was this reply helpful? Yes No