cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Callum91
Frequent Visitor

When an item is created or Modified function

Hi PA,

 

I am currently using the expression below in the "when an item is created or modified" function to only trigger when an item is modified in a list. Is there a way to only trigger a flow when a certain column in a SharePoint list has been triggered? 

 

@not(equals(triggerbody()?['Created'],triggerbody()?['Modified']))

 

I would like a flow to be triggered when for example the Document Status column changes its value, rather than at the moment I believe it is currently being trigger when any of the columns are being modified which is sending multiple emails

 

Is this Achievable? if so can an example be provided

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @Callum91 ,

 

There are several options for you to implement your needs, please check whether there are methods you can apply.

 

The first is to add an extra column in the list to record whether the value of the status field has been changed when the item is updated. The field type can be Yes/No, and the default value is No. If the user changes the status field, the value of Yes/No needs to be changed to Yes.

 

When configuring Flow, you need to add trigger conditions to check whether the value of the Yes/No field is true, and if so, trigger Flow. In addition, you need to add Update item action in the last step of Flow to restore the value of Yes/No field to No.

 

The second method directly uses For a selected item as the trigger. If the Status field is changed, the user needs to manually trigger Flow.

 

The third way is that you can refer to the following great article to get the item version and check whether the value of the status field in the two versions is different:

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Check-for-a-Change-in-a-SharePoint...

 

Hope that makes sense.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-bacao-msft
Community Support
Community Support

 

Hi @Callum91 ,

 

There are several options for you to implement your needs, please check whether there are methods you can apply.

 

The first is to add an extra column in the list to record whether the value of the status field has been changed when the item is updated. The field type can be Yes/No, and the default value is No. If the user changes the status field, the value of Yes/No needs to be changed to Yes.

 

When configuring Flow, you need to add trigger conditions to check whether the value of the Yes/No field is true, and if so, trigger Flow. In addition, you need to add Update item action in the last step of Flow to restore the value of Yes/No field to No.

 

The second method directly uses For a selected item as the trigger. If the Status field is changed, the user needs to manually trigger Flow.

 

The third way is that you can refer to the following great article to get the item version and check whether the value of the status field in the two versions is different:

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Check-for-a-Change-in-a-SharePoint...

 

Hope that makes sense.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (75,221)