Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Trigger Condition Using Yes/No Field in SharePoint List

(1) ShareShare
ReportReport
Posted on by 2
I am new to Power Apps/Automate and having an issue triggering my flow with a trigger condition.  Seems basic enough, but I am clearly missing something.
 
I have a List in SharePoint and one of the fields is IsSubmission of the Yes/No data type.  I want to use this field to trigger my flow if it is Yes.
 
I have the When an item is created or modified action with the trigger condition @equals(triggerBody()?['IsSubmission']?['Value'],true)
 
When I submit a new item via my Power Apps form, it is not triggering the flow.  The IsSubmission field is checked or marked Yes.  Any ideas what is failing here?
 
 
 
 
Categories:
  • Suggested answer
    Expiscornovus Profile Picture
    Expiscornovus 31,139 on at
    Trigger Condition Using Yes/No Field in SharePoint List
    David_MA already gave you a great solution approach which should work well.

    I just wanted to add that the format of the IsSubmission field output value is already a boolean. So, in this case you can simplify the expression by just using:
    triggerOutputs()?['body/IsSubmission']
     
  • Suggested answer
    David_MA Profile Picture
    David_MA 9,039 on at
    Trigger Condition Using Yes/No Field in SharePoint List
    The expression on a yes/no field would look like this: @equals(triggerOutputs()?['body/IsSubmission'], true). The expression you are using looks like what would be used on a choice field since it contains ['Value'] as part of the expression. And the start of the expression doesn't look correct to me. It is a good practice to add a compose action to your flow and build the trigger condition with the expression builder. You can then test it to make sure it returns true/false. Once you test it, you just need to copy the expression and add "@" before it in the trigger condition.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard