Skip main navigation

New offer! Get 30% off your first 2 months of Unlimited Monthly. Start your subscription for just £29.99 £19.99. New subscribers only. T&Cs apply

Find out more

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

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now