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

The available options 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.