Build a LIVE SharePoint Dashboard That Updates Itself (Power Automate + Excel + Copilot)

HTML Page in SharePoint

Learn how to build a dynamic HTML page in SharePoint Online that pulls content from a SharePoint List and files stored in a Document Library, and keeps itself updated automatically with Power Automate.

https://youtu.be/_qQJIyk4KWU

In this step-by-step tutorial, you’ll see how to:

✅ Design an HTML page in SharePoint that uses files from a Document Library

✅ Show data from a SharePoint List on the page

✅ Read an Excel file stored in a SharePoint Document Library

✅ Use Power Automate to add or increment records in a SharePoint List from that Excel file

✅ Make the page update without manual edits This works for intranet dashboards, training portals, notice boards, product catalogues and department homepages. You don’t need SPFx or developer experience.