web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ODATA filter query wit...
Power Automate
Answered

ODATA filter query with drop down?

(0) ShareShare
ReportReport
Posted on by 54

I recently got help from someone regarding ODATA Filters, but their filters look a little different than mine. This is what theirs looks like:

stolliver_0-1699396904424.png

 

And this is what mine looks like:

stolliver_0-1699397652667.png

 

How do I get that dropdown menu in the filter query?

 

Categories:
  • Verified answer
    Rhiassuring Profile Picture
    8,692 Moderator on at

    They were just using a different version of the editor.

     

    Click into the field and type the internal name of your field (I can see "Date report.." but I can't see the full thing, but it would be something like Date_x0020_Report) then eq and then two 's. Like this:  Date_x0020_Report eq ''.

     

    Then click between the two ''s, and click on "Add dynamic content" (bottom right hand corner) and then click the Expression tab. This is where you'll paste the formula you have highlighted in yellow, and then press OK. It will show the expression in a little purple box between the 's.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 414

#2
11manish Profile Picture

11manish 331 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard