Answered

Working with Conditions - OR

(0) Share

Report

Posted on by Rob_CTL

Hi,

I've got a shared mail box, lets call is Mailbox1 and 2 SharePoint lists, lets call them Success and Failed.

What I am trying to achieve is that when a mail arrives at Maibox1 it is picked up by a Flow. The flow looks at the subject line of the email and this will determine which list the email gets sent to. If the subject line contains either the word "success" or "Successful" it will get sent to the "Success" SP list. If the subject line contains anything else then it will go to the "Failed" SP list.

Can I put an "OR" in the @contains condition? at the moment I just have the one word, success but I'd like to add an OR to also look for "successful"

Current condition query:

@contains(triggerBody()?['Subject'], 'success')

Any help gratefully received.

Rob

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi Rob_CTL,

Please check the part Logical functions about Or in this doc on workflow definition language for a reference:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

In your case, the function might be configured as:

@or( contains(triggerBody()?['Subject'], 'success') contains(triggerBody()?['Subject'], 'successful') )

Please try it on your side.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Rob_CTL on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply Mabel. It appears that the original query is working as is, I thought the condition was explicit but it appears it isn't. You learn something new everyday 🙂 However your code will be useful for some other stuff I am trying so thank you for that.

Was this reply helpful? Yes No
Rob_CTL on at

Like (0)

Report
Copy link

Link copied!

Hi Mabel

I've just had a play with the code and it's throwing an error stating that the query failed with "Unable to parse template language expression"

Any thoughts?

Thanks
Rob

Was this reply helpful? Yes No
Verified answer

Rob_CTL on at

Like (0)

Report
Copy link

Link copied!
I spoke to soon, spotted the issue....the code is missing a , after 'success')

This works:

@or(contains(triggerBody()?['Subject'], 'success'),contains(triggerBody()?['Subject'], 'successful'))

Was this reply helpful? Yes No