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.
Comments
This is very sorely missing. It was there in AX 2012. It's somewhat possible now with Edit in Grid. Yes, I know we could use DMF (Import/Export), but COME ON! Super helpful when you only need to update select records. I would even take a separate way if we could do this via OData and CRUD. ;)Example that I have done in the past is to update Packing quantity in the WHSSalesLine table. Have the InventTransId necessary and filter by that.
Category: Office Integration