Building Copilot Studio Agents via generative AI capabilities and using the Dataverse MCP server! First of all we built the Axolotl Agent that is our NPC (Non-Player Character) in Power Apps, through the generative experience. The prompt included what the agent was supposed to do to give it some context and what it was supposed to use as for knowledge and connectivity. Then instructions on what kind of knowledge the agent would help the player with. Mainly, it is going to be the interaction layer between Power Platform users and our Minecraft Server.

The agent is utilising the Dataverse MCP server to simplify how to work with our data. The Dataverse tables we are supposed to reach with this agent is Minecraft data that is being updated regularly with value of resources and transactions in the game. Since we’re using an MCP, we dont have to specify the use of Dataverse tables in Topics as part of set paths. By leveraging generative AI capabilities, we avoid to build all of the topics as the agent will be able to assess and try to understand the user input in order to do the necessary CRUD (Create, read, update and delete) operations as we need. To limit the use of MCP servers as a tool, we enable and disable tools in the MCP server so that a user isnt able to do everything, but only the necessary operations.

When you start a conversation for the first time, you have to authenticate using your credentials to make sure you have the necessary privileges to work with different Dataverse tables. Security 😉