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
