Skip to main content

Notifications

Power Automate - General Discussion
Answered

Checking an AND or OR conditons

(0) ShareShare
ReportReport
Posted on by

 

Hi

 

 I want to evaluate the two condidtions when a certain SharePoint list item is added so add a OR clause include  'High'  .   If there is documentation can you reply with a link. 

 

My code below is invalid btw  ( and yes I tried an OR' as well  !)

 

@equals(triggerBody()['RequestorUrgency']['Value'], 'Urgent') ||  @equals(triggerBody()['RequestorUrgency']['Value'], 'High')

 

Daniel

  • Re: Checking an AND or OR conditons

    Ahhhhhh not for the first time in my life: I don't know who I am!Smiley Mad  I have one identity based ony my client's tenant and one based on my tenant. Ideally I just want to use my Live ID and either remove the one for my tenant or merge it.

  • v-micsh-msft Profile Picture
    v-micsh-msft on at
    Re: Checking an AND or OR conditons

    Hi @westerdaled,

     

    Sorry about that.

    I thought you were @Anonymous, is that account alos belongs to you?

    The Accept as solution would only show up for the question asker.

     

  • westerdaled Profile Picture
    westerdaled 613 on at
    Re: Checking an AND or OR conditons

    @v-micsh-msft @micheal

     

     

    Yes but how do I do that ..  I can book mark the post and give Kudos but I don't the option to mark as a solution.

  • v-micsh-msft Profile Picture
    v-micsh-msft on at
    Re: Checking an AND or OR conditons

    Glad to help.

    would it be convent for you to accept the proper post as the solution?

    Doing this should be helpful for the others to find the proper answer more quickly.

     

    Regards,

    Michael

  • Verified answer
    westerdaled Profile Picture
    westerdaled 613 on at
    Re: Checking an AND or OR conditons

    @v-micsh-msft wrote:

    Daniel,

     

    Please specify the condition in the format below:

     

    @or(
     equals(triggerBody()['RequestorUrgency']['Value'], 'Urgent'),
     equals(triggerBody()['RequestorUrgency']['Value'], 'High')
     )

    If the 

    triggerBody()['RequestorUrgency']['Value']

    Could return the proper value, then writing the formula in this way should work.

    Currently there is no specifial documentation talking about how to write formula under the condition Advanced mode.

    For the workflow definition language reference, please check:

    Workflow Definition Language schema for Azure Logic Apps

    Regards,

    Michael


     

     

    Thanks very much for the heads up on the correct syntax i should use.

    Hopefully this will help others as it simplies their flows.

     

    Daniel

  • v-micsh-msft Profile Picture
    v-micsh-msft on at
    Re: Checking an AND or OR conditons

    Daniel,

     

    Please specify the condition in the format below:

     

    @or(
     equals(triggerBody()['RequestorUrgency']['Value'], 'Urgent'),
     equals(triggerBody()['RequestorUrgency']['Value'], 'High')
     )

    If the 

    triggerBody()['RequestorUrgency']['Value']

    Could return the proper value, then writing the formula in this way should work.

    Currently there is no specifial documentation talking about how to write formula under the condition Advanced mode.

    For the workflow definition language reference, please check:

    Workflow Definition Language schema for Azure Logic Apps

    Regards,

    Michael

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,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard