Prevent re-trigger when a file is modified

[batvan276]

Hello, 

I am trying to set an a value in a SharePoint document library properties to avoid recursion. I am stuck with an invalid expression in update file properties. I am unsure as to what I am doing wrong. 

I have a SP Doc LB I want Flow to check if (Email Sent1) and (EmailSent2) value is No.

If any is NO it will go through the action and eventually update (Email sent1) and/or (Email Sent2) value to Yes. 

This is to avoid re-triggering notification on any . Can someone help me out please?

[Gopala_Krishna · Accepted solution]

@batvan276 

The flow will always try to trigger itself when ever there is change that happens which satisfies the trigger condition.

If you want the flow to trigger only at certain times but not all the times, then you can make use of trigger conditions., these will help you to trigger flow only when a condition is met.

For information related to configuring trigger conditions please check the link - Tip : Using Trigger Conditions in Power Automate - Power of Power Platform

You can also make use of the action "Get Changes for an item or file" which will help you retrieve what columns have got modified, based on this you can configure the condition to check only if data in one specific column is modified trigger the flow.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved

[batvan276]

So I decided to try some trigger conditions ; 

@equals(triggerBody()?['Status']?['Value'], 'Resolved')

@equals(triggerBody()?['Modified By']?['DisplayName'], 'mydisplayname')

I basically want it to only trigger when field under Status = Resolved and field under Modified by = Mydisplayname . It won't trigger when I make the change.