Sign in Book a demo
microsoft-sharepoint logo Copilot Studio

How to use Microsoft SharePoint with Copilot Studio

You want Microsoft SharePoint inside Copilot Studio so it can find and summarize team documents, maintain a shared project workbook, prepare and share a project presentation, and organize a SharePoint document library — without you copy-pasting between tabs. Here is the whole setup, once.

Create your Microsoft SharePoint gateway

The gateway is the thing Copilot Studio connects to, and it is where you decide which Microsoft SharePoint tools an agent may use. You create it once and every client reuses it.

  1. Create an Arcade account

    Sign up and open the dashboard. The free tier is enough to follow this through.

  2. Create an MCP Gateway and select your Microsoft SharePoint tools

    In the dashboard, create a gateway and pick the Microsoft SharePoint tools you want to expose. The gateway is what your client connects to, and it is where tool access is decided.

  3. Copy your gateway URL

    Every client below needs it.

    https://api.arcade.dev/mcp/<YOUR-GATEWAY-SLUG>

Create a Microsoft SharePoint gateway Opens the gateway builder in your Arcade dashboard.

Connect the gateway to Copilot Studio

Heads up

Needs a Microsoft 365 subscription with access to Copilot Studio, plus an Arcade API key.

  1. Add an MCP tool to your agent

    In Copilot Studio, open your agent → Tools → Add a tool → Model Context Protocol → New tool.

  2. Point it at your gateway

    Give the server a name and description, put your gateway URL in Server URL, set Authentication to OAuth 2.0 and Type to Dynamic discovery.

  3. Authorize and try it out

    Saving redirects you to Arcade to approve access. Then start a conversation and use your Microsoft SharePoint tools — Arcade authorizes each service just in time.

Full Copilot Studio guide in the docs steps verified 2026-08-13

Get started with these SharePoint prompts

Copilot Studio can now act on your Microsoft SharePoint account. Click a prompt to copy it.

Require approval before deleting files or creating share links, and use Contextual Access policies to limit which SharePoint actions the agent may take.

Ready to actually ship your agent?

Free to start. Ready for enterprise when you are.

Try Free Book a demo