AI and MCP

How to connect Microsoft Copilot Studio to SpendixAI with MCP

Attach SpendixAI to a Copilot Studio agent as an MCP tool using Dynamic discovery OAuth, start read-only, and see which approval details we could not confirm.

Editorial illustration for How to connect Microsoft Copilot Studio to SpendixAI with MCP

Most chat apps let you paste a link and start asking questions. Microsoft Copilot Studio works differently, because it is a place where you build agents and then give each agent a set of tools. Connecting SpendixAI, our own product for tracking expenses in India, therefore means adding it as a tool on an agent you control. This guide shows the route, the settings that matter and the limits we could not confirm.

How the pieces fit together

An agent is the assistant you will talk to. A tool is something the agent can call when it needs information. MCP, the Model Context Protocol, is the standard that lets the agent call SpendixAI as a tool. Once connected, the agent can look up your transactions and reports and explain them in plain language. SpendixAI keeps your records itself. It does not connect to your bank and does not read SMS, so the agent only sees what you have already imported or entered.

What you need first

  • A Copilot Studio agent that you are allowed to edit, with generative orchestration turned on.
  • A SpendixAI workspace that already holds some transactions.
  • Permission in your organisation to add tools, because Power Platform data policies also apply to this server.
  • The server address from Developer → MCP connections in SpendixAI.

Adding SpendixAI in six steps

  1. In SpendixAI open Developer → MCP connections and copy the server address.
  2. In Copilot Studio open your agent and go to the Tools page.
  3. Choose Add a tool, then New tool, then Model Context Protocol under Create new.
  4. Type a Server name and write a Server description. The orchestrator reads that description to decide when to call the server, so say plainly that it is for questions about your own spending.
  5. Paste the address into Server URL, choose OAuth 2.0, set the type to Dynamic discovery, then select Create and Next.
  6. On the Add tool page create a new connection, sign in to SpendixAI, pick your workspace and a permission preset, then choose Add to agent.

The address and the sign-in

The wizard asks for one value that comes from us: the Server URL. Paste the address you copied, which this article writes as <your SpendixAI server address>. Nothing else from SpendixAI is needed. There is no API key or client secret to paste, because Dynamic discovery relies on the server supporting dynamic client registration, and SpendixAI does. The agent registers itself, and you approve access on a SpendixAI consent screen.

On that screen you choose the workspace and one of three presets. Read only lets the agent view transactions and reports. Read and add also lets it create transactions and upload documents. Full access adds categorisation rules and insights. Billing and member settings are never available to an assistant.

Quick reference

ItemWhat to enter or know
Where to startAgent, then Tools, then Add a tool, then New tool
Tool typeModel Context Protocol
Server URLThe SpendixAI server address
AuthenticationOAuth 2.0 with Dynamic discovery
TransportStreamable HTTP; SSE is no longer supported after August 2025
Tool limit128 per agent, with 25 to 30 recommended

What we could not confirm

We checked these steps against Microsoft's own documentation in November 2026, and several details were not covered. The pages we read did not say whether Copilot Studio asks you to confirm each MCP tool call, so do not assume it does. Microsoft's checklist suggests deciding which actions need human approval when you design the agent, which is another reason to keep the SpendixAI preset on Read only. The exact licence needed for MCP tools was also not stated. Microsoft says Copilot Studio is available to all Microsoft 365 users, but grounding on tenant data needs pay-as-you-go billing or a Copilot Studio licence.

The answers come from the agent's model, under Microsoft's terms. For anything that matters, such as figures you plan to use for tax, open the matching SpendixAI report and compare.

Questions to try first

  • What did I spend on food last month compared with the month before?
  • Which merchants did I pay most often this quarter?
  • List my recurring charges and what each costs per year.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports