Odata Filter Null

[WiggityZwiggity]

Does anyone know how to use an odata filter on a SharePoint Get Items action to filter out items with a null value in a text/string column?

I have tried: text_x0020_field ne ''

But that does not seem to work - what is the correct approach?

[WiggityZwiggity · Accepted solution]

ne null - figured it out after several attempts 🙂

[Meneghino]

thank you! just what I was looking for

[Anonymous]

Awesome, thanks for this, very useful!

[AronBrown]

Thanks, was just looking for how to do this!

[Brian-Hamilton]

I could swear this happened. 

EndDate eq null (Didn't work)

EndDate eq 'null' (Didn't work)

EndDate eq to the expression null (Didn't work)

EndDate eq to the expression 'null' (Didn't work)

EndDate eq null (Worked)

[AronBrown]

Yeah, if you tried to do the eq null again after the 1st of May or April, cant remember now but it fixed itsself with an update from microsoft

[tomoore]

And as of Jan1 2020, its broken again.  As previously posted:

EndDate eq null (Didn't work)

EndDate eq 'null' (Didn't work)

EndDate eq to the expression null (Didn't work)

EndDate eq to the expression 'null' (Didn't work)

🤣  Here I am...  HOWEVER,   EndDate eq 'null'  doesn't error out (only one that doesn't) but won't filter anything unless the string null is in the column/cell. 

[HillaRamo]

I thought I was going crazy. But this explains a lot. My flows used to work with date eq null... but suddenly not anymore. So I, too, think they must be broken now. 

Which means I have to figure out a workaround to 40958409094589 flows until this is fixed 😞 

[hjaf]

How could we solve this when the query is referencing variables.. if that variable in that context is '' then this will not work. having a if(empty(variable), null, variable) will not work either because this produces a query 'null' which translates into''