Answered

When a file is created or modified trigger condition (properties only) loops

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to use trigger conditions to prevent my flow from looping. My scenario is a user uploads a document, it puts it in the checked out state while the user fills out the required metadata. I currently have this (below) to only trigger if the "change" is selected in the choice column and then my approval starts, however, if anyone modifies the document throughout the approval processes, it causes the workflow to trigger again.

@equals(triggerBody()?['Type_x0020_of_x0020_Request']?['Value'], 'Change')

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous So you are triggering flow when someone change column value as 'change'. And column value is remain as change then i think it is causing to multiple runs.

You need to create one Multiple line of text column name-StopRun and select these option

then use this in trigger condition- @equals(triggerBody()?[‘StopRun’],null) (pls type this in trigger condition, do not copy paste)

After that use one update action and set column value as NoRun.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes I am using a choice column value as "change", thank you for the quick response I will try the suggestion and report back.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks again, those options are only available in a list, this is a document library, however I tried anyway and it continued to loop.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous Share your flow screens and SharePoint list column.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If you need the rest I can share, its just the approval. This is a document library, not a list

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous why are you using this trigger condition now-

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

When I removed, the workflow triggers twice, once when file is uploaded to the document library and then again when the metadata is added.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous Yes it will trigger when there is a change in your document library item.

Do you want to trigger flow based on column value change?

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, so when an file is uploaded, it prompts to user to enter in meta data. I have a column choice (3 options in it). I have created a flow for each option, those options are, New Hire, Change, Transfer. If the user clicks on change, saves/submit, it will then kick start that approval process for that document based on the input from the user (in this example change). It felt easier to separate the approval processes for each selection then have it nested under one flow.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

is it possible to add another condition to make it only trigger based on the person who created it? So that when others make changes to the documents it won't trigger again?

Was this reply helpful? Yes No