Announcements
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?
@Anonymous you can use multiple AND conditions, what are the column types for txtRegion,FinalApprover and Active ?
@Anonymous I tried this with two columns of single line of text and it worked fine
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 txtFinalApprover is Yes/No fieldActive is a Yes/No field
Trying to pull email addresses from a person group field and when I attempt to use "AND" it fails
@Anonymous my question was not answered
txtRegion is a single line of txtFinalApprover is Yes/No fieldActive is a Yes/No field
@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.
What if I wanted the users from both NA and EUSA?
@Anonymous add one more row along with AND condition ? Any issues in this ??
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 86 Super User 2026 Season 1
Haque 55
Ellis Karim 53 Super User 2026 Season 1
