web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Odata Filter Query Mul...
Power Automate
Answered

Odata Filter Query Multiple And Operations Not Working

(0) ShareShare
ReportReport
Posted on by

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.

Chrislond58_0-1619959451192.png

Can I not use multiple And operations?

Categories:
I have the same question (0)
  • jinivthakkar Profile Picture
    4,187 on at

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

  • jinivthakkar Profile Picture
    4,187 on at

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

    jinivthakkar_0-1620050213662.png

     

  • Community Power Platform Member Profile Picture
    on at

    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

  • Community Power Platform Member Profile Picture
    on at

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

  • jinivthakkar Profile Picture
    4,187 on at

    @Anonymous my question was not answered 

  • Community Power Platform Member Profile Picture
    on at

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

  • Verified answer
    jinivthakkar Profile Picture
    4,187 on at

    @Anonymous please try this query and let me know if this works

    jinivthakkar_0-1620059159799.png

    --------------------------------------------------------------------------------
    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.

     

  • Community Power Platform Member Profile Picture
    on at

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

  • jinivthakkar Profile Picture
    4,187 on at

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

  • Community Power Platform Member Profile Picture
    on at

    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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard