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

(0) Share

Report

Posted on by vsolanon

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 🙂

All responses (6)

Answers (1)

Prana006 6 on at

Like (0)

Report

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

I am facing the same problem, Someone please help me. This condition breaching and triggering an email.
Community Power Pla... on at

Like (0)

Report

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

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?
vsolanon 146 on at

Like (0)

Report

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

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 🙂
Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like (3)

Report

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

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.
v-alzhan-msft on at

Like (1)

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

Hi @vsolanon ,

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

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.
ChristianAbata 8,947 Most Valuable Professional on at

Like (0)

Report

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

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.