Delete All Records From Dataverse Table [With Examples]

Ever wish to remove a large number of records from the Dataverse Table? Do not worry about it. This Microsoft Dataverse Tutorial will guide you through understanding how to clean records in Dataverse in simple and easy steps.

Let’s say you have a Dataverse table with some records on it. It was initially created as test records, but you no longer wish to maintain them since you want to migrate these solutions to different manufacturing or testing sites.

You can use this article to learn how to delete all entries from the dataverse table without doing it manually one by one in this scenario.

In case of if you don’t want to remove every entry from the data table, you may also target a view on that particular dataverse table. You can use this view to delete specific records from the Dataverse table that match the provided view condition.

Delete Records from a Dataverse Table Using Table Editor

Now we will see how to clean some specific records from a Dataverse table. As we discussed earlier, to remove specific data from the Dataverse table, we can target or create a View in the Dataverse.

If you only need to delete a few records and prefer a visual approach, you can manually delete records directly inside the table using the Edit view.

For this example, I created a Dataverse table called Product Sales with the following columns and datatypes:

• Product Name (Text)
• Sales (Currency)
• Quantity (Whole Number)
• Location (Text)
• Date of Sale (Date and Time)

NOTE:

If you are new to dataverse and want to create a dataverse custom table, then refer to this link to know more details: Dataverse Create Table [With Examples]

Follow the steps below:

1. Open Power Apps and, from the left-hand menu, select Tables. Then, search for the table from which you want to delete the record.
2. In my case, I select the Product Sales table.

3. Click the Edit button (top menu bar).

4. In the spreadsheet-style editor, use checkboxes to select the records you want to delete. Then, click the Delete record(s) button on the top ribbon.

Then you can see the selected record deleted from the Dataverse table.

This method is ideal when you only want to delete 1–50 records in a Dataverse table.

Delete Specific Records from a Dataverse Table Using Views

Sometimes, you only want to delete certain records from a Dataverse table, for example, records where the Location is Australia or the Status is ‘Inactive’. Instead of manually selecting them one by one, you can use a View to filter those records and then delete them all at once using Bulk Record Deletion.

For this method, I used the same Dataverse table called Product Sales with records from different locations. I only want to delete the records where the Location = Australia.

Follow the steps below:

1. Navigate to Power Apps. In the left navigation pane, click on Tables. Select your table (for example, Product Sales)
2. In the Table Designer, scroll down to Data experiences. Click on Views. You will now see a list of existing views (system and custom).

3. Click on + New view. In the Create a view panel:
   • Name: Enter a name like Australia View
4. Click Create.

5. On the View Designer screen, click the + View column. Select the columns you want to see in your filtered view, such as:
   • Product Name
   • Sales
   • Quantity
   • Location

6. Click on Edit filters. In the filter panel:
   • Click + Add -> Add row
   • Set the condition as:
     • Column: Location
     • Operator: Equals
     • Value: Australia
7. Click OK to apply the filter.

8. Then click Save and Publish.

Dataverse Bulk Record Deletion to Remove Filtered Records

Here, we will see how to delete a Dataverse Table record.

1. In Power Apps, click the Gear icon in the top-right corner. Select Advanced Settings (A new browser tab will open with classic settings).

2. In the new tab, go to: Settings -> Data Management -> Bulk Record Deletion.

3. Click on New at the top.

4. A wizard will appear:
   • Look for: Select your table (Product Sales)
   • Use Saved View: Select the view you just created (Australia)
5. Click Next.

6. Provide a name for the job.

Note:

By default, the bulk deletion name will be “Bulk Deletion – 7/14/2025 4:34:15 PM,” which includes the current date and time.

6. Choose when to run the job:
   • Immediately
   • Or on a schedule
7. Select “Send an email to me” to receive a notification after the job has run.
8. Click Next.

Finally, it will prompt you to review the options you have selected. Click the Back button to make any necessary changes. Click the Submit button to submit the system job.

• Now, go to the specific view (Australia), and you cannot see any records related to the Australia location. It has been deleted.

• Now, go to the specific Dataverse table (Product Sales), and the data for Australia won’t appear if you see the Location column.

This method is easy, visual, and ideal for deleting targeted data from any Dataverse table.

Bulk Delete Record from a Dataverse Table

If you’ve created test data in a Dataverse table or want to clean up all existing entries before going live, you can delete all records at once using the Bulk Record Deletion feature. This eliminates the need to select or filter each record manually.

For this method, I used the same Dataverse table called Product Sales with records from different locations.

Follow the steps below:

1. Go to Power App studio and select the Gear settings icon (upper top right corner) -> Select Advanced settings -> Click on the Settings dropdown and then select Data Management option -> Select Bulk Record Deletion.
2. Click the New button in the upper left corner of the Bulk Record Deletion screen to continue. A bulk deletion wizard will eventually show up on the screen. Then, click the Next button.

3. On the Search Criteria page:
   • In the Look for dropdown, select your table (Product Sales)
   • Leave the ‘Use Saved View’ field blank; this means no filters will apply, so that all records will be deleted.
4. Click Next.

Also Read: Create a Multi-Agent in Copilot Studio

Note:

A warning pop-up will appear: “You haven’t specified a search criteria. This will delete all records of the selected entity. Do you want to continue?” Click OK to proceed.

5. Enter a name for the job, like “Delete All Product Sales Records.”
6. Choose when you want to run the deletion:
   • Run it immediately
   • Or schedule it for later
7. Select “Send an email to me” to receive a notification when the job is completed.
8. Click Next.

Check Out: Add Copilot Studio Knowledge Files Using Power Automate

• Finally, you will be prompted to review the options you have chosen. The Back button may be used to make any needed modifications. To submit the system job, click the Submit button.

• Go to the relevant Dataverse table (Product Sales) now, and refresh the page. You may notice that since all the records in the table have been removed, it appears blank, as shown below.

This is how we can delete all the records from the Dataverse table.

This Microsoft Dataverse tutorial explains how to remove or clean up specific records from the Dataverse table. Additionally, we saw how to delete all bulk data at once in the Dataverse table.

Also, you may like the tutorials below:

• Create a Dataverse View
• Filter Dataverse Choice Column
• Create a Dataverse Table From a SharePoint List