Copilot in SharePoint can build an HTML dashboard from a Microsoft List that stays linked to the list. Add items to the list, refresh the dashboard, and there they are, without generating the report again. Pair it with a page button that runs a Copilot prompt and a site skill that saves the prompt for everyone, and a one-off report becomes something your whole team runs every week.
If you’ve ever rebuilt an Excel export with charts every Monday, the live dashboard is the feature you’ll notice first. It’s one of three features that work together: the dashboard is built once, the button puts it one click away for people who’ll never write a prompt, and the skill stops the good prompt living in one person’s chat history.
How to build a live dashboard from a Microsoft List
My work tracker list had 132 items. I gave Copilot in SharePoint a prompt describing an executive dashboard: which columns to use, how to work out a red, amber or green status, and what to show. It came back as an interactive dashboard with KPIs, charts and filters for priority, category and who each item is assigned to.
To check it was live, I had Copilot add three made-up items to the list with every field filled in. It can create list items as well as read them. One click on the dashboard’s refresh button and the count went from 132 to 135, with the time of the last refresh shown on the page.
A report built from a snapshot goes stale the moment someone edits the list. Because this one’s linked, you can put it on a page and still trust it next month. The same pattern works anywhere your team keeps structured data in a list:
- Inventory tracking
- Grant applications
- Recruiting pipelines
- Customer escalations
Launch a Copilot prompt from a page button
The Button web part now has an action that opens Copilot in SharePoint with a prompt you write. The other actions are running a Power Automate flow or opening a link.
The button on my homepage is labelled for overdue and high-risk items. Its prompt tells Copilot to review the tracker list, filter for items assigned to whoever clicks it, summarise what’s overdue and high risk, and turn that into a live dashboard. Click it and the Copilot pane slides out and runs.
Labels do the work here. “Draft this week’s status.” “Find the operations manual.” “Generate my overdue high-priority items.” Nobody has to know a skill exists or remember how to word the request. The button sits on the page where they already are.
Talk to the dashboard
With a dashboard open, you can chat with Copilot about it. I asked for every in-progress item grouped by who it’s assigned to, and Copilot worked through the data behind the page and returned the list next to the charts, a question the filters weren’t built to answer.
Turn the prompt into a site skill
Copilot in SharePoint has a built-in skill for making skills. I asked it to turn the executive dashboard prompt into one, it showed a skill card to confirm, then asked whether to save it as a site skill in the SharePoint site or a personal skill in my OneDrive.
A site skill lands in the Skills folder of the site’s Agent Assets library, and everyone on the site can run it by asking for the work tracker executive dashboard. Skills run within each person’s own permissions, so nobody sees data they couldn’t already open.
Where skills pay off most is the work you run on a schedule: the weekly status page, the monthly review, a new dashboard for each project.
Write the save rule before anyone generates a dashboard
My site has a SHAREPOINT.md file that Copilot in SharePoint loads in every conversation. One line in it says every dashboard, report and generated HTML file goes into the Reports library. No exceptions. That library has the permissions dashboards need, so nothing lands in Shared Documents where the whole organisation can open it. A dashboard someone shouldn’t see is a permissions problem, and the save rule is how you stop generated content making it worse.
Fix the list before the dashboard, too. Copilot can only chart columns that exist. If status, priority and owner are buried in a notes field, split them into proper columns first. Why your SharePoint needs an information architecture before AI covers the foundations.
And build the button before you announce the skill. Most people won’t go looking for skills, but they’ll click a labelled button on the homepage.
You’ll need a Microsoft 365 Copilot licence to use Copilot in SharePoint. If you want dashboards as proper pages in the site rather than files in a library, SharePoint HTML pages explains how that works.
Frequently asked questions
Does a Copilot in SharePoint dashboard update when the list changes? In my demo it did. The dashboard stayed linked to the Microsoft List, and clicking refresh took it from 132 to 135 items after three were added. It also shows when it was last refreshed.
What can a SharePoint button do besides open a link? The Button web part can open a link, run a Power Automate flow, or open Copilot in SharePoint with a prompt you set in the button’s properties.
What is SHAREPOINT.md? It’s a file of site instructions that Copilot in SharePoint loads in every conversation on that site. Rules in it, such as which library generated reports are saved to, apply to every user without anyone having to remember them.
Where are Copilot in SharePoint skills saved? Site skills go in the Skills folder of the site’s Agent Assets library, where everyone on the site can use them. Personal skills go to your OneDrive.
Can Copilot in SharePoint add items to a list? Yes. In my demo it read the list’s columns and created three new items with every field filled in.
