Fix SharePoint Library Grouping Above the 5,000-Item Threshold
Question details
The user needs grouped views of a large SharePoint document library, including views filtered by the first letter of a surname.

- 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.
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.
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.
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.
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.
Turn off grouping in the view settings, save the view, and check whether the narrower filter displays the expected documents.
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.
Use an ungrouped view or partition the library
Use this approach if a grouped view still fails after narrowing the filter.
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.

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.




