Hello,
In my Sharepoint List I'm trying to retrieve this entry:
I need the extra AND condition for the Date released column to be empty because the following scenario can happen:
| Doc Reference | Date released |
| ENOWA-WTD-ARC-BOQ-01 | 01/22/2024 |
| ENOWA-WTD-ARC-BOQ-01 | 01/22/2024 |
| ENOWA-WTD-ARC-BOQ-01 | |
So then my Get Items action will only return an array with the green entry.
I have tried the following:
But this gives a bad request:
String was not recognized as a valid DateTime. Creating query failed
Or:
The string was not recognized as a valid DateTime. There is an unknown word starting at index 0. Creating query failed.
Obviously this wouldn't work as it just sees null as a actual string.
Can somebody help me with this filter query?
