Need help with Trigger Condition expression

[jpatrick327]

I have a SharePoint List "When Item is Created or Modified" flow that I wish to run only when the value of a Yes/No column named 'Notify' in that record is true.  With no Trigger Condition specified, the flow functions as expected, however, it executes with any modification.  Following several examples, I input the following expression in the Trigger Condition field:

@equals(triggerBody()?['Notify'], true)

This does not appear to be the correct syntax, as the expression always evaluates to false, and the flow is never executed. Can someone please help me with the correct syntax for the Trigger Condition to achieve what I'm trying to do?  Obviously, I can check the value inside the flow using a Condition step, but I would prefer not to execute the flow at all unless that condition is met (save on unnecessary executions).

Thanks!

[ManishSolanki]

Hi @jpatrick327 

Pls try below expression:

@equals(triggerOutputs()?['body/Notify'], true)

pls verify if 'Notify' is the internal name of 'yes/no' column in SharePoint list.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[jpatrick327]

Sadly, that didn't work. 

I checked the List Settings and, looking in the URL for the column, it shows:
FldEdit.aspx?List=%7B884953DF-9A29-409E-9BF5-BB9871C83264%7D&Field=Notify
So, I assume the name 'Notify' is correct.

I also entered the proposed expression into an "initiate variable" step so that I could see that the expression was evaluating to, and it reported "false" regardless of the value of the 'Notify' field.  This suggests that something is wrong with my syntax.

Any other suggestions?

[ManishSolanki]

Hi @jpatrick327 

Could you please share the screenshot(s) of the flow in edit mode?

Thanks

[jpatrick327]

The flow itself is not the problem.  It works perfectly when it runs.  However, when the 'Notify' column is true, the flow performs some actions and then sets the 'Notify' flag to false to prevent it from performing those actions again when other modifications are made to the item.  This change, of course, triggers the flow again.  It won't get into an endless loop because the 'Notify' flag is now false, meaning no changes will be made to the item.  But, it does mean that the flow runs twice each time the 'Notify' flag is set to true, and it really only needs to run once.  That's why I'm trying to set a Trigger Condition that looks at the 'Notify' flag first and only executes the flow when that trigger is true.
I have attached screenshots of the SharePoint List settings for the list and the 'Notify' column used in the flow as well as a shot of the Trigger settings dialog.  The syntax shown in the snapshot is the one I saw in several similar examples, but I tried the one you suggested above, and it did not work either.

[jpatrick327]

The example I have referred to several times is shown here in the section called "Keep it Simple Silly".  As shown there, I did try inserting an Initialize Variable step in the flow to test the expression. It is here were I can see that the expressions I'm trying are all evaluating to false even when the value of the Notify column is true.