cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
isaac1
Helper II
Helper II

GetItems ODATA filter: column name is null

This should be so easy, and documentation everywhere, yet I've combed through so many forums and posts and none of the solutions worked for me.

 

I'm using a GetItems step, sharepoint list, and I want the column DateEmailSent to be null (or blank).  In the ODATA filter.  How do I do this ??

 

DateEmailSent eq Null did not work

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Super User
Super User

@isaac1 

This is hard to believe but I think it’s case sensitive. Try null. Sorry if I’m wrong but I’m not sitting at my pc any more to double check.

Damien

View solution in original post

13 REPLIES 13
DamoBird365
Super User
Super User

Hi @isaac1 

 

Could you try 

DateEmailSent eq ''

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


 

P.S. there is a null expression.

 

DamoBird365_0-1616012559491.png

 

You can build this from the expression builder

 

Damien

 

 

isaac1
Helper II
Helper II

I keep trying to reply to this post and microsoft tells me "invalid html was found, please correct and try again".  

 

DateField='' did not work, and dynamic content [Datefield], plus eq plus NULL from teh expression builder did not work either.

isaac1_0-1616015379255.png

 

isaac1
Helper II
Helper II

PS ... I'm temporarily solved this by populating the records that I want the flow to Get, with the date 1/1/2010

and then using filter ODATA:  DateEmailSent eq '2010-01-01'

 

That works, but geez--the other way ought to

HI @isaac1 

 

I've found the answer and tested this to work.  Courtesy of a very old post here

 

Kudos to @ohthreesixtyfiv too 👍

 

DamoBird365_0-1616092365068.png

Give that a go.... literally this

 

(columnname eq null)

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Hi @isaac1 

 

How are you getting on??

 

Damien

As mentioned in my first post, that did not work.

Hi @isaac1 

 

You've said 

DateEmailSent eq Null did not work

 

I've said try

(DateEmailSent eq null)

 

Note the parenthesis.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Ok, noted.  True, I had missed that you meant literal parenthesis before, sorry.

That fails with:  "Column 'Null' does not exist. It may have been deleted by another user."

DamoBird365
Super User
Super User

@isaac1 

This is hard to believe but I think it’s case sensitive. Try null. Sorry if I’m wrong but I’m not sitting at my pc any more to double check.

Damien

isaac1
Helper II
Helper II

That worked!  How did you know the parenthesis are needed, is it documented somewhere?  

Thank you

Hey, that worked for me.

 

(DateField eq null)

 

Thanks

Cool, glad it helped!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Users online (3,117)