Get Items ODATA Filter for Date field not blank

(0) Share

Report

Posted on by Gerard Simpson

2,987 Moderator

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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

TaylorBecktold 295 on at

Like (3)

Report
Copy link

Link copied!

@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.

1 people found this reply helpful.

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Taylor_Becktold - thanks for your response

I tried that approach as follows:

And it came up with the following error:

Any ideas? - Thanks

Was this reply helpful? Yes No
Verified answer

TaylorBecktold 295 on at

Like (1)

Report
Copy link

Link copied!

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.

1 people found this reply helpful.

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

Many thanks @Taylor_Becktold !

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

Was this reply helpful? Yes No