Solved: Odata Filter for null value in date column

Hi guys,

I have been trying every troubleshooting step I could think of,. Yet, I just can't seem to figure out what is wrong.

I am working on a an app for visitormanagement. Basis for the app is a sharepoint list. In the sharepoint list I have several columns. One of which is "Check-Out_at". Another one is "Check-In_at". Those columns are formated to date incl. time. Some others are "FirstName", "LastName", etc., which a formated to single line of text.

I am trying to build a recurring flow in which a list of all visitors, who have not cheked out yet is being send via email.

In my Flow, I filter the sharepoint list with OData query: Check-Out_at eq null. According to every ressource I found online, this should work. Alas, it doesn't. I have tried changing the name of the column, as I thought maybe the hyphen causes some issues. No luck. I have tried running the exact same formula on a column which is formated to single line of text and it works fine. The only conclusion I can draw, is that for some reason "null" in date formated columns does not work.

The error returned is:

My questions, I guess, to the community are: Has anyone else seen this issue before? Can anyone confirm this behaviour? Is there a simple and or obvious workaround for this?

Thank you and good night,

gonzo

Categories:

General Questions