Run Flow when Sharepoint list item is created and when only certain Sharepoint list columns modified

[kramer]

I have a flow that I need to run when a Sharepoint list item is created or modified but in that same flow I need to update one of columns causing an infinite loop. Is there a way to specify that I only want the flow to run if certain columns in the Sharepoint list is modified and when any item is created in that list? 

Here is the list:

So in the flow I need to update the Event Status Column, but still need to run the flow anytime an item is created/modified to that list (Which event status default to Waiting for first approval when item is created). But if the Event Status is modified I don't need to run the flow again. Any help with this is greatly appreciate? 

[Alex_10]

@kramer 

your flow updates only 1 column (Event Status Column) and that column is a single choice column?

If yes, you may add a Condition action in your flow.

Left value of the condition: triggerOutputs()?['body/YourEventStatusColumnInternalName']?['Value']

Middle: is equal to

Right value of the condition: "YourUpdatedStatusName"

then place Update Item action into 'If no' branch. 'If yes' branch is empty.

[kramer]

Unfortunately , It isn't a Boolean. There are 4 different options.

[kramer]

Sorry I may have misunderstood that. This is what I have now 

[kramer]

Ok so I changed it to this but it is still saying I am going to have an infinite loop

Unless I have my condition wrong? Is this correct for that if statement you mentioned aboved ?

triggerOutputs()?['body/EventStatus']?['Value']

[v-liwei-msft · Accepted solution]

Hi @kramer 

You can add an action named Get changes for an item or a file (properties only) under the trigger, this action can return whether a column has been changed.

You can add a condition when:
1. Whether a specific column is modified:

or
2. The modification time is equal to the creation time (proving that the current item is newly created and not modified):

Terminates the stream if the condition is not met.

Best Regards,

Levi

[kramer]

Would you still get the warning because I am still receiving that

[v-liwei-msft]

Hi @kramer 

If the field you update in the update item is not the field you want to trigger the flow, you can ignore the warning.

Best Regards,

Levi

[v-liwei-msft]

Hi @kramer 

So sorry I just found out I posted the wrong info in my last comment.
I have changed my last comment.
Sorry again.

Best Regards,

Levi