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 Smiley Happy

6 REPLIES 6

Re: Odata Filter Null

ne null - figured it out after several attempts Smiley Happy

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)

 

 

Highlighted
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

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 41 members 4,885 guests
Please welcome our newest community members: