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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Combine multiples Or a...
Power Automate
Answered

Combine multiples Or and And in the Filter Query (Get Item

(0) ShareShare
ReportReport
Posted on by 146

Hi Experts!

 

I am trying to apply the below logic to the Filter Query, however, it is not working. When I run my Flow, it doesn't bring any information.

(SSNReceived eq 'No' or SINReceived eq 'No') and (GeneralStatus eq 'In Process' or GeneralStatus eq 'Completed')

 

I have three columns within the SP List:  (1)"SSNReceived" which is a single line of text column, (2)"SINReceived" which is a single line of text column and  (3)"GeneralStatus" which is a choice column.

Could you please how can I bracket these statements? I have tried multiple ways without success,

 

Thank you in advance 🙂

 

Categories:
I have the same question (0)
  • ChristianAbata Profile Picture
    8,953 Most Valuable Professional on at

    hi @vsolanon  in my experience you can add just one conditional just and/or

    If you try

    SSNReceived eq 'No' or SINReceived eq 'No'

     

    Sure this is going to work well.

  • v-alzhan-msft Profile Picture
    Microsoft Employee on at

    Hi @vsolanon ,

     

    I suggest that you could take a try with the filter Array action as my screenshot below:

    1.png

     

    The expression in the Filter Array as below:

     

    @and(or(equals(item()?['SSNReceived'], 'No'), equals(item()?['SINReceived'], 'No')),or(equals(item()?['GeneralStatus']?['Value'], 'In Process'), equals(item()?['GeneralStatus']?['Value'], 'Completed')))

     

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    DeepakS Profile Picture
    2,301 Most Valuable Professional on at

    Hi @vsolanon 

     

    i tried to replicate your issue and its working for me :

    my setup:

    List - Sample List

    TextCOL - Text column

    TextCOL2- text colum

    CHSCOL- choice column

    my list has 5 items , and after applying filter i get only 2. 

    I would suggest you to run the get items with no filter and check how the values are getting returns in the columns that you are using for filter.

    filterquery.pngfilterquery2.png

     

     

     

     

  • vsolanon Profile Picture
    146 on at

    Thank you all for the comments!

     

    Kindly note today I open today the Flow and delete and paste the formula in the FilterQuery..it runs and it work like a Charm! 🙂

     

    As @DeepakS mentioned, I verified the values used in the FilterQuery and noticed they were correct 🙂

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Does this only work with eq, I am trying a filter using contains but that does not seem to work. 

    If I chance the filter from contains to eq, it works fine!

     

    Is anyone familiar with this issue? 

  • Prana006 Profile Picture
    6 on at

    I am facing the same problem, Someone please help me. This condition breaching and triggering an email.

    Prana006_0-1684859333742.png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard