In 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.
now 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.
First we need to login to Make.powerautomate.com
Create a cloud flow
Select the Manually Trigger
Solution
Column Name not null.
Simply writing column name operator and null will work correctly.
Try it. If it still fails, try to close the flow open again and run it. It should work.
For any Help or Queries Contact us on info@crmonce.com or +918096556344
