Power Automate flow always in Running state

(0) Share

Report

Posted on by Teresa24486

613

Hi,

The flow is always in the running state in the background, how can I fix this?

My flow has only 3 steps: when a row is added/modified; list rows based on expired records, and expired records should update the status to inactive.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (0)

KBilakanti1 Microsoft Employee on at

Like (0)

Report

@Teresa24486

I can see from the above screenshot that your flow trigger is when a row is added or modified or deleted, and in the actions you are updating the row which is causing circular dependency of the flow. Hence it's showing as running.

Was this reply helpful? Yes No
Teresa24486 613 on at

Like (0)

Report

HI @KBilakanti1 ,
How can I rectify this? Or is it okay for the flow to keep running at the background?

Was this reply helpful? Yes No
KBilakanti1 Microsoft Employee on at

Like (0)

Report

1.You can add trigger conditions so that your flow will trigger when a field value gets updated rather than all update operations.
2. When should you trigger your flow? On Create or On Update or On Delete?

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

I can see the trigger process is Create/Updated/Deleted, thats why its keep looping the field,

Please use Plugin, so that we can handle the same.

Was this reply helpful? Yes No
Teresa24486 613 on at

Like (0)

Report

Hi @KBilakanti1,
I have an update condition when modifying only one field. So the flow should run only when create/update.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @Teresa24486 ,

In you trigger step, add the field, or fields that you want to trigger for the update and of course your flow can. not update those fields or that will cause the looping...

Example below I trigger on only the name field changing. The flow will not even execute if I update any other fields and not the name field on the account. My update step then updates the Address so it will not fire again (since I am not updating the name).

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
KBilakanti1 Microsoft Employee on at

Like (1)

Report

@Teresa24486

You can follow the process mentioned by @dpoggemann , In your power automate trigger step in "Select Columns" property add the column internal name which you want to invoke the power automate for, so that the power automate will trigger only when the specified column gets changed rather than triggering on every record create/update.

Please accept if it answers your question, so that others can easily find it.

Thanks
Karthik

Was this reply helpful? Yes No
Teresa24486 613 on at

Like (0)

Report

Hi @dpoggemann, @KBilakanti1 ,
Thanks, setting a filter condition worked and is not looping anymore!

So wont List rows filter /loop through Inactive records?
I have inactive records based on expiry date <=today. If I have to activate my record by extending the expiry date, the flow is in the running state and times out.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @Teresa24486 ,

You can always add filter criteria in your List records to not pull inactive records. I usually utilize FetchXML in the list records to remove ones I don't want.

Thanks,

Drew

Was this reply helpful? Yes No
Teresa24486 613 on at

Like (0)

Report

Hi @dpoggemann,
Well my concern here is I have set a filter for a few records based on expiry date <=today and it is a view(Expired Records) and all records for this view is set to inactive. I need the flow to be doing this, so the ones that arent inactive should automatically be active i.e expiry date >=today.

Was this reply helpful? Yes No