Title: Restoring Deleted Table Records in Microsoft Power Platform (preview)
Introduction In the dynamic environment of Power Platform, managing and manipulating data is an essential part of building business applications. Accidental deletions of records, however, can happen to anyone. Microsoft Power Platform’s recovery options provide a safety net, allowing users to restore deleted table records quickly and efficiently. This guide will walk you through the steps and key considerations for restoring deleted records in Power Platform. What Happens When a Record is Deleted? When records are deleted in Power Platform, they are not immediately removed from the system. Instead, they’re retained in a “soft delete” state, remaining recoverable for a certain period. This approach helps prevent data loss due to accidental deletions, as records can be restored without complex recovery methods or external backups. When Can Records Be Restored? Deleted records can be restored within 30 days of deletion. After this period, records are permanently deleted and are no longer recoverable. It’s important to act promptly if you need to restore a record to avoid permanent data loss. Turning On the Recycle Bin FeatureTo enable the Recycle Bin in your Dataverse environment, here’s what you need to do: 1. Sign in to the Power Platform admin center as an administrator (you’ll need the Dynamics 365 admin or Microsoft Power Platform admin role).2. Go to Environments: From the admin center, select Environments and open the environment where you want to enable the Recycle Bin.3. Access Feature Settings: Head to Settings > Product > Features. 4. Enable Recycle Bin: Scroll down to find the Recycle Bin setting and switch it On.5. Set the Retention Period: Choose how long you’d like deleted records to be available for recovery—up to 30 days. This setup gives you peace of mind, knowing you can retrieve records if needed, for up to 30 days after deletion.Step-by-Step Guide to Restoring Deleted Table RecordsFollow these steps to restore deleted records in Power Platform. Step 1: Go to the Power Platform Admin Center1. Open your browser and go to the Power Platform Admin Center.2. Sign in with your administrative credentials to access the environment where the deleted record was stored. Step 2: Navigate to the Environment Settings1. In the Admin Center, select Environments from the left menu.2. Choose the specific environment where the table and its records are located. Step 3: Access Deleted Records1. Go to Environments: From the admin center, select Environments and open the environment where you want to enable the Recycle Bin.2. Access Feature Settings: Head to Settings > Product > Features. Step 4: Restore the Record1. In the Deleted Rows section, find the specific record you wish to restore.2. Select the record, and then choose the Restore option. This action will reinstate the record to its original table.Important Considerations When Restoring Records1. Data Dependencies: Some records may be linked to other tables or workflows. Ensure that the restored records don’t disrupt any existing processes or create duplicates in related tables.2. Storage Capacity: Restoring large volumes of deleted records could impact storage capacity. Regularly monitor your environment’s capacity usage to prevent potential issues.3. Security and Permissions: Only users with the appropriate permissions can restore deleted records. Make sure your permissions align with your environment’s security policies. ConclusionThe ability to restore deleted records in Power Platform is a valuable feature, enabling organizations to protect and recover critical data with ease. By following these steps and keeping a few considerations in mind, administrators can manage data restoration effectively, minimizing downtime and maintaining data integrity. Whether it’s due to accidental deletion or troubleshooting needs, this feature provides a reliable solution for your data recovery needs. Thank you, Subhash Mahato for your valuable inputs to this blog!
Change Set Request in Dataverse
Problem Definition: When we use the Dataverse actions for various requirements such as Add a new row or updating any value, etc., there are many cases where the above operations are successful despite of failure of the end operation. This leads to the creation of misleading/unwanted data which may consume unnecessary space. To overcome the issue Microsoft Dataverse has come up with an option to use one single action named Change Set Request comprising of few common Dataverse actions. Solution: Steps to be followed: Conclusion: By using this action one can avoid the creation of unwanted data which may not be connected to any flow due to failure of end actions. In such cases, to avoid such scenarios one can use this action to rollback all the tasks included in the changeset if one also fails in any condition. Note: You cannot add other actions in the changeset, for now, only 3 are included. Thank you, Angarika Mane for your valuable inputs!
Create and edit tables using the table designer in Power Apps
By using the table designer in Power Apps Studio, you may create and modify Dataverse tables in canvas apps. Without leaving the program you’re using, you can manipulate the data in the table. Required permissions and limitations. Steps: Conclusion: We have the freedom to design data sources and record them in the Canvas app thanks to this capability. There is no need to travel to power apps to create a table. Thank you, Vijay for your valuable inputs to this blog!