Support Portal ContactGet in touch

How to use the Advanced Find in Dynamics

   Words by CRM Consultancy

   on 06/03/2017 14:00:00

imageIn the bad old days of systems, the need for a new report would be sketched out and have to be sent to the Developers, when often this ‘report’ was simply a handy spreadsheet of data that needed to be produced from the system.

Often when approaching new CRM Projects, we would be warned ‘we have hundreds of reports’ and whether this was possible within CRM and the Project Budget.

On investigation, many of these reports would be simple queries of the data in the system that could be solved using the Dynamics CRM Advanced Find and so be built by the Business themselves, not via expensive Developers and Consultants. 

In the early days of Dynamics CRM, this helped many a Project come to fruition in allowing the Business to build their own Reports rather than being limited by Development Team.

As such, the Advanced Find has been a mainstay of Dynamics CRM all the way since v3.0. 

It is a great tool that helps us both build these new Reports alongside run Queries against CRM to find certain records or groups of data – particularly when we can Export and Share the Results.

To help get started with this, the following Walk Through is aimed at showing how to use the Advanced Find in Dynamics CRM.


Step 1 – To Create an Advanced Find

  1. Select Advanced Find on the Command Bar.
  2. Select New.
  3. In the Look For drop-down, select the Type of Record or Entity we want to query
  4. Pick the Field – In the Search Area now, we can select any particular Field for that Entity that we want to use for our Query.
  5. How  – With the Field selected, we then pick the Operator we want to Query by.  This gets into basic Database Query Operations, so a ‘Equal to X’ or ‘Greater than Y’ style query.
  6. What – With the Field and the Operator, we can then pick the Value we are looking to use for the Query.  This can be a selected Drop-down value, a Record in CRM, or simply a block of text, this depends on the Type of Field in CRM and what we want our Advanced Find to return:clip_image004clip_image006

With this all done, we can click the Results button to then flip our Query into the real Data that is in CRM:


Step 2 - Adding Search Criteria to an Advanced Find

  1. In the select area, choose the field on which you want to search
  2. Select your query operator
  3. Enter the data you want to filter by

clip_image009Note - To select GROUP OR, GROUP AND On the ribbon at the top select the option you wish to choose

Adding or Removing Columns


From the query screen, choose Edit Columns in the ribbon. (Select the Advanced Find tab if you’re in the results screen).

 clip_image013To move the columns from left to right, select the column then use the green arrows to move the column left or right.

  • Sort by - To configure the sorting, choose ascending or descending.
  • Add Columns - To add columns, select the columns you want to add.
  • Column Widths - Change Properties allows you to make columns wider or narrower.
  • Give it a Name - Enter a Name/Description then select OK.
  • Save it - From the query screen, select Save As in the ribbon.

Saving Advanced Finds (Creating a Personal View)


Your new saved personal view will be available on the entity you created. In our example, we created the personal view under the account entity.

NOTE - System Views are available to everyone in the organisation. Whereas Personal Views built in the Advanced Find are private until shared.

Step 3 - Sharing the View


  1. Select Advanced Find on the Command Bar.
  2. Choose Saved Views.
  3. Select the view we want to share.
  4. Select Share in the ribbon.
  5. We can then select which Users or Teams in CRM we want to share the View with.

Step 4 - Export to Excel

Once we have our Advanced Find View we can export the data to Microsoft Excel, this can be useful for further reporting or sharing the data outside of CRM:

  1. Open a list of records from a view or advanced find.
  2. On the Command Bar, under the ellipse button, select Export to Excel.
  3. In the dialog box, select Static Worksheet with records from this page.
  4. Select Export.
  5. In the file download dialog box, select Save to save the workbook and specify a location, or choose Open to open the exported data in Excel.


The Advanced Find is a great starting point for Reporting in Dynamics CRM – and once we are familiar with the functionality here, we can then look at how we can use this to produce Fetch XML Queries in Dynamics CRM for exporting our Queries or performing more Complex Reporting.

The tool itself has not changed massively from CRM 3 all the way to CRM 2016, however in a future blog post we will be looking at the Advanced Find in Dynamics 365.

Further Reading

The Advanced Find is a long standing part of Dynamics CRM, and so comes with a wealth of Support Resources and further Information, the following is a small flavour of these resources:

CRM Customer Centre – Advanced Find

How to use the Advanced Find in CRM 2013

The CRM Book – Searching and Navigating in CRM

CRM Advanced Find – Why use Group AND?

Why the Advanced Find is a CRM Developers

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

CRMCS Quick Start Guide: How To Produce a Microsoft Teams Live Event Dynamics 365 Marketing: Lead Scoring and Sales Acceptance Designing and Developing Microsoft Power Apps Portals Thank You for Attending CRMCS’ Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Thank You for Attending Our Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Webinar: Discover How CRMCS Have United Dynamics 365, SharePoint and Microsoft Teams To Create Sales Excellence Ignite your workflow by adding DocDrive365 to Office 365 The CRMCS guide to everything you need to know about integrating Teams with Dynamics 365 Saving Time By Keeping Documents In One Place TDE Database Encryption with On Premise Dynamics The Key to Successful Compliance in 2020 Part 2: Let’s get GDPR Compliant with Microsoft Power Automate Top 3 Essential Tips for Remote Working Dynamics 365 Marketing: Top 5 Best Features Dynamics Day in the Life - Puma Investments Can you use Teams to amplify collaboration in Dynamics? Part 1: Using a Scheduled Power Automate to Trigger Expiry Date Reminders The secrets of successful document collaboration in Dynamics CRMCS launches new AppSource approved DocDrive365 Dynamics Day in the Life - Moneypenny Release Management Add the App to Dynamics DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Building a New Scheduled Process using Flow
  • "Paul has made a real difference to how my team of 24 people record and store valuable customer data and sales opportunities. Highly recommended."

    James, Operations Director

  • "Understanding your business allows us to advise when to implement aspects of CRM and, likewise, when not to."

    Paul McQuillan, Managing Director

  • "Dynamics 365 and CRMCS have made a real lasting difference to our business, allowing us to replace older systems that were holding back our performance."

    Grahame, Chief Operating Officer

  • "James worked well with us to help connect CRM with Outlook and relate how this might benefit our team using CRM for Property Care."

    Natalie, Property Care Supervisor

  • "Matt was really good with helping us run User Testing on the new Compliance Module of our CRM System."

    Tom, Compliance Administrator

Prefer to go old-school?

Write to us using the below addresses.

Head Office
CRM Consultancy
61 Oxford Street
M1 6EQ

London Office
CRM Consultancy London
Grosvenor Avenue

Content © CRM Consultancy.