Enable SharePoint MCP Tools in Copilot Studio via M365 Admin Centre

Summary

  • SharePoint MCP (Model Context Protocol) tools may be missing in Copilot Studio due to Copilot Frontier access settings.
  • Enable SharePoint MCP tools by configuring access in Microsoft 365 Admin Centre under Copilot Control System.
  • Grant “All Users” access to Web Apps in Copilot Frontier settings.
  • Tools typically appear in Copilot Studio within minutes after enabling.

Table of Contents

The Problem

When building agents or custom copilots in Copilot Studio, you may find that SharePoint MCP tools are missing from the available connectors or tools list. This prevents agents from directly interacting with SharePoint sites, libraries, lists, and files—limiting automation scenarios and knowledge integration.

SharePoint MCP tools available

What Are SharePoint MCP Tools

MCP (Model Context Protocol) tools in Copilot Studio provide standardized interfaces for AI agents to interact with external systems. SharePoint MCP tools enable agents to:

  • Read and write files in document libraries
  • Query list items and metadata

These tools are critical for enterprise scenarios where agents need to access organizational knowledge stored in SharePoint.

Solution: Enable Copilot Frontier Access

The missing SharePoint MCP tools are typically due to Copilot Frontier access restrictions in your Microsoft 365 tenant. Copilot Frontier controls which external services and web apps can be accessed by Copilot features across Microsoft 365.

To resolve this, you need to enable Web Apps access for users in the Copilot Frontier settings.

Step-by-Step Configuration

Follow these steps in the Microsoft 365 Admin Centre:

1. Navigate to M365 Admin Centre

2. Open Copilot Control System

  • In the left navigation, locate Copilot Control System (or search for “Copilot”)
  • Click to open the Copilot settings

3. Configure User Access

Navigate through the following path:

  1. Click User Access
  2. Select Copilot Frontier
  3. Click Web Apps
  4. Select All Users (or choose specific groups if you want to limit access)

Copilot Frontier settings path

4. Save and Wait

  • Click Save or Apply to confirm the changes
  • Wait a few minutes for the settings to propagate across the tenant

Verification

After enabling the settings:

  1. Open Copilot Studio: Navigate to https://copilotstudio.microsoft.com
  2. Create or edit an agent: Open an existing agent or create a new one
  3. Add a tool: Click on Tools or Actions
  4. Search for SharePoint: Look for SharePoint MCP tools in the available connectors list

You should now see SharePoint-related tools available for integration.

Testing

  1. Add the Sharepoint Lists MCP tool
  2. Login to Entra ID MCP Connected
  3. Enable and disable the granular tools of the MCP
  4. Test the tool

SharePoint MCP Tool

References