Setting up Microsoft 365 Copilot
Microsoft 365 Copilot
Choose how to connect Microsoft 365 Copilot
You can connect MSPCFO to Microsoft 365 Copilot in two ways. Choose one:
- Option A: Copilot connector (Microsoft 365 admin center). A Microsoft 365 admin adds the MSPCFO connector once, then each person connects their own MSPCFO login.
- Option B: Copilot Studio agent. Someone with Copilot Studio builds an "MSPCFO" agent with the MSPCFO MCP server as a tool and publishes it to Microsoft 365 Copilot and Teams. Most MSPCFO customers who use Copilot today connect this way.
Either way, setup takes about 10 minutes and there's nothing to install.
What you need
- An MSPCFO login for each person who will use it.
- A Microsoft 365 Copilot license for each person who will use it.
- For Option A: a Microsoft 365 admin with the Global Administrator or Search Administrator role.
- For Option B: a Copilot Studio license (or trial) with permission to create agents in your environment.
Before you start: get your browser ready
Use a normal browser window
- Use a normal browser window, not a private, InPrivate or incognito window.
Allow pop-ups
2. Allow pop-ups for the Microsoft site you're working in:
admin.microsoft.comfor Option Acopilotstudio.microsoft.comfor Option B
Sign in to MSPCFO first
3. Sign in to MSPCFO at https://app.mspcfo.com in the same browser, and select the company you want Copilot to use.
Option A: Copilot connector (Microsoft 365 admin center)
The values you'll paste
Keep this table open. The connector form asks for all of these.
| Field on the form | What to enter |
|---|---|
| Display name | MSPCFO |
| Description | MSPCFO financial reports |
| MCP endpoint URL | https://app.mspcfo.com/mcp |
| Developer name | MSPCFO |
| Website URL | https://www.mspcfo.com |
| Privacy policy URL | https://www.mspcfo.com/privacy/ |
| Terms of use URL | https://www.mspcfo.com/terms-of-service/ |
| Authentication type | OAuth 2.0 with DCR (Dynamic Client Registration) |
Open Copilot Connectors (admin, one time)
- Go to
https://admin.microsoft.comand open Copilot › Connectors. - Open the Gallery tab and choose Created by your org.
- Click Add new connector. Under Connect to an MCP server, click Add.
- Fill in the form with the values from the table above.
- For Authentication type, choose OAuth 2.0 with DCR. You don't need a client ID, client secret or reference ID, because MSPCFO registers Copilot automatically.
If the form asks for a Reference ID, you've picked plain OAuth 2.0. Switch to the DCR option. - Authorize. The MSPCFO sign-in window opens. Sign in (including multi-factor authentication if you use it) and approve access.
- Back in the admin center, click Create.
MSPCFO now appears in Copilot › Connectors › Your connections.
2. Choose who can use the MSPCFO connector
MSPCFO holds your financial data, so decide who gets the connector before you tell anyone it's there.
- In Your connections, select MSPCFO.
- In Staged rollout, choose Add staging and pick the people or the Microsoft Entra group who should have it. Nobody else will see it.
- Allow up to 10 minutes for the change to take effect.
3. Connect your MSPCFO login in Copilot Chat (each user, one time)
Each person does this once.
- Open Microsoft 365 Copilot Chat.
- Select the … menu, then Settings, then Sources.
- Find MSPCFO, click Connect and sign in with your MSPCFO login.
Option B: Copilot Studio agent
1. Create the agent (one time)
- Go to
https://copilotstudio.microsoft.comand pick the environment your organization uses. - Click Create › New agent. Name it MSPCFO, give it a short description such as "Answers questions about our MSPCFO financial reports", and click Create.
2. Add the MSPCFO MCP server as a tool
- In the agent, open the Tools tab and click Add a tool › New tool › Model Context Protocol.
- Enter the server details:
| Field | What to enter |
|---|---|
| Server name | MSPCFO |
| Server description | MSPCFO financial reports |
| Server URL | https://app.mspcfo.com/mcp |
| Authentication | OAuth 2.0, type Dynamic discovery |
3. Click Create. When asked for a connection, choose Create new connection and sign in with your MSPCFO login, then click Add to agent.
4. Open the tool's settings and make sure Credentials to use is set to End user credentials.
3. Test and publish
- In the Test pane, ask "List the MSPCFO reports I have access to." Sign in to MSPCFO if asked.
- Click Publish.
- Open Channels, choose Microsoft Teams and Microsoft 365 Copilot, and add the channel. Your Microsoft 365 admin may need to approve the agent under Integrated apps in the admin center and choose who can use it.
4. Use it (each user)
In Microsoft 365 Copilot or Teams, open the MSPCFO agent. The first time it reads MSPCFO, it asks you to sign in with your MSPCFO login.
0 Comments
Add your comment