Hello! @Nasreen Akter @MartinJaffer-MSFT As usual, I am having trouble with an Expression in a Filter activity... I want to say if all employees with @item.Company = BCO, BED, BSC, and BNB proceed...all others filter out but I can't get the syntax correct....have worked on this for a while... This is what I tried: @or(contains(item().company,'BCO'),contains(item().company,'BED'), contains(item().company,'BSC'), contains(item().company,'BNB')) But doesn't work.... Thanks! Mike

Hi @Mike Kiser , The following expression might help. Thanks! @contains(createArray('BCO','BED','BSC','BNB'), item.Company)

@Contains expression issue...please help....

Accepted answer

Nasreen Akter 10,751 Reputation points

2021-04-13T17:43:20.957+00:00
Hi @Mike Kiser ,

The following expression might help. Thanks!

@contains(createArray('BCO','BED','BSC','BNB'), item.Company)
Please sign in to rate this answer.
Mike Kiser 1,531 Reputation points

2021-04-13T18:29:35.173+00:00

@Nasreen Akter

Thanks so much! however I am getting the following error and I have company coming back in a LookUp function.....any suggestions?

@contains(createArray('BCO','BED','BSC','BNB'), item.company)

I used the following in the Filter activity and it should be working....any ideas? Thanks!!! Mike

Nasreen Akter 10,751 Reputation points

2021-04-13T18:46:20.037+00:00

@Mike Kiser , In the expression, please use Company from Lookup activity instead of item.Company.

MartinJaffer-MSFT 26,026 Reputation points

2021-04-13T18:47:26.077+00:00

@Nasreen Akter @Mike Kiser

item is a pseudo-function, like activity. unlike activity it does not take any arguments.

you want to use

item().company

Mike Kiser 1,531 Reputation points

2021-04-13T19:50:30.31+00:00

Thanks all! @MartinJaffer-MSFT @Nasreen Akter

Works perfectly!!! Thanks so much. We are getting ready to go live with a new ADF centric application and I am having to fix QA bugs. I just got another change (these are killing me lol)...

@contains(createArray('BCO','BED','BSC','BNB'),item().company)

I need to say now the above AND if Classcode = 'EMP" for the filter....

Just guessing, would I say:
@contains(createArray('BCO','BED','BSC','BNB'),item().company) && item().classcode = "EMP" or something like that?

Thanks again!
Mike

Nasreen Akter 10,751 Reputation points

2021-04-13T19:54:30.593+00:00

@Mike Kiser : would you please share with us the expression and the input schema from where "company" is coming (i.e., activity/forloop).

Mike Kiser 1,531 Reputation points

2021-04-13T21:19:16.087+00:00

Hi @Nasreen Akter

I got that working....awesome...thanks...now I just got a requirement late for the following:

@contains(createArray('BCO','BED','BSC','BNB'),item().company) WORKS GREAT!!!

I need to say now something like 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'

Thanks!
Mike
Sign in to comment

@Contains expression issue...please help....

0 additional answers