When using the Excel add-in to retrieve data from Dynamics BC and potentially manipulate in Excel and publish back to Dynamics BC it's not possible to apply a filter using a list of values.

The available option are: equal, not equal, contains, does not contain, starts with, ends with, empty and not empty.

It would be nice to have an option to be possible to have multiple values in the same filter.

Two potential options:

Option 1: Allow in the equal option to have multiple value for example with comma to separate the different values

Option 2: add a new option to the list of available options "is one of" to the existing options.