ADF Filter Activity Error with Expression....

Question

Hi! @Nasreen Akter @MartinJaffer-MSFT

I need to use a FILTER ACTIVITY with the following expression. I'm wanting to say if the first part in the parens are true and the item().classcode = 'EMP" is true.....

and(@contains(createArray('BCO','BED','BSC','BNB'),item().company), equals(item().classcode,'EMP'))

for the filter

But getting this error:
Warning
Expression of type: 'String' does not match the field: 'condition'

Please suggest...thanks! Mike Kiser

Answer 1

Hi again @Mike Kiser .

Simple typo mistake. Move the @ in front of the and.

@ANDO (contains(createArray('BCO','BED','BSC','BNB'),item().company), equals(item().classcode,'EMP'))

because you had the @ between "and" and "contains", the whole thing started to look like a string. "andtrue" or "andfalse". The evaluation started after "and".