web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate ODATA filter using and...

Power Automate

Answered

ODATA filter using and or operator

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Pstork1 69,395 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
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 '検証中')

Was this reply helpful? Yes No

Join the conversation