cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BClouded
Advocate II
Advocate II

Recycle bin CDS

Hi Community

Simple question: Where is the recycle bin in CDS to restore deleted records? 
I'm afraid of the answer that there is none... Why is such key feature missing? 

Thanks
Bart

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @BClouded 

 

Another approach to this is to configure security roles so that users cannot delete records. Then train them to use “deactivate” instead of deleting. This is a very common approach and your “inactive” records essentially become the recycle bin. 

View solution in original post

5 REPLIES 5
AllanDeCastro
Advocate IV
Advocate IV

Hello,

 

There isn't really a feature like this but the backup/restore system: https://docs.microsoft.com/en-us/power-platform/admin/backup-restore-environments

 

Hope it helps!

EricRegnier
Super User
Super User

Hi @BClouded,

To supplement on @AllanDeCastro, a common option is to restore a backup as he mentioned, but this means you lose a whole day of changes. If you can live with that, that would be the simplest method. Alternatives are:

  1. Restore the backup in a new environment so you don't lose you changes, and compare the data between the 2 environments. You can prepare an Excel/CSV file and import the changes back in the desired environment.
  2. If Audit History is enabled on that entity, then you can look at the audit trail and manually restore the state of that entity. If you have a lots of records then it would take some time and wouldn't be a very efficient way

Feel free to submit that idea (if it doesn't already exists) at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Hope this helps!

timl
Super User
Super User

Hi Bart,

I agree with the others here. There is no recycle bin.

In answer to your question (why is such key feature missing?), I guess the answer is that traditional enterprise databases (eg SQL Server/Oracle/etc) don't have recycle bins and as a result, the CDS doesn't have one either.

As @EricRegnier  suggests, a simple way to restore records is to enable auditing and to recreate the entity. You can also check out the 'Recycle Bin' plug-in in XrmToolBox. This provides an easier way to restore records when you have auditing enabled.

https://www.xrmtoolbox.com/plugins/BDK.XrmToolBox.RecycleBin/

 

Hi @BClouded 

 

Another approach to this is to configure security roles so that users cannot delete records. Then train them to use “deactivate” instead of deleting. This is a very common approach and your “inactive” records essentially become the recycle bin. 

View solution in original post

Hi all
Thanks for your valuable inputs. I like the approach of @HSheild, to deactivate records instead of really removing them.

Best
Bart


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,304)