SharePoint Document Issues

Fix Microsoft Lists Grouped View Blank After Selecting Show All

Khadija Khan Sep 30, 2026 868 views

Question details

The user needs a solution or workaround for a bug where grouped views in Microsoft Lists display no records after attempting to expand a group.

How to Fix Microsoft Lists Grouped View Appearing Blank After Selecting Show All

Product: Microsoft Lists
Device & OS: not provided
Scenario: Expanding a grouped view that contains more than 30 items in the new Microsoft Lists modern experience.
Observed behavior: The screen becomes blank or returns no records when the 'Show All' link is clicked. Adding a secondary grouping or filter also results in no records being displayed.

Before you start

Verify if your Microsoft List view is currently grouped by metadata fields and identify if any specific group contains more than 30 items.

Solution 1Recommended

Switch to the Classic SharePoint Experience

Since this is a known display bug in the new modern Lists experience, reverting to the classic view provides an immediate and reliable workaround.

The issue is isolated to the newest iteration of the Microsoft Lists modern interface. By temporarily reverting to the classic SharePoint view, you can bypass the 'Show All' pagination bug and view your grouped data seamlessly.

Access your list

Open your web browser and navigate to the affected Microsoft List.

Switch experience

Look at the bottom left corner of your screen and click on 'Return to classic SharePoint'.

Expand groups

Locate your grouped view and expand the items. The data should now load correctly without turning the screen blank.

Switch to the Classic SharePoint Experience

Temporary Workaround: Microsoft is aware of ongoing modern view bugs. You may need to use this classic view until an official patch is rolled out for the modern experience.

Solution 2

Increase the View Item Limit

Adjusting the view settings to display more items at once can prevent the 'Show All' link from appearing, bypassing the bug entirely.

Free Microsoft Office alternative

Manage and Group Large Datasets Seamlessly with WPS Office

If you are frustrated by web-based list limitations and display bugs, consider managing your extensive datasets in a robust spreadsheet environment. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. It allows you to organize, group, and filter large volumes of data without experiencing pagination errors or blank screens.

1. Export your List: In Microsoft Lists, click 'Export' and select 'Export to Excel' to save your data locally.
2. Open with WPS: Launch WPS Spreadsheets and open the downloaded file.
3. Group and Filter: Use the Data tab to apply custom groupings and filters to your records without worrying about item limits.

Fully compatible with Microsoft Excel (.xlsx) file formatsRobust data grouping, filtering, and PivotTable functionalitiesLightweight application that works offline with no browser caching bugsFamiliar user interface ensuring a seamless transition

microsoft office alternative - wps office

Frequently Asked Questions

Why does the 'Show All' link appear in my Microsoft List?

The 'Show All' link appears by design when a specific group within your list contains more items than the configured item limit (typically 30 items). Clicking it is intended to paginate and load the remaining items.

Will adding a secondary filter fix the blank screen issue?

No. In the current new modern Lists experience, users report that adding a secondary grouping or filter to a view experiencing this bug also results in no records being displayed.

How can I report this modern Lists bug to Microsoft?

You can report this issue by clicking the 'Feedback' icon (often a smiley face or megaphone icon) located in the top right corner of the Microsoft 365 navigation bar. Clearly describe that the grouped view becomes blank after selecting 'Show All'.

Document & File Issues