How to Bulk Delete Records in Dynamics 365 (CRM)

Sometimes, Microsoft Dynamics 365 CRM users accidentally import records that shouldn’t be in the system.

Fortunately, there are 3 methods to remove the unwanted records. Each is best suited for a certain situation:

  • Advanced Find: Useful if all the records you want to delete are from the same entity (such as Accounts, Contacts, or Leads). Read steps.
  • Bulk Record Deletion Wizard: Useful if you have thousands of records to delete at a time. You can use a saved Advanced Find view. Read steps.
  • Delete Imported Records: Best suited for scenarios where all the records you want to delete are from the same data import. This method only works if the import source file has not been deleted. Read steps.

Below, you’ll find the step-by-step instructions for each of the three methods. You will need deletion privileges.

Note: There are now 5 different Dynamics 365 apps that serve various CRM needs. In some contexts, you may also see those products referred to as “Customer Engagement” or “CE” apps. The bulk delete methods described here will work no matter which of those apps you’re using.

Bulk Delete Dynamics CRM Records via Advanced Find

  1. Click on the Advanced Find “filter” button. If you do not see this button, you can do Advanced Find from within the big search box in the top right. You can perform this action from any page in the system. You can also read detailed instructions on Advanced Find.D365 CRM Advanced Find
  2. Select the desired entity in the Look For dropdown menu inside the Advanced Find window. In this example, I will select Leads.Select Entity
  3. Add your filters. Click on Select and choose the desired field. In this example, I will select the “Created On” field.Select Field
  4. Select the desired value to be applied to the filter. In this example, I am looking for all leads created on June 10, 2020.Select Value
  5. Click on the Results button.Results Button
  6. Select the Leads that you wish to delete. You can also select them all. Then, click on Delete Lead.Bulk-Delete
  7. Microsoft Dynamics 365 will ask you to confirm the deletion before proceeding. Click on Delete to confirm.Bulk-Delete

Bonus Tip: How to See More Records in Advanced Find & Views

You can use this method to delete even more records in less time.

  1. Click on the Settings icon located on the top-right of your screen.Bulk-Delete
  2. Click on Personalization Settings.
  3. Find the Records per Page field. Select a value of your choice. In this example, I selected 250 records per page. Click on OK to save your settings.Bulk-Delete

Once you are done, you can select up to 250 records at a time using the Advanced Find method.

Note: Make sure that you want to delete all 250 records in Advanced Find or a view!

Dynamics 365 Bulk Record Deletion Wizard

  1. Click on the Settings icon located on the top-right of your screen.Bulk-Delete
  2. Select Advanced Settings.Bulk-Delete
  3. Click on the down arrow next to settings in the Advanced Settings tab. Then select Data Management.Bulk-Delete
  4. Select Bulk Record Deletion.Bulk-Delete
  5. Click on New to create a new bulk record deletion job.Bulk-Delete
  6. The Bulk Deletion Wizard pop-up window will appear. Click on Next to continue.Bulk-Delete
  7. Define your search criteria. Select your filters based on record type and field values in the Advanced Find embedded in the wizard. Click on Next to continue.Bulk-Delete
  8. Select your bulk delete options, including when to run the job, if you want the job to run at a pre-specified interval, and to notify users via email when the job is done. Once your options are selected, click on Next.Bulk-Delete
  9. Verify the details of your job. Once everything has been verified, click on Submit.Bulk-Delete
  10. You will be able to see the bulk deletion job once it is processing and after it has been completed.Bulk-Delete

Delete Imported Records

  1. Click on the Settings icon located on the top-right of your screen.Bulk-Delete
  2. Select Advanced Settings.Bulk-Delete
  3. Click on the down arrow next to settings in the Advanced Settings tab, and select Data Management.Bulk-Delete
  4. Select Imports.Bulk-Delete
  5. Double click to open the import job that contains the data that you want to delete.Bulk-Delete
  6. Click on the down arrow next to the Delete button and select Delete Imported Records.Bulk-Delete
  7. The system will ask you to confirm the deletion of these records. Click on Confirm to proceed.Bulk-Delete

If you are deleting so many records that you need to use the Deletion Wizard or the Delete Imported Records options, you may have to wait an hour or more for them to finish, depending on your system resources.

If you found this handy, you may also be interested in reading how to use Advanced Find or our many other Dynamics 365 CRM blog articles.

For detailed Dynamics advice and training tailored to your business, please contact us.

Calculated Fields and Rollup Fields in Dynamics 365 CRM Solutions

In this recorded webinar, we'll cover how to create Rollup Fields and Calculated Fields to help you you automatically determine values based on other fields and records in the system.

January 30
9:00 am – 9:30 am PST

Register here

Webinar - Calculated Fields and Rollup Fields

Jan. 30
9:00 am – 9:30 am PST

Register