How To Check Null Value In ODATA Filter Of Get Items Action In FLOW

Get Items action with ODATA filter in FLOW - write query parameter to get items with column value not empty.

You might come across this scenario where you need to pull items from SharePoint list, with filter of specific columns not empty. In Get Items action we need to provide filters in ODATA query format.
 
In this blog, we will see which options won't work and what is the correct way to write filter parameter to check not null fields.
Let’s see what are the options which don’t work.
 
Using null expression – this won't work in ODATA Filter query parameter.
 
 
 
Using null expression with single quotes or checking empty string using '' will not work
 
 
Solution
 
ColumnName not null.
 
Simply writing column name operator and null will work correctly.
 
 
Try it out. If it still fails, try to close the flow open again and run it. It should work.
 
Thanks for reading. Hope this helps.