Microsoft SharePoint MCP connector

Microsoft SharePoint is Microsoft's collaboration and document management platform for creating websites, managing content, and organizing team resources. The Microsoft SharePoint MCP connector allows AI agents to manage documents and files, create and update pages, and work with SharePoint lists and their items. It also supports retrieving file metadata, downloading content, and organizing document libraries across SharePoint sites.

Authentication type

• OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.

Uses

Use the Microsoft SharePoint MCP connector to perform the following actions:

• Organize project documents and team files in centralized SharePoint sites
• Automate list item creation to track tasks, issues, and project milestones
• Synchronize SharePoint list data with other business applications in real time
• Build dynamic content pages that pull data from multiple SharePoint lists
• Archive and delete outdated files and list records to maintain compliance
• Extract file metadata to categorize documents by owner, date, and department
• Streamline approval workflows by updating list items based on business events

Example prompts

Use the following example prompts to invoke Microsoft SharePoint MCP connector tools from your AI assistant or Boomi Connect workflow:

• Create a new SharePoint list to track all customer complaints received this month.
• Show me all files in the marketing team's SharePoint site root folder.
• Download the latest sales report from SharePoint and send it to finance.
• Add a new project task to our SharePoint list with today's date and priority level.
• Delete all files older than January 1st from the archive SharePoint folder.
• List all items in our SharePoint HR requests list that are still pending.
• Create a new page in SharePoint to display our Q4 budget approval status.
• Update the status of all overdue items in the SharePoint project tracker to escalated.
• Get the metadata for every PDF file stored in our SharePoint document library.
• Remove the completed training record from our SharePoint employee development list.

Microsoft SharePoint MCP connector tools

The Microsoft SharePoint MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
microsoftsharepoint_microsoftsharepointcreatepage_invoke	Creates a new page in a SharePoint site with specified content and settings.
getFile	Retrieves metadata and properties for a specific file in SharePoint.
deleteFile	Removes a file from SharePoint permanently.
downloadFile	Retrieves and downloads the full content of a file from SharePoint.
listFiles	Displays all files stored in the root folder of a SharePoint site.
listItems	Displays all items contained within a SharePoint list.
createItem	Adds a new item with specified data to a SharePoint list.
getItem	Retrieves details and properties for a specific item in a list.
updateItem	Modifies the data and properties of an existing list item.
deleteItem	Removes an item from a SharePoint list permanently.
getLists	Displays all lists available within a SharePoint site.
createList	Creates a new SharePoint list with specified columns and settings.
getList	Retrieves configuration details and properties of a specific list.
updateList	Modifies the settings and properties of an existing SharePoint list.
deleteList	Removes a SharePoint list and all its contents permanently.