cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmDev
Super User
Super User

Get Items ODATA Filter for Date field not blank

Hi Folks

 

This will be an easy one for somebody!...

 

I'm doing a get items on a projects list and I just want to return those rows that have a date in a date-time column (2 rows in this case) - Please can someone advise the correct ODATA filter syntax in the SPO get items action?

 

Thanks

 

AmDev_0-1639147737464.png

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Taylor_Becktold
Resolver III
Resolver III

@AmDev 

 

For null oData queries I typically use the following: dateTime ne null

 

Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.

View solution in original post

Taylor_Becktold
Resolver III
Resolver III

I would first try removing the single quotes from around your expression. 

 

Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.

View solution in original post

4 REPLIES 4
Taylor_Becktold
Resolver III
Resolver III

@AmDev 

 

For null oData queries I typically use the following: dateTime ne null

 

Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.

AmDev
Super User
Super User

Hi @Taylor_Becktold  - thanks for your response

 

I tried that approach as follows: 

AmDev_0-1639157577320.png

 

 

And it came up with the following error:

AmDev_1-1639157637760.png

 

Any ideas? - Thanks

Taylor_Becktold
Resolver III
Resolver III

I would first try removing the single quotes from around your expression. 

 

Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.

AmDev
Super User
Super User

Many thanks @Taylor_Becktold !

 

I had selected null in the expression editor, instead of just typing it. Much appreciated!

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,046)