I have a simple SharePoint list, and when I add a 'Get Items' action to my flow, I have the filter query "Reference ne null".... not the text "null", but the formula null.
This doesn't work. I get the error:
The expression "Reference ne " is not valid. Creating query failed.
I tried changing it to Reference ne '' , but that doesn't bring back items where Reference is blank.
I've tried a number of combinations and scoured the net, but it seems that Field ne null is the correct way, and yet it doesn't work. Even if I use the Title field as a comparison (Title ne null). I get the same error.
Any ideas?