Get items returning bad request error message on filter query for null date/time field on SharePoint list

[MattJ]

Hi All, 

can anyone help me with resolution of this issue. 

Doing a filter query for empty date time fields on a SharePoint list and it is always returning bad request message after running. 

Details as below

Get items with filter queryBad request error message after running flow

Downloaded output message 

https://prod-21.australiasoutheast.logic.azure.com/workflows/b9e13b9ba2f74abc9083795aab87d48f/runs/0...

[Expiscornovus · Accepted solution]

Hi @MattJ,

Is your column name FormallyforwardedtoDepartment_x0? If so, can you try to add the name of the column without the url encoding (%5F) of the underscore character in the filter query?

FormallyforwardedtoDepartment_x0 eq null

[MattJ · Accepted solution]

thanks so much and apologies for the delay in responding and accepting this as the solution.