'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Restore Deleted Rows in a Power Apps Dataverse Table
Question details
The user needs to recover accidentally deleted rows or records from a Power Apps Dataverse table.
- Product
- Power Apps Dataverse
- Device & OS
- not provided
- Scenario
- Accidental deletion of table records where the user needs to undo the action and restore the data to its previous state.
- Observed behavior
- The deleted rows are removed from the active Dataverse table but remain recoverable through administrative settings if the action falls within the configured retention period.
Ensure you have the required administrator permissions (such as System Administrator) in the Power Platform admin center, and verify that the deletion occurred within your organization's retention window.
Restore Deleted Records via Power Platform Admin Center
Use this method to recover specific deleted rows or records from a Dataverse table as long as they are still within the retention period.
Dataverse retains deleted records for a specific period based on your administrative configurations. During this window, administrators can manually select and restore individual rows without needing a full database rollback.
Sign in to the Power Platform admin center using an account with the required administrator role.
Open the 'Settings' menu, then locate and click on 'Data management'.
Click on 'View Deleted Records' to see a list of items that are currently within the retention period.
Select the specific records or rows you want to recover, and choose the 'Restore' option to bring them back to your Dataverse table.
Restore an Entire Deleted Table or Database from Backup
Use this method if the entire Dataverse table or database was deleted, as Dataverse does not provide general table versioning.
Analyze Exported Dataverse Tables with WPS Office
While restoring Dataverse databases requires the Power Platform admin center, WPS Office is the perfect free and lightweight alternative for editing, managing, and analyzing your exported Dataverse tables and CSV reports.
- 1. Download and Install: Download WPS Office Free from the official website and complete the lightweight installation.
- 2. Open Exported Data: Launch WPS Spreadsheet and open your exported Dataverse Excel or CSV files.
- 3. Analyze and Manage: Use familiar formulas, pivot tables, and formatting tools to easily manage your data.
Frequently Asked Questions
Does Dataverse have a version history feature to restore a table?
No, Dataverse does not provide a general table versioning feature that allows you to restore an entire table to a previous state. To recover a deleted table, you must restore the environment from a backup.
Why can't I see the View Deleted Records option?
The 'View Deleted Records' option is only accessible to users with specific administrator roles, such as System Administrator. If you do not see this option, you will need to request an administrator to perform the restoration.
How long are deleted Dataverse records kept before permanent deletion?
The availability of deleted records depends on the retention period configured in your Power Platform admin settings. Once the retention period expires, the records are permanently removed and cannot be restored individually.
