How to Track SharePoint List Status Changes Over Time
Question details
The user needs to track historical status changes of items in a SharePoint list for monitoring and automated reporting.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Reviewing previous item values manually or generating automated KPI reports based on status changes over time.
- Observed behavior
- SharePoint's native version history only preserves earlier item values for manual review, requiring a separate automated process to actively record and report each change.
Ensure you have Site Owner or Full Control permissions in your SharePoint site to modify list settings and create Power Automate flows.
Enable SharePoint Version History for Manual Review
Use SharePoint's built-in versioning settings to keep a manual log of all edits and status updates made to list items.
This method is ideal for quick, manual audits of individual list items. However, it does not easily support bulk exporting or automated KPI reporting.
Navigate to your SharePoint list, click the Settings gear icon in the top right corner, and select 'List settings'.
Under the General Settings column, click on 'Versioning settings'.
Scroll to 'Item Version History' and select 'Yes' for 'Create a version each time you edit an item in this list'. You can also specify the number of versions to retain to save storage space.
Click 'OK' to save. To view a status change, go back to the list, click the three vertical dots next to an item, and select 'Version history'.
Automate Status Tracking with Power Automate
Create a Power Automate flow to record every status change into a separate history list, which can then be connected to Power BI for automated reporting.
Analyze Exported SharePoint Data Easily with WPS Office
While SharePoint and Power Automate handle your automated tracking, you can effortlessly manage, analyze, and report on your exported list data using WPS Office. It is a lightweight, comprehensive office suite that perfectly replaces Microsoft Office for daily document tasks.
- 1. Export SharePoint Data: In your SharePoint history list, click 'Export' and select 'Export to Excel' to download your status change data.
- 2. Open with WPS Spreadsheet: Locate the downloaded file and open it using WPS Spreadsheet.
- 3. Analyze and Report: Use the 'PivotTable' feature under the Insert tab to instantly summarize status durations and generate professional KPI reports.

Frequently Asked Questions
Can I track who made the status change in SharePoint?
Yes, both the native SharePoint Version History and a custom Power Automate flow can capture the 'Modified By' user field, allowing you to track exactly who changed the status.
Does enabling version history consume extra storage space?
Yes, each new version of an item takes up additional storage space in your SharePoint site. You can manage this by setting a limit on the number of versions retained in the List Settings.
How do I export the complete SharePoint version history to a spreadsheet?
SharePoint does not natively export the full version history of a list to Excel directly. You must use a PowerShell script or implement the Power Automate history list method described above to easily export historical records.





