SharePoint Document Issues

Fix SharePoint Library Grouping Above the 5,000-Item Threshold

Muhammad TalhaMuhammad Talha Nov 13, 2026 868 views

Question details

The user needs grouped views of a large SharePoint document library, including views filtered by the first letter of a surname.

Fix SharePoint Library Grouping Above the 5,000-Item Threshold
Product
SharePoint document libraries
Device & OS
not provided
Scenario
A modern document library contains more than 100,000 items. Indexed columns are used to filter views, with some filters matching about 10,000 items.
Observed behavior
The filtered view displays items without grouping, but shows no results when grouping is enabled.
Before you start

Identify the indexed column used by the affected view and estimate how many items its filter matches. Confirm that you can edit library views and, if necessary, create indexes or move documents.

Solution 1Recommended

Narrow the indexed filter before enabling grouping

Use a more selective view when a surname filter matches too many items to group reliably.

SharePoint can hit the list view threshold when it processes filtering or grouping, even if the filter column is indexed. An index does not guarantee that a grouped view will work.

1
Check the index

In the library, open Settings, then Library settings, and select Indexed columns. Verify that the column used for your main filter is indexed; create an index if needed and available.

2
Edit the view filter

Open the affected view and use the view menu to edit it. Under Filter, narrow the indexed filter, for example by dividing a large surname range into smaller ranges or adding a selective date range.

3
Test without grouping

Turn off grouping in the view settings, save the view, and check whether the narrower filter displays the expected documents.

4
Re-enable grouping

Edit the view again, choose the desired column under Group By, and save. If the view still returns no results, narrow the filter further or use the ungrouped view.

A smaller result set may not be enough: The threshold depends on how many items SharePoint must process, not just how many are displayed. Test each grouped view after changing its filters.
Free Microsoft Office alternative

Work with Office documents in WPS Office

WPS Office is a free, lightweight alternative for working with Office documents. Its familiar interface and format compatibility make it easy to move between common Office files, though it does not change SharePoint library thresholds or fix grouped views.

Open and edit compatible Microsoft Word, Excel, and PowerPoint files, including DOCX, XLSX, and PPTXWork with documents downloaded from a SharePoint libraryUse a familiar interface for common document tasksUse a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint view work without grouping but show no results with it?

Grouping can cause SharePoint to process more items than the view threshold permits. Edit the view to use a narrower indexed filter, then test it again with grouping enabled.

Does indexing a column remove the 5,000-item threshold?

No. An index can help SharePoint filter efficiently, but grouping or other parts of a query can still trigger the threshold. Check indexes under Library settings > Indexed columns and test the complete view.

Can modern SharePoint views display more than 5,000 items?

Modern views can load items as users scroll, but scrolling does not eliminate query or grouping threshold limitations. A large ungrouped view may work while the same view fails when grouped.

How can I group a surname view that matches about 10,000 documents?

Edit the view to divide the surname filter into smaller, more selective ranges, then test each range with grouping enabled. If grouping still fails, use an ungrouped view or test separate libraries or folders.