Filtering option fields by multiple values
Some of the functionality described in these release notes has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
|Enabled for||Public preview||General availability|
|End users, automatically||October 2019|
Back-office information workers spend significant time working with lists and reports, 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. With this wave, we introduce a new multi-selection control so that users can filter by multiple values. This is treated as an OR operation. For example, you can filter the Color field by red, green, or blue. Multi-selection of values is available only when filtering, not when specifying the field value on the record.