In Part 1, we built a simple MCP server in TypeScript that exposed a “getWeather” tool. Now, let’s take the next step: connecting our MCP server to Microsoft Copilot Studio so that Copilot agents can call it directly. This section will cover: Step 1 — Publish Your MCP Server to Azure To make your MCP server accessible to Copilot Studio, you’ll need to host it online. There are multiple ways to deploy it — Azure App Service, Azure Container Apps, or even Azure Functions if you prefer serverless. For example, using Azure App Service: Test using curl to ensure it responds with MCP-compatible JSON: Step 2 — Create a New Copilot in Copilot Studio Step 3 — Add Knowledge Sources Optionally, you can enrich your Copilot by adding: This gives your Copilot a baseline knowledge to answer broader questions, while the MCP server will handle specific tasks (like fetching live weather data). Step 4 — Create a Custom Connector in Dataverse To let Copilot Studio talk to our MCP server, we need a custom connector inside Dataverse/CRM. Step 5 — Add the Custom Connector to Copilot Studio you’ll see the MCP server in your Tools section of copilot. To test the setup, let’s ask Copilot: “What’s the current weather in Mumbai?” On the first attempt, Copilot will prompt you to establish a connection. Simply open the Connection Manager, click Connect, and authorize the link to your MCP server. Once connected, Copilot will fetch the live weather details for Mumbai directly from your MCP server. and click retry on the Test window of your copilot. And just like that, your MCP server is live and fully integrated. It can now provide real-time weather updates for any city mentioned in your conversation with Copilot. You can try out different variations of questions or phrasings — Copilot will intelligently interpret your request, extract the city name, and seamlessly call the MCP server to deliver accurate weather details. Beyond Weather: Business Integrations The same process works for enterprise systems. For example, instead of getWeather, you could expose: By publishing these tools via MCP, your Copilot becomes a true enterprise assistant, capable of pulling structured business data and triggering workflows on demand. We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com.

Cloudfronts is hosting an event focused on Data readiness + AI adoption on September 3rd, 2025, at the Microsoft Dallas 7000 State Highway 161, Building LC1, Irving, TX 750391, USA from 8:30 AM to 11:30 AM.   Organizations want to adopt AI but are not sure how to do this effectively. There are a lot of AI products and technologies, and it’s difficult to know what to adopt for current & future needs. This causes companies to get into an analysis mode that seems exhausting. As a Data + AI partner for Microsoft and Databricks, CloudFronts has invested a lot of time and effort to test out various AI technologies and platforms through our own learnings & customer use cases.  Join Anil Shah (CEO, CloudFronts), Marie Wiese (Founder, Marketing Copilot), Priyesh Wagh (Microsoft MVP & Practice Manager), and Kevin Dickinson (Director of Sales, North America, CloudFronts). The objective of this event is to help technical and business decision makers in their AI adoption and data readiness journey. We’ll share our journey and evaluations of AI platforms like Copilot and Azure AI Foundry and data platforms like Databricks, we will look at our recommendations and take deep dives through actual use cases.  Register Here, Join us for an engaging morning and take the next step in preparing your enterprise and data readiness for AI adoption.   “Discover How We’ve Enabled Businesses Like Yours – Explore Our Client Testimonials!”  About CloudFronts   CloudFronts is a global AI First Microsoft Solutions Partner for Business Applications, Data & AI, helping teams and organizations worldwide solve their complex business challenges with Microsoft Cloud, AI, and Azure Integration Services. We have a global presence with offices in U.S, Singapore & India.  Since 2012, CloudFronts has empowered 200+ global clients small and medium-sized clients all over the world, such as North America, Europe, Australia, MENA, Maldives & India, with diverse experiences in sectors ranging from Professional Services, Financial Services, Manufacturing, Retail, Logistics/SCM, and Non-profits.   Register Here: Join us on September 3rd at the Microsoft Dallas office for an engaging morning focused on helping you take the next step in preparing your enterprise and your data for successful AI adoption.  For any queries reach us at transform@cloudfronts.com