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 🙂

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
vsolanon 146 on at

Like (0)

Report
Copy link

Link copied!

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 🙂

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

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Prana006 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No