Skip to content

Feature Deep Dive: Modern Advanced Find in Dynamics 365

In a recent blog, we discussed the 5 updates you need to be aware of before the general availability of the 2022 Release Wave 2. In that blog, one of the top updates was the changes to Advanced Find.

Almost everyone who regularly accesses Dynamics 365 will be familiar with one specific icon: Filter Icon

This small filter funnel is an incredibly powerful tool allowing us to query any area of the Dynamics 365 application that our security roles give us access to. Known as Advanced Find, it has seen multiple Dynamics 365 versions come and go.


However, it’s now due for a refresh and Microsoft have given us the “Modern Advanced Find”. Throughout the course of this blog, we will explore the differences between the Modern Advanced Find and the version of the past, specifically focussing on how the once familiar features will now be presented to us.

 

Advanced Find Update Timeline

Originally announced back in the 2022 Release Wave 1, it will now enabled by default for all users in the upcoming October release.

  • For UK instances of Dynamics this will between Friday October 7th to Sunday October 9th.
  • For European instances of Dynamics this will be between Friday October 14th to Sunday October 16th.

 

Advanced Find update walkthrough

How to access the Modern Advanced Find

From October. the way you access Advanced Find will depend on if you have Dataverse search enabled. You will be able to identify if Dataverse search is enabled by looking for the search box at the top of the screen in the middle. If the search box is present, then Dataverse search is enabled.

Search Box View

If Dataverse Search is Enabled...

With Dataverse enabled the Advanced Find icon will be removed entirely.

To access Advanced Find, please click on the search box and then click on “Search for rows in a table using advanced filters”.

Search for rows in a table using advanced filters

If Dataverse Search is Not Enabled...

If Dataverse is not enabled, the Advanced Find icon will still be visible on the right of the red bar. 

Icon bar

You can access Advanced Find in the way you are used to, i.e. by clicking on the filter icon.

Filter icon bar

 

 

In either case, the next screen you will see is a list of tables (entities) that you can search through. This is reminiscent of the previous interface.

**However, an important point to note is the Modern Advanced Find will only show tables that are included in your app.**

Select a table pane

Here you can see I have selected the accounts entity.

 

Accounts entity

The next screen you will be directed to is the filter screen. Here you can define the filter criteria that you wish to apply.

 

Filter Criteria

To add a new row simply click on the add button and choose add row.

 

Add a row

 

A new row will be added, and you can then select the column that you want to filter on. This is just the same as we used to do in the classic Advanced Find.

 

Filter row

If you want to filter by a related table, you can click add and then choose ‘add related entity’.

Add related entity

 

In this case, you can see that I have chosen to add a filter on Cases linked to this account.

 

Filter by cases

 

If you want to add in a grouping, click “Add” and then choose "Add Group".

A new group will be added, and you can then add in the items within the group by selecting add and then add row.

 

Add group

 

Here you can see we have created a basic grouping.

 

Basic Grouping

If you want to change the AND to an OR simply click on it and select the appropriate option.

AND OR

To apply the filter, simply click apply at the bottom of the page.

If you would like to go back to the default filter for the view, you can do this by clicking “Reset to default” button.

 

Reset to default

 

We hope this walkthrough has helped you become more familiar with the modern Advanced Find on Dynamics 365. If you're a Crimson customer and you still need some support using the new feature, get in touch with the support team. 

 

Get More From Microsoft: Click for a FREE Discovery Call