Copilot Studio MCP Tutorial: Dataverse CRUD Demo

How to use MCP in Copilot Studio with a Custom Connector and real Dataverse CRUD demos. This step-by-step tutorial shows exactly how Model Context Protocol (MCP) connects your agent to external knowledge and structured data. In this walkthrough, I demonstrate two practical scenarios: using the Microsoft Learn MCP server as a knowledge source, and using the native Dataverse MCP server to create, read, and update records with natural language. As a Microsoft Cloud Solution Architect and former Microsoft MVP, I focus on what actually works in production environments. 1️⃣ What Model Context Protocol (MCP) is and how it acts as the “USB for agents” 2️⃣ How to import the MCP Streamable connector from GitHub and configure the base URL correctly 3️⃣ Connecting Copilot Studio to the Microsoft Learn MCP server for semantic documentation search 4️⃣ Adding the native Dataverse MCP server and exploring its tools (list tables, read queries, update records) 5️⃣ Creating a Lego inventory table and performing natural language SQL, stock updates, and record creation ⏱ Timestamps: 0:00 Introduction and Overview 1:26 What is an MCP Server? 3:54 Creating a Custom Connector 6:06 Connecting to Microsoft Learn MCP 8:03 Using Data Versse MCP Server 10:00 Creating a Lego Set Inventory 11:36 Updating Stock Counts 12:57 Conclusion and Future Topics #CopilotStudio #PowerPlatform #Dataverse #CustomConnector #AIAgents ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 👋 About Damien Bird Microsoft Cloud Solution Architect | Former MVP & Forum Super User Helping you automate, build, and innovate with Power Platform & AI 📚 Explore & Learn: 🏫 Join the Community: https://www.skool.com/damobird365-agents-flows-7462/about 🔗 Blog: https://DamoBird365.com 🎥 Video & Quiz CPD: https://DamoBird365.com/YouTube 📜 Feedback or Request: https://forms.office.com/e/WAV1iF2Wis 💖 Support & Connect: 🤝 Become a Member: https://youtube.com/@DamoBird365/membership ☕ Buy Me a Coffee: https://BuyMeACoffee.com/DamoBird365 💼 LinkedIn: https://LinkedIn.com/In/DamoBird365