cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Odata Filter Null

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Odata Filter Null

ne null - figured it out after several attempts 🙂

View solution in original post

10 REPLIES 10

Re: Odata Filter Null

ne null - figured it out after several attempts 🙂

View solution in original post

Highlighted
Meneghino
Level 10

Re: Odata Filter Null

thank you! just what I was looking for

Anonymous
Not applicable

Re: Odata Filter Null

Awesome, thanks for this, very useful!

AronBrown
Level: Powered On

Re: Odata Filter Null

Thanks, was just looking for how to do this!

Brian-Hamilton
Level: Powered On

Re: Odata Filter Null

I could swear this happened. Smiley Tongue

 

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
Level: Powered On

Re: Odata Filter Null

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
Level: Powered On

Re: Odata Filter Null

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
Level: Powered On

Re: Odata Filter Null

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
Level 8

Re: Odata Filter Null

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

YatinMumbai
Level: Powered On

Re: Odata Filter Null

Thanks. Saved me many test runs.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,159)