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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to write a odata q...
Power Apps
Unanswered

How to write a odata query for PowerAutomate?

(0) ShareShare
ReportReport
Posted on by 166

Hello together,

i am starting to build two workflows but i fail to write a filter query for a sharepoint list.

 

Case #1

The Column Abholer is of type person/contact. I want to filter empty entries. I tried something like this, but i failed:

Abholer eq null (null as function)

Abholer eq ''

 

Case #2

The Column Abholdatum is of type date/time. I want to filter empty entries. I tried similar to case #1, but also failed.

 

Hope, somebody can help me.

Jürgen

Categories:
I have the same question (0)
  • Verified answer
    NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    HI @JürgenD ,

    You can use below formula - 

    Abholer/EMail eq null and Abholdatum eq null
    Make sure you use internal column name

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard