question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

@Contains in ADF Pipeline Urgent Issue

Hello! @nasreen-akter @MartinJaffer-MSFT
I have an IF Activity in my pipeline....the logic should be

. If this field = "P"or"B" then send "No" else send "Yes"

I am really having issues with the @Contain function for this IF Activity.....its the "OR" Expression that I can't get correct.

Your assistance is always appreciated!
Mike Kiser

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MartinJaffer-MSFT avatar image
1 Vote"
MartinJaffer-MSFT answered ewinkiser commented

Hello again @ewinkiser . Is the below what you are looking for?

 @if( or(equals(pipeline().parameters.value,'P'),equals(pipeline().parameters.value,'B')),'No','Yes')

 @if( contains(array(pipeline().parameters.value),['P','B']),'No','Yes')
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hey @MartinJaffer-MSFT , exactly!! I don't know why the expressions are so difficult for me. You should write a book giving lot's of examples on ADF Expressions :-) the docs from MS do not have very complex examples. Thanks again so much for your help!! We are in QA and I don't have the time I had in development. I'm sure you know what I mean :-)

Thanks again @MartinJaffer-MSFT !!

Mike Kiser

0 Votes 0 ·