Filtering option fields by multiple values

Important

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

Business value

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.

Feature details

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.