How to Recover Changed Microsoft Lists Form Data with Version History
Question details
The user needs to recover previous data values in a Microsoft Lists form after a format change affected existing list data.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Modifying the format of a Microsoft Lists form question, which inadvertently altered or hid existing list data.
- Observed behavior
- Existing list data was modified or lost due to the form format change, requiring the user to restore previous values individually for each affected item.
Before restoring items, ensure you have the necessary edit permissions for the Microsoft List and verify which specific items were affected by the recent format change.
Restore Previous Data Using Version History
Use the built-in version history feature in Microsoft Lists to revert affected items to their previous state before the form changes occurred.
Microsoft Lists automatically saves previous versions of items when changes are made, assuming versioning is enabled. You will need to manually restore the data for each affected row.
Navigate to and open your Microsoft List where the data was affected.
Select the ellipsis (...) next to a specifically affected list item to open the context menu.
Choose 'Version history' from the dropdown options.
Locate the version of the item that contains your required original data, select it, and click 'Restore'.
Repeat these steps individually for each list item that needs its data recovered.
Contact Microsoft Support for Unrecoverable Data
If the original data cannot be manually recovered through version history, administrators can escalate the issue by requesting backend support.
Manage and Protect Your Data with WPS Office
If you are looking for a reliable and lightweight alternative to Microsoft 365 for managing your lists, spreadsheets, and forms, WPS Office provides an all-in-one solution. Enjoy seamless compatibility with Microsoft formats, built-in cloud backup, and robust version history features to keep your data safe.
- 1. Download WPS Office: Visit the official WPS Office website and click the free download button.
- 2. Install the Application: Run the lightweight installer to set up WPS Office on your computer or mobile device.
- 3. Manage Your Data Securely: Open WPS Spreadsheet to easily manage, track, and recover your structured data with auto-backup features.

Frequently Asked Questions
Why did changing a Microsoft Lists form question affect my existing data?
When you modify the data type or format of a column linked to a form question (for example, changing a text field to a choice field), Microsoft Lists attempts to convert existing data. If the data is incompatible, it may be hidden or lost.
Can I restore version history for multiple items at once in Microsoft Lists?
No, currently Microsoft Lists requires you to restore version history for each item individually by selecting the ellipsis (...) next to the specific item and accessing its unique history.
How long is version history kept in Microsoft Lists?
By default, Microsoft Lists and SharePoint retain up to 500 major versions for each item. However, this limit can be customized or restricted by your organization's administrator.
What if the Version History option is missing?
If the Version History option is not visible in the item's context menu, it may be disabled in the List settings. A list owner or administrator must go to List settings > Versioning settings and enable 'Create a version each time you edit an item'.




