Need to use OR and CONTAINS

(0) Share

Report

Posted on by Community Power Pla...

I need to create a condition that does the following:

ApplicationStatus field does not contain "Status A" OR "Status B" OR "Status C"

How would this look in Advanced Mode?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

faustocapellanj 1,662 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

Your condition might look like the expression below:
@or(not(contains(triggerBody()?['ApplicationStatus'], 'Status A')),not(contains(triggerBody()?['ApplicationStatus'], 'Status B')),not(contains(triggerBody()?['ApplicationStatus'], 'Status C')))
One way you can learn to build these types of expressions is by creating the condition in basic mode and then switch to advanced mode. Copy the expression and paste it in your favorite text editor; I use Notepad++. Also, check out the Workflow Definition Language scheme for Azure Logic Apps since all the Flow expressions are based on them. In your case, check out the Logical Functions section.

Regards,
Fausto Capellan, Jr

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

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

Further, could you please show a bit more about the ApplicationStatus field that you mentioned?

I agree with @faustocapellanj's thought almost, I assume that the ApplicationStatus column is a Choice type column, I have created a SharePoint list on my side and the data structure of it as below:

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

Add a "When an item is created" trigger.

Add a Condition, click "Edit in advanced mode", type the following formula:

@or(not(contains(triggerBody()?['ApplicationStatus']?['Value'], 'Status A')),not(contains(triggerBody()?['ApplicationStatus']?['Value'], 'Status B')),not(contains(triggerBody()?['ApplicationStatus']?['Value'], 'Status C')))
Within "If/yes" branch of Condition, add a "Send me an email notification" action.

Image reference:

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No