cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stvcdms
Level 8

How do you use AND?

Hey,

 

I can't seem to get the AND to work in some conditional logic. It keep giving me an expression error for the following snippet:

 

@and(not(contains(triggerBody()?['Subject'], 'RE:')), not(equals(triggerBody()?['From'], 'someone@anywhere.com')))

 

Any idea?

4 REPLIES 4
Highlighted
Microsoft Employee

Re: How do you use AND?

Hi stvcdms,

What did you add the snippet in?

You could check if there is logic error in the snippet.

And you could type the snippet manually.

More reference:

And, Or, and Not functions in PowerApps.

https://powerapps.microsoft.com/en-us/tutorials/function-logicals/

Best regards,

Sara Fan

 

stvcdms
Level 8

Re: How do you use AND?

Hello,

 

Since it won't make a compound conditional for me, what I added is in bold.

 

@and(not(contains(triggerBody()?['Subject'], 'RE:')), not(equals(triggerBody()?['From'], 'someone@anywhere.com')))

 

Perhaps also interesting is now the condition will not work period, even if it's reverted the condition will get an evaluation failure, which I think is a bug.

 

Steve

efialtes
Level 8

Re: How do you use AND?

@stvcdms Please note the following thread reports problems when editing Conditions in Advanced Mode. However, it used to work on May-June 2016 timeframe

 

https://powerusers.microsoft.com/t5/Flow-Forum/Flow-Conditions-Instantly-Fail-In-Advanced-Mode/m-p/5...

Flow Staff Sunay
Flow Staff

Re: How do you use AND?

@stvcdms : It seems like you are using the "On new email" trigger, you could in the advanced mode on the trigger, fitler emails by subject and sender to achieve the scenario you are trying to articulate using the expression. In the meanwhile, we will investigate on our side why exactly your expression seems to fail.

 

Sunay

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 472 members 5,532 guests
Recent signins:
Please welcome our newest community members: