Turn Excel Spreadsheets into a Multi-Screen Power App with AI Coding Agents
Turn your Excel data into a complete multi-screen Power App using AI Coding Agents — without manually writing the app! 🚀
In this end-to-end tutorial, I start with an Excel spreadsheet and use SharePoint’s native Import from Excel experience to convert the data into a structured SharePoint List. From there, we build a modern, fully responsive Canvas Power App on top of that data - without writing a single line of code.
And this is not the typical basic generated Power App.
We build a complete multi-screen application featuring:
✅ Home Screen with KPIs
✅ List Screen to browse client onboarding records
✅ Search and filtering capabilities
✅ Form Screen to create, view, and edit records
✅ Modern Power Apps controls
✅ Fully responsive layouts
✅ SharePoint List as the data source
✅ Modern Power Apps screen templates
✅ AI-assisted development with canvas authoring agent plugin – now generally available!
✅ Claude Code with Canvas MCP
The modern screen templates give us a great starting point with placeholder data. I then connect an AI Coding Agent like Claude Code to the Canvas App authoring experience and have the agent transform those templates into a complete business app connected to the SharePoint List.
The result?
Excel → SharePoint → Modern Multi-Screen Power App — powered by AI.
If your organization has important business processes still running in Excel, this is an example of how you can quickly modernize them using SharePoint, Power Apps and AI Coding Agents.
⏱️ Timestamps
00:00 – Turn Excel into a Multi-Screen Power App with AI Coding Agents
00:40 – Excel to App scenario
01:26 – Import Excel data into a SharePoint List
06:34 – How to build PowerApps from a SharePoint List
07:38 – Customize Power Apps with modern controls, modern templates, multi-screens etc.
10:39 – Claude Code or GitHub Copilot as Canvas Authoring Agent Plugin
12:46 – Coding agent builds the Canvas App
#excel #sharepoint #powerapps
Turbocharge your canvas development with the canvas authoring agent plugin – now generally available!
https://www.microsoft.com/en-us/power-platform/blog/power-apps/turbocharge-your-canvas-development-with-the-canvas-authoring-agent-plugin-now-generally-available/?msockid=20505a59337d64ec165f55c532c3653f