Skip to main content

Notifications

Community site session details
Power Automate - Power Automate Mobile App
Answered

"or" expression syntax

Like (1) ShareShare
ReportReport
Posted on 27 Nov 2017 20:33:59 by 33

I am trying to create a conditon in Flow where I look at a field in a sharepoint list and if the data in the field is either "open' or "pending" the conditon is true.

 

However, I an struggling to understand the "or" expresion syntax within flow

 

Can someone help explain what is needed in the expression1 and expression2?

 

thanks,

 

Todd

 

  • Verified answer
    v-xida-msft Profile Picture
    on 28 Nov 2017 at 09:32:33
    Re: "or" expression syntax

    Hi @thanke,

     

    Could you please share a screenshot of your flow’s configuration?

    Which data type does the field that you mentioned belong to in your SharePoint list?

    Further, could you please show a bit more about expression1 and expression2?

    I have created a SharePoint list on my side and the list include the filed which is a Choice type column. The value of Choice type column includes “Open”, “Pending” and “Complete”.

     

    I have made a test on my side and please take a try with the following workaround:15.JPG

    Within Condition box, click “Edit in advanced mode”, type the following formula:

     

    @or(equals(items('Apply_to_each')?['Status']?['Value'], 'Open'),equals(items('Apply_to_each')?['Status']?['Value'], 'Pending'))

     

    The flow works successfully as below:14.JPG

     

    More details about Or expression, please check the following article:

    https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

     

     

    Best regards,

    Kris

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Power Automate Mobile App

Overall leaderboard

Featured topics

Loading complete