In this article, we will understand how to remove all data for the entities in CDS (Common Data Service). You can, not only delete the data, but you can also schedule the deletion of the data for the future. Let’s go through the process in detail.

PowerApps BULK delete CDS record

1. Navigate to the PowerApps Portal.
2. Select the environment to deploy to (top-right)

3. Select the settings cog icon (top-right)
4. Select Advanced Settings

5. Along the top, select the down arrow next to Settings

6. Under the System group, select Data Management

7. Select Bulk Record Deletion

8. Select New in the toolbar under Bulk Record Deletion.

9. When the Bulk Deletion Wizard opens, select Next.

10. Next to Look for:, select the Entity from CDS that you want to clear and then select Next. You can also Preview the records to just make sure the entity you have selected is correct.

Here, you can filter the results if you want by clicking on Select.


11. If you haven’t defined any search criteria then an alert will open saying: You have not defined any search criteria, All the records for the selected entities will be deleted. To continue, click OK. To define search criteria, click cancel. Select OK

12. On the next screen, you need to specify a few properties.
    1. Name: Specify the name of this job of bulk deletion.
    2. Bulk deletion job start time: Specify if you want to run the job now or at any specific time.
       1. Immediately: Will delete the data immediately
       2. At scheduled time: Specify date and time when the Job should start
       3. Run this job after every: After this many days, this job again will run. you don’t need to set up the whole process again.
       4. Send and email to me: Select if you want a confirmation on an email after the job is done.
       5. Also notify: Specify your team member also about the completion.
    3. Click on Next.
    4. After confirming the settings, click Submit
    
    5. You can check the status of the job from the Bulk Record Deletion window.