Hi @Mike Kiser ,
try OR instead of an AND. e.g.,
@or(or(contains(createArray('BCO','BED','BSC','BNB'),item().company), equals(item().classcode,'EMP')), not(contains(item().status,'Inactive')))
Thanks!
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi @Nasreen Akter @MartinJaffer-MSFT
This filter is filtering out all the good data . I need all the Companies BCO, BED,BSC,BNB to not be filtered out, we need if an employee is EMP to NOT be filtered out and we need if an Employee's status is Active to NOT be filtered out but the below is filtering these. Any suggestions?
@ANDO (and(contains(createArray('BCO','BED','BSC','BNB'),item().company), equals(item().classcode,'EMP')), not(contains(item().status,'Inactive')))
I just failed the first QA Test on the rework and am trying and trying to figure out why this is filtering these employees out.
Any help would be greatly appreciated!
Thanks,
Mike Kiser
Hi @Mike Kiser ,
try OR instead of an AND. e.g.,
@or(or(contains(createArray('BCO','BED','BSC','BNB'),item().company), equals(item().classcode,'EMP')), not(contains(item().status,'Inactive')))
Thanks!
@Nasreen Akter , the strangest thing is that it looks like it filtered out the employee with POI...see attached.....and I am using the following as Items into the ForEach
@activity('Filter Out Inactive').output.value