Others

Display Totals from Multiple SharePoint Lists on a Home Page

Huda QurayshiHuda Qurayshi Nov 14, 2026 868 views

Question details

Display calculated totals from multiple SharePoint lists on a home page without leaving an Excel workbook open.

Display Totals from Multiple SharePoint Lists on a Home Page
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
A home page should show submission counts for three lists rather than individual list items.
Observed behavior
The user wants the displayed totals to reflect list changes without relying on a workbook running on one computer.
Before you start

Identify the lists to count and confirm that you can edit the SharePoint home page and access each list. Check how quickly the totals need to update, because refresh behavior depends on the solution.

Solution 1Recommended

Show List Counts with a Power BI Report

Use Power BI to aggregate multiple lists and embed the resulting totals on the SharePoint page.

The standard SharePoint List web part displays list items but does not combine totals across multiple lists. A Power BI report can show individual counts and a combined total.

A report using imported SharePoint list data updates when its semantic model refreshes, not necessarily in real time. Refresh frequency depends on the configuration and licensing.

1
Connect the lists

In Power BI Desktop, select Home > Get data > SharePoint Online list, enter the site URL, and select the lists you want to count.

2
Create the totals

Use the report's list tables to create count measures, such as COUNTROWS('List A'), and add card visuals for each count or a combined measure.

3
Publish and configure refresh

Select Home > Publish, then open the semantic model settings in the Power BI service to configure credentials and scheduled refresh.

4
Embed the report

Edit the SharePoint home page, add the Power BI web part, and enter the report link. Publish the page and ensure viewers have access to the report and the required Power BI licenses.

Show List Counts with a Power BI Report
Check the update interval: Scheduled refresh may not meet a real-time requirement. Test the delay after adding or changing a list item before relying on the dashboard.
Free Microsoft Office alternative

Work with SharePoint List Exports in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface for reviewing exported list data and moving existing files between office suites. It does not aggregate SharePoint lists or update a SharePoint dashboard.

Review and calculate totals from exported list data in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with documents and presentations alongside spreadsheets
QA img-9

Frequently Asked Questions

Can the SharePoint List web part combine counts from several lists?

No. The List web part displays items from a list, but it does not natively combine or calculate totals across multiple lists. Use Power BI, Power Apps, or a custom solution for a combined display.

Will an embedded Power BI report update immediately when a list changes?

Not necessarily. If the report imports SharePoint list data, the displayed totals update after the Power BI semantic model refreshes. Configure refresh in the Power BI service and check whether its frequency meets your needs.

Why might a Power Apps count be lower than the actual list count?

CountRows against a SharePoint list is subject to delegation limits. Check the app's data row limit and compare the result with the list; large lists may require a separately maintained summary or another aggregation method.

Do viewers need access to the embedded report or app?

Yes. Share the Power BI report or Power Apps app with the intended viewers and verify their access to the underlying resources. Power BI licensing requirements also apply.