Answered

Odata Filter Query Multiple And Operations Not Working

(0) Share

Report

Posted on by Community Power Pla...

I am trying to extract certain people from a list using the Odata Filter Query and its not pulling anyone from the list using my filters.

Can I not use multiple And operations?

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (1)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous you can use multiple AND conditions, what are the column types for txtRegion,FinalApprover and Active ?

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous I tried this with two columns of single line of text and it worked fine

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

I have multiple people from various regions and I only want those whos region = "NA" and "EUSA", are "Active" and who is a FinalApprover.

txtRegion is a single line of txt
FinalApprover is Yes/No field
Active is a Yes/No field

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Trying to pull email addresses from a person group field and when I attempt to use "AND" it fails

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous my question was not answered

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

txtRegion is a single line of txt
FinalApprover is Yes/No field
Active is a Yes/No field

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,187 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous please try this query and let me know if this works
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

What if I wanted the users from both NA and EUSA?

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous add one more row along with AND condition ? Any issues in this ??

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Copy link

Link copied!

Yes, It looks like using multiple "Ands" to extract more than one user from the region isnt allowed.
It returns an empty array.
I was forced to create two Get Items actions to pull users from both EU and NA respectively and the do an Append to Array.

Was this reply helpful? Yes No