Forum Discussion
Microsoft Lists
If someone deletes a column you can't restore it. But why would they do that? I believe it's possible to backup & restore a list using Powershell (although I've never done it), or you could log a support ticket with Microsoft for them to restore the list for you.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)
Why would a user delete anything lol....sorry I work in an organisation where its possible for someone to delete something and then change their mind. Lists looks like it has now recovery options not every from a backup.
My point was if something happens like for instance an excel sheet becoming corrupt, you can restore it. If a List becomes corrupt or someone deletes a column, it would be great to restore from backup as a last resort if the list is holding company data.
I will log a ticket with MS to see if they can do it, just seems Lists is not something to hold important data for now.
I think you are over-worrying this before you've even got to grips with the product. We have business-critical data including contract & finance data in thousands of lists across the world (I'm the Power Platform Lead for a worldwide company of 73,000 staff). We've never had a problem with staff deleting columns - but make sure you control your list permissions so that only a very very small number of staff can do things like editing the site structure, deleting columns etc. And as far as I recall we've not needed to restore from a backup at any point in the last few years.
There are things you can do which we do for some critical lists. For example, create a flow in Power Automate to create an item in a "backup" list (we often do this on a completely different site) every time an item in the master list is created or modified. That way you always have another copy of the data.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Yes probably Rob, just used to having a backup as with office apps. I've verified with MS and they say there is no way to restore with a backup product, not even their own. I'll re-think using Lists or look at the flow options.