Need to Combine 3 filters into 1 .....please assist

Question

Hello! @Nasreen Akter @MartinJaffer-MSFT

Since I need a filtered input to my ForEach, I need to combine 3 filters into one to use as input to my ForEach. I have tried but this take a master of expressions.....Please help me combine the following 3 filters into one:

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

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

Filter
@hamed1374 (contains(item().status,'Inactive'))

I have tried and tried but can not produce only one Filter Criteria...

Thanks again!!
Mike Kiser

Answer 1

Hi @Mike Kiser ,

You can try the following expression. Hope this helps. Thanks!

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