Power Platform Community Forum Thread Details

When I use a filter expression like

(Email ne '') and (Email ne null)

this gets converted to

(Email ne '') and (Email ne 'null')

... watch out for the single quotes around null!!!

when I switch back and forth the filter input options or when I open the action settings and come back to the action details.

But then the filter is broken and not doing what it should! it's not filtering out items anymore where field Email is not filled.

I consider this a bug?!

Any workaround options?

Categories:

BUG: Sharepoint Connector - Get Items - ODATA filter