When setting up a Dataverse, Sales or Field Service Connector, currently the system is unable to filter Dataverse tables picklist field with ' ' (blank) values. The blank filter can be applied on Integration Table Mappings "Integration Table Filter" but is not actually applied to the filter of records, meaning no blank values will be synchronised across even if the Table Mappings appears to be configured to do this.

It would be beneficial if this limitation could be looked into and to be able to use blank filters when setting up the Connectors in Business Central.

Thank you in advance.