Display Totals from Multiple SharePoint Lists on a Home Page
Question details
Display calculated totals from multiple SharePoint lists on a home page without leaving an Excel workbook open.

- 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.
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.
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.
In Power BI Desktop, select Home > Get data > SharePoint Online list, enter the site URL, and select the lists you want to count.
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.
Select Home > Publish, then open the semantic model settings in the Power BI service to configure credentials and scheduled refresh.
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.

Display List Counts in an Embedded Power Apps App
Use a canvas app to display counts and let viewers refresh the data without opening an Excel workbook.
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.

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.




