Answered

Odata Filter Null

(5) Share

Report

Posted on by WiggityZwiggity

358

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?

Categories:

Building flows

I have the same question (0)

All responses (28)

Answers (1)

Verified answer

WiggityZwiggity 358 on at

Like (56)

Report
Copy link

Link copied!

ne null - figured it out after several attempts 🙂

1 people found this reply helpful.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!

thank you! just what I was looking for

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Awesome, thanks for this, very useful!

Was this reply helpful? Yes No
AronBrown 45 on at

Like (0)

Report
Copy link

Link copied!

Thanks, was just looking for how to do this!

Was this reply helpful? Yes No
Brian-Hamilton 60 on at

Like (15)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
AronBrown 45 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tomoore 10 on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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 😞

Was this reply helpful? Yes No
hjaf 487 on at

Like (0)

Report
Copy link

Link copied!

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''

Was this reply helpful? Yes No
YatinMumbai 123 on at

Like (0)

Report
Copy link

Link copied!

Thanks. Saved me many test runs.

Was this reply helpful? Yes No