OData Filter Builder
Build filter expressions for SharePoint Get items and Dataverse List rows actions without writing OData syntax by hand. Add conditions, choose operators, and copy the result.
Field eq ''
How to use this in Power Automate
In a SharePoint Get items action, paste the output into the Filter Query field found under Show advanced options.
In a Dataverse List rows action, paste the output into the Filter rows field.
SharePoint OData uses substringof for contains checks. Dataverse uses contains(). The Target service toggle handles this automatically.
Column names must match the internal name of the column, not the display name. In SharePoint, the internal name can be found in the column settings URL. It is usually the display name with spaces replaced by underscores or with _x0020_ encoding for older columns.