Manage Large SharePoint Online Workflow History Lists
Question details
Manage a growing SharePoint Online workflow history list and reduce errors associated with the 5,000-item view threshold.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Legacy workflows generate thousands of history entries every few days, and users need a way to manage the growing list.
- Observed behavior
- The history list has grown beyond the view threshold, and workflows are timing out or becoming suspended. The list size is a suspected cause, but it has not been confirmed.
Confirm which workflow platform is in use and check its current Microsoft support and retirement status. You need permission to manage list views and settings, or assistance from a SharePoint administrator.
Create a filtered workflow history view
Use a selective filtered view to work with a large history list while reducing the chance of view threshold errors.
The 5,000-item threshold limits certain list operations; it is not a limit on the total number of items a list can contain. Filtering does not delete history entries or necessarily resolve workflow timeouts.
In the SharePoint site, open Site contents and select the workflow history list if it is visible. Otherwise, ask a SharePoint administrator how to access the list.
Open Settings > List settings > Indexed columns and check for an index on a suitable filter column, such as a date or workflow-related column. Adding an index to an already large list may be restricted, so contact your administrator if it fails.
Return to the list, open the view menu, and choose Create new view or Edit current view. Under Filter, use the indexed column to select a narrow range that returns fewer than 5,000 items, then save the view.
Select the saved view from the view menu. If it still triggers a threshold error, narrow the filter or ask an administrator to review the index and query.

Distribute future workflow activity and plan migration
Reduce the load on the current site by considering separate sites for future workloads and a supported replacement for legacy workflows.
Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative for editing documents, spreadsheets, and presentations with a familiar interface. Its Office format support helps you transition your files while continuing to use SharePoint for site management.

Frequently Asked Questions
Does the Workflow Auto Cleanup job delete history list items?
No. It removes eligible completed or canceled workflow instances and related tasks, but the history list items remain.
Does a filtered view delete old workflow history?
No. A filtered view only limits what is displayed. Create or edit a view from the list's view menu and filter on a suitable indexed column to reduce the items returned.
Why does my filtered view still show a threshold error?
The filter may not be selective enough, or the query may not use a suitable index. Narrow the filter and check Settings > List settings > Indexed columns. Ask an administrator for help if an index cannot be added.
Is the large history list definitely causing my workflows to time out?
Not necessarily. Check the affected workflow's status and error details, and investigate its dependencies and platform support status as well as the history list.
Can WPS Office clean up SharePoint workflow history?
No. WPS Office can edit compatible Office documents, but SharePoint workflow history and list settings must be managed in SharePoint or with Microsoft Support.




