From the Microsoft Power Platform blogs: Power Apps MCP app; Automate Copilot Studio evaluations; Fuzzy search Dataverse tables; Copilot in Excel

In this review of the Power Platform blogs:

• Power Apps MCP app for Microsoft 365 Copilot
• Automating Copilot Studio evaluations
• How to fuzzy search Dataverse tables in Copilot Studio
• Copilot in Excel

Build a Power Apps MCP app for Microsoft 365 Copilot

On his blog, Rajeev Pentyala explained how to build a small MCP app in a Power Apps model-driven app. The app includes a custom tool that creates a five-color palette and displays it as color swatches in Microsoft 365 Copilot chat.

He stated that if you want to work with Power Platform data inside Copilot chat, a normal tool can only return text or structured data, which Copilot shows as a table or paragraph. 

However, Pentyala noted that App MCP lets the tool return an HTML widget instead, so the data can appear as a real interface inside the chat, such as a grid, form, chart, or color swatches.

In his post, Pentyala walked you through the build by creating an empty MDA, enabling App MCP, adding the custom tool, pasting the widget, and downloading the package.

Automating Copilot Studio evaluations

Writing on his blog, Craig White noted that in a previous post, he took a close look at Copilot Studio evaluations, a built-in testing feature that helps validate how an agent responds to user prompts.