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
Solved! Go to Solution.
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
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.
You can build this from the expression builder
Damien
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.
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 👍
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
As mentioned in my first post, that did not work.
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."
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
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!
Ugh it's the simple things in life that eat up the most time. Got this working after reading your post. THANK YOU.
For me it was (Columnname ne null) <<< the brackets are what did me in, I have just been learning ODATA filtering and haven't seen this documented anywhere. Thanks @DamoBird365 !