cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaina
Resolver II
Resolver II

OData Filter Get Items combining multiple And and OR

Hi Dears,

 

Kindly help. I have a list with below columns:

jaina_0-1627614065825.png

 

Here's my sample data:

jaina_2-1627614397873.png

 

Expected Output:

jaina_3-1627614631482.png

 

 

 

My objective is to filter the following combination for me to update the Status to Expired

jaina_0-1627615520578.png

 

Currently, this is how I set my filters which gives me wrong output:

jaina_4-1627614720979.png

 

Here's my flow:

 

jaina_5-1627614828553.png

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hi @v-LilyW-msft ,

 

Thanks for responding, I've tried that already but the expected result is not correct. For some reason, ne is not working. It captures the completed status and rejected status items. 

 

I update my Filter using EQ, stating all pending status.. and it is now working.

 

 

jaina_0-1627622522298.png

 

 

 

View solution in original post

Hi @jaina 

Have you changed this or to and?

vLilyWmsft_0-1627622713515.png

Like this

vLilyWmsft_1-1627623220658.png

Best Regards

View solution in original post

4 REPLIES 4
v-LilyW-msft
Community Support
Community Support

Hi @jaina 

Please change the Filter Query as below and try again:

Status ne 'Completed' and Status ne 'Rejected' and Duedate le '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'

vLilyWmsft_0-1627622331587.png

my test result :

vLilyWmsft_3-1627621897602.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi @v-LilyW-msft ,

 

Thanks for responding, I've tried that already but the expected result is not correct. For some reason, ne is not working. It captures the completed status and rejected status items. 

 

I update my Filter using EQ, stating all pending status.. and it is now working.

 

 

jaina_0-1627622522298.png

 

 

 

View solution in original post

Hi @jaina 

Have you changed this or to and?

vLilyWmsft_0-1627622713515.png

Like this

vLilyWmsft_1-1627623220658.png

Best Regards

View solution in original post

Thanks, I tried to make it all AND using NE and it is now correct. 

 

Thank you! 🙂 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,365)