SharePoint Document Issues

Fix Missing Groups in a SharePoint Online Modern List View

Ayan MasoodAyan Masood Nov 20, 2026 869 views

Question details

The user needs all groups to appear in a grouped SharePoint Online modern list view.

Fix Missing Groups in a SharePoint Online Modern List View
Product
SharePoint Online
Device & OS
not provided
Scenario
A modern list view is grouped by a column and contains more groups than the view displays per page.
Observed behavior
Only 30 groups initially appear. Scrolling does not reveal the remaining groups, but additional groups appear after an existing group is opened.
Before you start

Check which column the list is grouped by and estimate how many distinct groups the view contains. You may need permission to edit the view or help from the list owner.

Solution 1Recommended

Increase the Number of Groups Displayed per Page

Use this workaround when the group display limit is lower than the number of groups in the list.

1
Open the view settings

Open the SharePoint list, select the current view name in the view options menu, and choose Edit current view.

2
Find the group limit

In the view settings, expand Group By and locate the option for the number of groups to display per page.

3
Raise and save the limit

Enter a number greater than the total number of groups, then select OK to save the view.

4
Check the list

Return to the grouped view and check whether all groups appear without opening another group first.

Increase the Number of Groups Displayed per Page
View settings may require permission: If Edit current view or the group display setting is unavailable, ask the list owner or SharePoint administrator to update the view.
Free Microsoft Office alternative

Review Exported SharePoint List Data in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for reviewing spreadsheet data. Open compatible exported files to continue working with list data, although WPS does not fix SharePoint view settings.

Review exported list data in a spreadsheetCompatible with Microsoft Excel XLSX and XLS filesA familiar interface helps make the switch easierFree, lightweight tools for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Why do more SharePoint groups appear after I open one?

This can happen when the grouped view reaches its groups-per-page limit. Opening a group may reveal additional groups, but increasing the limit above the total group count is the suggested workaround.

Where can I change the number of groups shown per page?

In the list, open the view options menu, select Edit current view, and expand Group By. Change the number of groups to display per page and select OK.

What if I cannot edit the current view?

You may not have permission to change it. Ask the list owner or SharePoint administrator to adjust the group display limit.

What should I do if raising the limit does not help?

Report the affected list, view, limit, and reproduction steps to your SharePoint administrator. An authorized administrator can submit a request through Help & support in the Microsoft 365 admin center.