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?
Solved! Go to 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
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']
Unfortunately , It isn't a Boolean. There are 4 different options.
Sorry I may have misunderstood that. This is what I have now
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 ?
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
Would you still get the warning because I am still receiving that
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
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
User | Count |
---|---|
258 | |
108 | |
93 | |
57 | |
41 |