SharePoint Document Issues

Manage Large SharePoint Online Workflow History Lists

Natalie TaylorNatalie Taylor Nov 18, 2026 869 views

Question details

Manage a growing SharePoint Online workflow history list and reduce errors associated with the 5,000-item view threshold.

Manage Large SharePoint Online Workflow History Lists
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the history list

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.

2
Check for an indexed column

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.

3
Create a selective view

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.

4
Test 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.

Create a filtered workflow history view
Automatic cleanup does not purge history: The Workflow Auto Cleanup job removes eligible completed or canceled workflow instances and related tasks, but it does not delete the workflow history items themselves.
Free Microsoft Office alternative

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.

Edit documents associated with SharePoint workloads in a familiar interfaceCompatible with Microsoft Office formats such as DOCX, XLSX, and PPTXOpen and edit common Office files without rebuilding them from scratchUse a free, lightweight suite for everyday document work
QA img-9

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.