New Advanced Filter Feature & What This Means For Advanced Find

Adv filtersd

Advanced Find is a legacy feature from Dynamics CRM which Microsoft hasn't yet got around to replacing in the Unified Interface, but in the 2020 Release Wave 1 it introduced Advanced Filtering.

In this update for Microsoft Dynamics 365 and model-driven apps, an Advanced Filter icon is shown on list views for standard and custom entities. Clicking this opens the expression builder panel.

Adv fil 01

Filters can be as simple or as complex as you need. This supports queries using a few fields, through to grouped expressions with nested conditions.

Within the builder panel, filters can be defined using most common operations including and/or. Consistent with Advanced Find, queries can work across related entities.

In this release, the Advanced Filter panel is opened from an existing view. By default, the current definitions are shown. These can be changed with conditions for fields being added and removed, as appropriate.

Adv filters

Once complete, the filter will be applied to the current view.

An * will then be shown next to the current view title. This denotes that the view has changed from the default conditions but the new filter is unsaved.

To cancel the new filter definitions and revert to the original view, click the cancel filter icon highlighted.

Activ views

To save the new filter conditions, either by creating this as a new personal view, or replacing an existing personal view, click the ellipsis in the ribbon.

In another improvement, personal views in Dynamics 365, and other model-driven apps, are now shown above System Views.

Does Advanced Filtering replace Advanced Find for Views?

For many usage needs this will likely be a better experience compared to Advanced Find, enabling users to quickly apply filters and define new views.

At this time, Advanced Find has not been deprecated as some of its functions haven't yet be replicated in the new experience. For example, sharing, assigning and deleting views still need to be handled in Advanced Find.

Also, clicking 'Create a New View' continues to open the Advanced Find pop-up as the new filter experience is only launched when editing an existing view.

As we've highlighted, additional personal views can be created but if you want to define an entirely new set of conditions starting with a basic view such as 'active contacts' is recommended. That will avoid time being spent deleting rows of multiple conditions as there isn't currently a 'clear all' button to reset the existing conditions.

As these gaps are expected to be bridged soon, the writing seems to be on the wall for Advanced Find.

Filterfr

Within grids, users can more easily drill down with additional filter improvements that are introduced in the latest release wave.

New grid column filtering capabilities make it easier to control displays including: 'begins with', 'ends with', and 'contains data' criteria. New date filters include absolute criteria ('before', 'after', 'on', etc.) and relative ('last month', 'older than X months', etc.).

If you have any questions about this, or other Dynamics 365 features and capabilities please get in touch.

What's New in Dynamics 365

Check out more new features and capabilities for Dynamics 365 and the Power Platform.

Read more