@and inside filter activity

Question

Hello,
Inside the pipeline, after the lookup, I have a filter activity inside which this condition works

Expression:

------------

@ANDO (
equals(item().OName, variables('vOName')),
equals(item().PName, variables('vPName'))
)

Question

What is the expression to have three equalities
(OName = vOName and PName = vPName and DName = vDName)

Perhaps something like below? but it does not work:
@ANDO (
equals(item().OName, variables('vOName')),
equals(item().PName, variables('vPName')),
equals(item().DName, variables('vDName'))
)

Answer 1

Hello @arkiboys ,

Thanks for the question and using MS Q&A platform.

As we understand the ask here is that you would like to validation 3 conditions using and function in ADF but it is throwing an error. Please correct if I'm not accurate.

The AND function in ADF only accepts only 2 arguments [for eg: and(<expression1>, <expression2>)]. If you pass more than 2 arguments, it will throw an error.

For your scenario you can have additional and function to validate if the 3 conditions are true. See below sample:

@and(and(equals(item().OName, variables('vOName')),equals(item().PName, variables('vPName'))), equals(item().DName, variables('vDName')))

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators