Best solution for recovering a deleted record?

(1) Share

Report

Posted on by teach20

What is the best solution for recovering a deleted record(s)? I understand that we can go back to any point in the Power Platform Admin and restore there. Still, the problem is that the Dataverse backup always contains the entire database. There is no built-in way to restore records just from a specific table.

Based on my research, I can create a new table called "Backup." Then whenever a record is deleted, I use patch and defaults functions to move that deleted record to the "Backup" table. I've also found a company called "OwnBackup" that does backup and recovery, particularly in recovering records however there are limitations (https://kb.ownbackup.com/wikis/dynamics/Limitations)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @teach20 ,

There won't be a way to automatically do a partial restore of records. It will be a manual process.

One method is to leverage Azure Synapse Link for Dataverse to have the data inside of an Azure Data Lake or Synapse Analytics workspace. Configuring append-only writes will allow you to maintain versions of the data, including deleted records. From there you could manually recreate the record in Dataverse from the data.

In many implementations that I've done, regular users won't have delete privileges to avoid this type of scenario. Delete privileges are only given to a higher privilege security role with only a handful of users assigned it. Many organizations will have retention requirements and so certain data should not be deleted. Instead, you can setup retention policies in Dataverse to automatically delete the records after so many months/years/etc.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
mjburley 370 on at

Like (1)

Report

As @ChrisPiasecki says, never allow users to delete anything, always edit security roles to stop this. They can deactivate records.

I have had this scenario recently. Restore a backup from before the record was deleted to a new environment, go into that new environment and locate the record, and then depending on complexity:
1) manually recreate it
2) download that record to excel and import into the prod environment
3) Use Kingsway (or similar) to rebuild the record correctly if it is more complex.
4) tell the user tough ...

I'm not sure about your BackUp table solution; that would require plugins on every record - just use Synapse as mentioned.

Was this reply helpful? Yes No
Fubar 8,354 Super User 2025 Season 2 on at

Like (1)

Report
General rule, don't give users permissions to delete anything important, it is easier to prevent it happening than fix it later. When we do this we also will often add an new status reason to indicate it is a 'soft delete' rather than just an intentional deactivating.

Other potential options:
Restore a recent backup to a new environment and get data from there.
Implement the synapse link/data warehouse and use that data
If auditing is turned on and you are using the Azure Security Center, this also is a possible source of data

But, depending on how complex your system is this may not be straight forward, e.g. maintaining relationships with other records, interfaces with other systems. Also need to remember that if re-creating would trigger any plugins. workflows, flows etc you have to manage that also

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (1)

Report

Hello, @teach20, depend on your data records size, you can utilize this approach I have in this tutorial to daily export your tables to Excel. Those Excel files can be used to restore your dataverse tables using your dataverse GUIDS columns when mapping the columns in the restore dataflows. Make sure the exported excel csv files include the GUID columns.

https://powerplatformplace.com/f/daily-dataverse-tables-backup-using-power-automate

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Krishna09 234 on at

Like (0)

Report

@teach20 what if have not linked my solution to azure synapse. Is there any other to recover deleted column from dataverse table?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi!
Try FluentPro Backup for Dataverse. This cloud-based platform offers automated backup and restore features for table data. FluentPro Backup provides the ability to recover deleted or damaged table data fully or granularly. The granular restoration feature allows you to recover only some records from a specific table. So, there is no need to retrieve the whole table and spend additional time restoring all data.

Was this reply helpful? Yes No
Suggested answer

Inogic 1,135 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Recovering deleted records in Microsoft Dataverse can be challenging because the built-in backup features typically restore entire databases rather than individual records.
You can try the Undo2Restore app by Inogic. It enables you to restore deleted records in Dataverse/CRM in just one click.

Inogic’s Undo2Restore app is specifically designed to address the problem of record recovery in Dataverse/CRM. Here’s how it fits into the solution:

Granular Recovery: Undo2Restore enables granular recovery of individual records, which can be highly useful if you need to restore specific records without affecting the entire database. This means that if you accidentally delete a record, like from the Accounts entity, and find that there's no way to restore it, you can use the “Restore Deleted” button in this app to recover that record. You have the option to configure the “Default Period” field in which data will be loaded in the History/Restore grid. You can adjust this value based on your business needs

User-Friendly Interface: Undo2Restore offers a user-friendly interface for users to easily search, view, and restore deleted records, which simplifies the recovery process compared to manual methods.

Versioning and Audit Logs: The app can utilize Dataverse’s audit logs to monitor changes and deletions, making it possible to restore records to their previous state.

You can download the app from Inogic website or Microsoft AppSource. Try it out for a 15-day free trial to evaluate its features.
For more information, please contact at crm@inogic.com.

Thanks,

Sam

Email: crm@inogic.com

Website: www.inogic.com

Blog: www.inogic.com/blog

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (0)

Report

Note that enabling the Dataverse recycle bin is a new (preview) feature you can now use. this should help those scenarios where rows are accidentally deleted.

https://learn.microsoft.com/en-us/power-platform/admin/restore-deleted-table-records

Was this reply helpful? Yes No