Filter option fields by multiple values

Enabled for Public preview General availability
End users, automatically This feature is released. Sep 1, 2019 This feature is released. Oct 1, 2019

Business value

Back-office information workers spend significant amounts of time working with lists and reports and applying filters to narrow down their data to the relevant records. Users often need a higher degree of control as the size of the business database grows. Option fields are essentially enumerations with predefined values. Until now, users have been able to choose only a single value when they set a filter in option fields.

Feature details

With this wave, we introduce a new multi-selection control in filters for fields of type Option so that users can filter on these by multiple values. This is treated as an OR operation. For example, you can filter the Color field by red, green, or blue.

Filtering option fields by multiple values is available consistently across filter experiences: On list pages, reports, XmlPorts, and on filter screens driven by the RunRequestPage and FilterPageBuilder commands. Multi-selection of values is available only when filtering, not when specifying the field value on the record.

Screenshot of filters on the Items list, including a filter on multiple option values

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

See also

Feature exploration (video)

Filtering with Option Fields (docs)