Skip main navigation

Bulk Delete Overview

This activity will introduce us to the Bulk Delete function, and discuss the advantages if holds over the Advanced Search function when it comes to re
18.8
Here we can see a screen from the experience from within a model-driven app like Dynamic 365, but can access it also from admin.powerplatf orm.microsoft.com environment settings. Bulk delete is a powerful tool for removing stale or unneeded data en masse. More efficient than the 250 records per page limit of advanced find, it can be scheduled to be part of a routine system maintenance if required. Be careful. There is not an undo or rollback on bulk delete jobs. If data is deleted in error, you will need to rely on a backup process outside of common data service to restore the data.
65.3
Just like creating an advanced find, you can create a query for your bulk deletion. You can preview records to test your query.
78.4
If we look at reoccurring bulk delete jobs, at the end of creating a bulk delete job you can choose to use this job to run on a reoccurring schedule. Recurring jobs can be reviewed in the reoccurring bulk deletion system jobs view. The job can be opened and updated from here.
100.5
Security– bulk delete privileges are managed through security roles. The user must have the bulk delete privilege– it’s under the General tab, miscellaneous privileges– and the user can only bulk delete records they would have permission to delete individually. The user needs the delete privilege on any record they need to do bulk delete. Triggering other processes– depending on how your cascade relationships are configured, bulk deleting one record may cause many other deletions. Record deletion is an option for triggering workflows. Be mindful of how a bulk deletion could trigger workflows to run en masse.

This activity will introduce us to the Bulk Delete function and discuss the advantages it holds over the Advanced Search function when it comes to removing stale or unneeded data en masse.

Bulk Delete can be accessed via a model-driven app like Dynamics 365, but also via admin.powerplatform.microsoft.com.

It is more efficient than Advanced Find, which has a 250 record limitation. It can also be scheduled to run automatically.

NB There is no undo or roll-back feature with Bulk Delete, so be careful and consider making system back-ups

It can be run off of queries, which you can preview the results of to check that the correct records are being selected before running the delete. Once the delete has run, you can use the ‘Modify Recurrence’ option to set a regular schedule for it to run, or simply delay the job to run at a time that the system is not in use and will not cause undue issues with others working on the system concurrently

This article is from the free online

Dynamics 365: Implementing Power Platform Integrations

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education