Microsoft SharePoint

Let the Dema Agent work with SharePoint sites, lists, document libraries, files, and sharing through Microsoft’s hosted SharePoint MCP server.

Overview

Once Microsoft SharePoint is connected, the Dema Agent can read the documents and lists your team keeps in SharePoint, and file its own output back into them.

The agent acts only when you ask it to, and Dema asks you to confirm sensitive changes first. It signs in as whoever authorized the connection, so it sees the same sites and files that person sees.

File operations work on files up to 5 MB.

---

What you can ask for

Find and read documents

Ask the agent to	For example
Locate a document	”Find the supplier agreement for Acme in the Buying site.”
Read a file into a conversation	”Open the returns policy document and summarize the exceptions.”
Browse a library	”List the files in the Marketing site’s Documents library.”

Work with lists

Ask the agent to	For example
Read list data	”What is in the Campaign Tracker list for this quarter?”
Cross-check against Dema data	”Compare the planned spend in that list with what we actually spent.”
Update items	”Mark the Black Friday campaign as complete in the tracker.”

Organize and share

Ask the agent to	For example
File the agent’s output	”Save this margin report to the Trading site’s Reports folder.”
Tidy up	”Move last season’s files into the Archive folder.”
Share a document	”Create a link to that report for the buying team.”

---

Before you connect

Every Microsoft integration needs the same prerequisites, plus a tenant setup an admin does once per Microsoft 365 tenant. Start there, then come back:

Microsoft overview

Prerequisites, one-time tenant setup, and shared troubleshooting

---

Connect Microsoft SharePoint

1. Build your MCP URL

   SharePoint is served by mcp_SharePointRemoteServer. Replace {tenant_id} with your Entra tenant ID:

   MCP URL

   https://agent365.svc.cloud.microsoft/agents/tenants/{tenant_id}/servers/mcp_SharePointRemoteServer
   
2. Connect in Dema

   In Dema, go to Agents → Settings → Integrations, find Microsoft SharePoint, and click Connect. Paste the MCP URL you built, then click Add.

3. Sign in and approve

   Sign in with a Microsoft work or school account that belongs to the same tenant as the URL, and approve the permission Dema asks for.

   You are returned to Dema with the integration marked as Active.

4. Check it works

   Ask the agent something only SharePoint can answer, for example: “List the files in the Marketing site’s Documents library.” If it comes back with real file names, the connection works.

---

Scopes Dema requests

Scope	What it allows
McpServers.SharePoint.All	Work with SharePoint sites, lists, list items, columns, document libraries, files, folders, and sharing on your behalf
offline_access	Keep the connection alive so you do not have to reconnect often

Dema requests these against your tenant’s own MCP server, so the grant covers that server and not your Microsoft 365 account as a whole.

---

Troubleshooting

A file operation fails on a large file

File operations are capped at 5 MB. The agent cannot read or upload anything larger. Share a link to the file instead, or work from a smaller extract.

The agent cannot find a site, library, or file

The agent sees only what the authorizing account can open. Grant that account access to the site or library, or reconnect with one that already has it. Name searches need the exact site or library name, so try the site URL if the name does not match.

McpServers.SharePoint.All does not appear in Entra

An Entra admin has to register or consent the Work IQ SharePoint MCP server (mcp_SharePointRemoteServer) in your tenant before anyone can grant the permission.

Still stuck? Contact support with the error message, including the Entra AADSTS code if you have one.