Recover Deleted Table Records in Dataverse - Preview Guide
Image Source: Shutterstock.com
Microsoft Dataverse
May 17, 2024 7:16 AM

Recover Deleted Table Records in Dataverse - Preview Guide

by HubSite 365 about Rajeev Pentyala

Senior Software Engineer at Microsoft Power CAT Team

Citizen DeveloperMicrosoft DataverseLearning Selection

Revive Dataverse Records Easily with New Preview Feature: Restore in Seconds!

Key insights

 

 

  • Dataverse now includes a Recycle Bin feature in preview, allowing users to restore deleted table records within a specified time frame.
  • To enable the Recycle Bin feature, administrators must turn it on in the Power Platform admin center and set a time frame up to 30 days for record recovery.
  • Users with the system administrator role can view and restore deleted records from all tables through the Power Apps environment settings.
  • Restoring records affected by custom business logic requires applying the inverse operation to recover both the primary record and related records.
  • Some limitations may apply to records deleted through table relationship cascade behavior, although these can generally be restored.
 

Dataverse Recycle Bin Feature

The introduction of the Recycle Bin feature in Dataverse marks a significant advancement in data management and recovery for organizations using the Microsoft Power Platform. This feature offers a safeguard against accidental or unintended deletions of table records, aligning with the increasing demand for robust data protection mechanisms in digital platforms. By enabling this feature, administrators provide users a configurable window of opportunity, up to 30 days, to restore deleted records to their original state. This development not only enhances data integrity and operational continuity but also reduces the administrative burden associated with manual data recovery efforts. Additionally, the ability to restore records influenced by custom business logic further showcases the flexibility and adaptability of the Dataverse environment to complex data relationships. However, the feature's current preview status and the noted limitations with certain deletion scenarios underline the ongoing evolution of this capability, emphasizing the importance of user feedback and continuous improvement in future releases.

 

 

Read the full article Dataverse | Restore deleted table records (preview)

Microsoft Dataverse - Recover Deleted Table Records in Dataverse - Preview Guide

 

Dataverse | Restore deleted table records (preview) As part of the preview feature, the Recycle bin kind of option is available under Data Management to recover table record data from any type of delete scenario within a specified configurable time frame.

To use this feature, it must be enabled in the environment where you want to restore Dataverse table records.

ENABLE RESTORE TABLE RECORDS IN AN ENVIRONMENT:

Steps to enable this:

  • Sign in as an admin (Dynamics 365 admin, Global admin, or Microsoft Power Platform admin).
  • Select Environments and open the one you want.
  • Select Settings > Product > Features.
  • Scroll down to view the Recycle Bin settings.
  • Turn On the Recycle Bin setting.
  • Specify the time interval, to be able to restore table records up to 30 days after the record was deleted.

VIEW AND RESTORE THE DELETED RECORDS IN POWER APPS:

Follow these steps to view and restore:

  • Sign in as a user with the system administrator security role.
  • Select Environments and open the one you want to view and restore deleted records.
  • Go to Settings > Data management > View Deleted Records.
  • You can view all the deleted records from all tables in a new tab.
  • Select one or more records you wish to restore, and then select Restore on the command bar.

KNOWN ISSUES

  • Some organizations add custom business logic that deletes records related to a record that is deleted.
  • To restore related records deleted by custom business logic, you need to apply the opposite logic on the Restore operation to recover the records when you restore the original record that was deleted.
  • However, Records deleted via the table relationship cascade behavior process can be restore
 

 

People also ask

How do I find deleted records in dynamics?

To locate deleted records within Dynamics, navigate to the homepage of any entity that supports this feature, such as the 'Accounts' entity homepage. From there, simply click on the 'Restore Deleted' button to proceed.

How do I delete old records from Dataverse?

For bulk deletion of records from a Dataverse table within PowerApps, users can easily manage this process directly from the associated options within PowerApps itself.

How do I restore a Dataverse table from backup?

To execute a granular restoration of data from the Data Protection page, first identify and select the desired table for restoration. Click on the completed backup button. Subsequently, from the Backup Summary page, proceed by clicking the Restore button to finalize the recovery process.

Is Dataverse backed up?

Safeguarding your data within Microsoft Power Platform and Dataverse is crucial, necessitating continuous service availability through both system-generated and manual backups. It is reassuring to note that environments with a database automatically receive system backups, ensuring data protection.

 

Keywords

Dataverse, Restore deleted records, Table recovery, Preview feature, Data restoration in Dataverse, Deleted table records recovery, Dataverse table restore, Record restoration preview