cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tiffany-Jo
Level: Powered On

ODATA filter using and or operator

Hi

 

I would like to confirm if that can be realized if I set  ODATA filter of Get Items as below.

status is Choices column.

We hope to filter the item which Open Date > Today and Status is '協議中' or '検証中'.

 

Open_x0020_Date gt '@{utcNow()} 'and Status eq'協議中' or Status eq '検証中'

 

キャプチャ.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: ODATA filter using and or operator

OData filters will work with And & Or, but you will need to add some parentheses to group the clauses appropriately.  It should look something like this

Open_x0020_Date gt '@{utcNow()}' and (Status eq'協議中' or Status eq '検証中')


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
Dual Super User
Dual Super User

Re: ODATA filter using and or operator

OData filters will work with And & Or, but you will need to add some parentheses to group the clauses appropriately.  It should look something like this

Open_x0020_Date gt '@{utcNow()}' and (Status eq'協議中' or Status eq '検証中')


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,383)