Unanswered

Multiple conditions in Filter Array

(0) Share

Report

Posted on by Palucci12

Hello All,

I would like to add two conditions to the Filter Array to filter my columns, but I get this error and I don't know where I made the mistake.

@And(equals(item()?['Employment_x0020_status'], 'Active'), equals(item()?['Employment_x0020_status', 'long absences'))

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Sort by

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

Well, what jumps out at me is that logic doesn't make sense. You're saying Employment Status must equal Active and long absences? Do you maybe mean or?

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!
I would like to extract all elements into lists with Active or long absence in the column . I tried with Or but same results

@Anonymous(equals(item()?['Employment_x0020_status'], 'Active'),equals(item()?['Employment_x0020_status'], 'long absences'))

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you perform the filter directly in the Get Items?

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!

And if these are Choice columns? is it not a problem ?

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!

I got error :

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answers, I did it this way and the result is good, can you help me and is it even possible? I will save this filter array in get items as in filter query as one code so as not to do so many actions

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are those more filters you want to put on the Get Items?

It is the same thing, just keep adding the filter statements into the Get Items Filter Query field.

(Employment_x0020_status eq 'Active') or (Employment_x0020_status eq 'long absences) and (HC eq 1) and (Employeecontracttype eq 'tk GSG')

You might have to test the parentheses around the conditions, but it should keep working as a filter.

Maybe try

(Employment_x0020_status eq 'Active' or Employment_x0020_status eq 'long absences) and (HC eq 1 and Employeecontracttype eq 'tk GSG')

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!

Your two suggestions trigger a query invalid error. I'll try again with these parentheses

Was this reply helpful? Yes No
Nunya1 77 on at

Like (0)

Report
Copy link

Link copied!

I am no expert, (actually looking for answers on a problem I'm having), but it looks like your code is missing a closing square bracket after 'Employment_x0020_status'> ['Employment_x0020_status']

Was this reply helpful? Yes No