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 II
Super User II

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 III
Super User III

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,000)