Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

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.

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

Like
a
(0)

Report
Copy link

Link copied!

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

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

Like
a
(0)

Report
Copy link

Link copied!

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

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

Like
a
(0)

Report
Copy link

Link copied!

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']

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

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

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

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

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

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

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

Was this reply helpful? Yes No