Fix Missing Groups in a SharePoint Online Modern List View
Question details
The user needs all groups to appear in a grouped 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.
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.
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.
Open the SharePoint list, select the current view name in the view options menu, and choose Edit current view.
In the view settings, expand Group By and locate the option for the number of groups to display per page.
Enter a number greater than the total number of groups, then select OK to save the view.
Return to the grouped view and check whether all groups appear without opening another group first.

Report Persistent Group Display Issues
Use this option if increasing the group limit does not resolve the issue.
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.

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.




