Others

How to Show SharePoint List Item Counts in Left Navigation

Steve KSteve K Nov 3, 2026 869 views

Question details

The user wants to display the total number of items for a SharePoint list directly in the left navigation menu, similar to how it functioned in the classic experience.

How to Show SharePoint List Item Counts in Left Navigation
Product
SharePoint
Device & OS
not provided
Scenario
Navigating and managing modern SharePoint lists
Observed behavior
Item counts do not appear beside links in the left navigation of modern SharePoint list views, unlike in the older classic experience.
Before you start

Ensure you have list editing permissions in SharePoint and access to Microsoft Power Automate if you choose to automate the navigation title updates.

Solution 1Recommended

Use Power Automate to Update Navigation Title

Since modern SharePoint does not natively support item counts in the left navigation, you can use a Power Automate flow to periodically count items and append the total to the list's navigation title.

This workaround relies on a scheduled background task that queries the list and updates its title via SharePoint's REST API. It is ideal if having the count visible in the sidebar is a strict requirement for your team.

1
Create a Scheduled Flow

Log into Microsoft Power Automate, click 'Create', and select 'Scheduled cloud flow'. Set it to run on an interval that suits your needs (e.g., every hour).

2
Get List Items

Add a new action, search for 'Get items' (SharePoint), and select your site address and the target list.

3
Calculate the Total Count

Add a 'Compose' action. Use the expression length(outputs('Get_items')?['body/value']) to count the number of items retrieved.

4
Update List Navigation Title

Add the 'Send an HTTP request to SharePoint' action. Configure it to use the POST method to update the list's Title property, injecting the output of the Compose action into the new title string (e.g., 'My List (42)').

Use Power Automate to Update Navigation Title
API Limits: Keep in mind that very large lists might hit Power Automate threshold limits when using the 'Get items' action. Adjust pagination settings in the action if your list exceeds 5,000 items.
Free Microsoft Office alternative

Looking for a Lightweight Alternative for Office Documents?

While SharePoint handles complex list routing, your exported list data and daily office document tasks can be managed offline efficiently with WPS Office. It provides a highly compatible, free suite for all your document, spreadsheet, and presentation needs.

Easily export SharePoint lists to .xlsx and analyze data using WPS Spreadsheet, which is fully compatible with Microsoft Excel.Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight architecture that runs smoothly on almost any device without heavy system requirements.Completely free to use with a familiar, tabbed user interface for seamless migration.
microsoft office alternative - wps office

Frequently Asked Questions

Why did SharePoint remove item counts from the left navigation in the modern experience?

Microsoft redesigned the modern experience to focus on faster page load speeds and a cleaner user interface. Dynamically calculating item counts for every link in the navigation menu consumes additional resources, which is why it was removed from the modern layout.

Can I temporarily switch to the classic experience to see list counts?

Yes. You can switch to the classic experience by clicking 'Return to classic SharePoint' in the bottom-left corner of your list page. Note that your organization's administrators may have disabled this option, and modern views are generally recommended for full feature support.

Does enabling the Totals feature in a list view alter the list data?

No, enabling Totals in the list view settings only modifies how the data is presented on the screen. It simply calculates and shows the sum, count, or average of the items based on the column you select, without altering the actual records.