Microsoft SharePoint

Arcade Optimized

Arcade.dev LLM tools for Microsoft SharePoint

Author:Arcade

Version:0.1.3

Auth:User authorization via the Microsoft auth provider

36tools

The Microsoft SharePoint toolkit connects Arcade to Microsoft SharePoint via the Microsoft Graph API, enabling LLMs to read, write, and manage SharePoint sites, drives, lists, pages, and Office documents programmatically.

Capabilities

Site & drive navigation — list, search, and inspect SharePoint sites, document libraries, drives, folders, pages, and lists; retrieve the current user's context.
File operations — copy, move, delete, rename, and create share links for files and folders; check async copy status; search across drives.
Excel workbook management — create workbooks, add/rename/delete worksheets, read cell ranges, update individual cells or sparse multi-cell ranges, and retrieve workbook metadata. Session IDs mitigate Graph API propagation delays after structural changes.
PowerPoint authoring — create presentations, append single-content or two-column slides, set or retrieve per-slide speaker notes, get full presentation content as Markdown.
Word document handling — create .docx files, read content as Markdown, append text to existing documents (4 MB limit enforced).
Lists and pages — retrieve SharePoint list items (attachment presence noted but not downloadable via Graph), list and read site pages including web part content.

OAuth

This toolkit uses OAuth 2.0 delegated auth via the Microsoft provider. Arcade manages the token flow; see the Microsoft auth provider docs for setup details.

Available tools(36)

36 of 36 tools

Operations

Behavior

	Tool name	Description	Secrets
	MicrosoftSharepoint.AddWorksheet	Add a new worksheet to a SharePoint Excel workbook. Note: The new worksheet name may not be immediately visible to other tools due to a brief Graph API propagation delay (up to ~10 s). Pass the returned ``session_id`` to subsequent calls that reference the new worksheet to mitigate this.
	MicrosoftSharepoint.CopyItem	Copy a file or folder. Returns a completed item or an operation id.
	MicrosoftSharepoint.CreateFolder	Create a new folder in a SharePoint drive.
	MicrosoftSharepoint.CreatePresentation	Create a new PowerPoint presentation in a SharePoint drive. The presentation will be created with a title slide containing the specified title.
	MicrosoftSharepoint.CreateShareLink	Create a share link for a SharePoint drive item.
	MicrosoftSharepoint.CreateSlide	Append a new slide to the end of an existing PowerPoint presentation in a SharePoint drive. The slide will be added at the end of the presentation. Both title and body are optional to support layouts like BLANK or TITLE_ONLY. For presentations larger than 4 MB, the upload uses a resumable session. Concurrency protection (etag check) is best-effort in that case, since Microsoft Graph upload sessions do not support If-Match headers.
	MicrosoftSharepoint.CreateTwoContentSlide	Append a TWO_CONTENT slide with side-by-side content areas to a SharePoint PowerPoint. This layout is useful for comparisons, pros/cons lists, or any content that benefits from a two-column layout. For presentations larger than 4 MB, the upload uses a resumable session. Concurrency protection (etag check) is best-effort in that case, since Microsoft Graph upload sessions do not support If-Match headers.
	MicrosoftSharepoint.CreateWordDocument	Create a new Word document in a SharePoint drive. 4MB upload limit. Optionally include text content.
	MicrosoftSharepoint.CreateWorkbook	Create a new Excel workbook (.xlsx) in a SharePoint drive. Only .xlsx files are supported.
	MicrosoftSharepoint.DeleteItem	Delete a file or folder from a SharePoint drive.
	MicrosoftSharepoint.DeleteWorksheet	Delete a worksheet from a SharePoint Excel workbook. Cannot delete the last worksheet in a workbook. Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.
	MicrosoftSharepoint.GetAllSlideNotes	Get all speaker notes from every slide in a SharePoint PowerPoint presentation. Returns notes for all slides in one call, which is more efficient than calling get_slide_notes for each slide individually. Notes are returned in markdown format.
	MicrosoftSharepoint.GetCopyStatus	Check status of an async copy operation using the token returned by copy_item.
	MicrosoftSharepoint.GetDrivesFromSite	Retrieve drives / document libraries from a SharePoint site. If you have a site name, it is not necessary to call Sharepoint.SearchSites first. You can simply call this tool with the site name / keywords.
	MicrosoftSharepoint.GetItemsFromList	Retrieve items from a list in a SharePoint site. Note: The Microsoft Graph API does not offer endpoints to retrieve list item attachments. Because of that, the only information we can get is whether the item has attachments or not.
	MicrosoftSharepoint.GetListsFromSite	Retrieve lists from a SharePoint site.
	MicrosoftSharepoint.GetPage	Retrieve metadata and the contents of a page in a SharePoint site. Page content is a list of Microsoft Sharepoint web part objects, such as text, images, banners, buttons, etc. If `include_page_content` is set to False, the tool will return only the page metadata.
	MicrosoftSharepoint.GetPresentationAsMarkdown	Get the content of a PowerPoint presentation stored in a SharePoint drive as markdown. This tool downloads the presentation and converts it to a markdown representation, preserving text content, tables, and chart data. Images and other media are represented as placeholders.
	MicrosoftSharepoint.GetSite	Retrieve information about a specific SharePoint site by its ID, URL, or name.
	MicrosoftSharepoint.GetSlideNotes	Get the speaker notes from a specific slide in a SharePoint PowerPoint presentation. Speaker notes are returned in markdown format, preserving basic formatting like bold, italic, and bullet points.
	MicrosoftSharepoint.GetWordDocument	Get a Word document's metadata and content from a SharePoint drive. Supports only `.docx`. Returns the document content as Markdown by default. Returns only metadata when metadata_only is True.
	MicrosoftSharepoint.GetWorkbookMetadata	Get metadata about an Excel workbook in a SharePoint drive, including worksheet list.
	MicrosoftSharepoint.GetWorksheetData	Read cell values from a worksheet in a SharePoint Excel workbook. Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.
	MicrosoftSharepoint.InsertTextAtEndOfWordDocument	Append text to the end of an existing Word document. This tool only supports files with the `.docx` extension and enforces the 4MB limit.
	MicrosoftSharepoint.ListItemsInFolder	Retrieve items from a folder in a drive in a SharePoint site. Note: The Microsoft Graph API requires retrieving all items, including those skipped by offset. Execution time increases with higher offset values.

Page 1 of 2(25 of 36)

Selected tools

No tools selected.

Click "Show all tools" to add tools.

Requirements

Select tools to see requirements

MicrosoftSharepoint.AddWorksheet

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Create

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Add a new worksheet to a SharePoint Excel workbook. Note: The new worksheet name may not be immediately visible to other tools due to a brief Graph API propagation delay (up to ~10 s). Pass the returned ``session_id`` to subsequent calls that reference the new worksheet to mitigate this.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the workbook.
`item_id`	`string`	Required	The ID of the Excel workbook.
`name`	`string`	Optional	Name for the new worksheet. If omitted, Excel generates a default name.
`session_id`	`string`	Optional	Optional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:json— The created worksheet info.

MicrosoftSharepoint.CopyItem

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Create

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Copy a file or folder. Returns a completed item or an operation id.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the drive where the item lives.
`item_id`	`string`	Required	The ID of the item to copy.
`destination_folder_id`	`string`	Optional	Optional destination folder ID. If omitted, the item is copied to the same folder.
`new_name`	`string`	Optional	Optional new name for the copied item.

Requirements

No secrets required

Output

Type:json— Copy status and result.

MicrosoftSharepoint.CreateFolder

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Create

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Create a new folder in a SharePoint drive.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the drive where the folder will be created.
`folder_name`	`string`	Required	The name of the new folder.
`parent_folder_id`	`string`	Optional	Optional parent folder ID. If omitted, creates in the drive root.

Requirements

No secrets required

Output

Type:json— The created folder metadata.

MicrosoftSharepoint.CreatePresentation

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Create

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Create a new PowerPoint presentation in a SharePoint drive. The presentation will be created with a title slide containing the specified title.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive to create the presentation in.
`title`	`string`	Required	The title for the new presentation.
`folder_id`	`string`	Optional	The ID of the folder to create the presentation in. If not provided, the presentation will be created in the root of the drive.

Requirements

No secrets required

Output

Type:json— The created presentation details.

MicrosoftSharepoint.CreateShareLink

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Create

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Create a share link for a SharePoint drive item.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the drive where the item lives.
`item_id`	`string`	Required	The ID of the file or folder to share.

Requirements

No secrets required

Output

Type:json— Sharing link information.

MicrosoftSharepoint.CreateSlide

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Update

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Append a new slide to the end of an existing PowerPoint presentation in a SharePoint drive. The slide will be added at the end of the presentation. Both title and body are optional to support layouts like BLANK or TITLE_ONLY. For presentations larger than 4 MB, the upload uses a resumable session. Concurrency protection (etag check) is best-effort in that case, since Microsoft Graph upload sessions do not support If-Match headers.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the presentation.
`item_id`	`string`	Required	The ID of the PowerPoint presentation to add a slide to.
`slide_title`	`string`	Optional	The title for the new slide. Optional for layouts like BLANK.
`slide_body`	`string`	Optional	The body content for the new slide. Supports markdown: bold, italic, __underline__, and bullet points (- item, use spaces for nesting). Optional for layouts like TITLE_ONLY or BLANK.
`layout`	`string`	Optional	The layout to use for the slide. For TWO_CONTENT layout, use create_two_content_slide. `TITLETITLE_AND_CONTENTSECTION_HEADERTITLE_ONLYBLANKCONTENT_WITH_CAPTIONPICTURE_WITH_CAPTIONTITLE_AND_VERTICAL_TEXTVERTICAL_TITLE_AND_TEXT`

Requirements

No secrets required

Output

Type:json— The updated presentation details with new slide info.

MicrosoftSharepoint.CreateTwoContentSlide

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Update

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Append a TWO_CONTENT slide with side-by-side content areas to a SharePoint PowerPoint. This layout is useful for comparisons, pros/cons lists, or any content that benefits from a two-column layout. For presentations larger than 4 MB, the upload uses a resumable session. Concurrency protection (etag check) is best-effort in that case, since Microsoft Graph upload sessions do not support If-Match headers.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the presentation.
`item_id`	`string`	Required	The ID of the PowerPoint presentation to add a slide to.
`slide_title`	`string`	Optional	The title for the new slide.
`left_body`	`string`	Optional	Content for the left side of the slide. Supports markdown: bold, italic, __underline__, and bullet points (- item, use spaces for nesting).
`right_body`	`string`	Optional	Content for the right side of the slide. Supports markdown: bold, italic, __underline__, and bullet points (- item, use spaces for nesting).

Requirements

No secrets required

Output

Type:json— The updated presentation details with new slide info.

MicrosoftSharepoint.CreateWordDocument

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Create

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Create a new Word document in a SharePoint drive. 4MB upload limit. Optionally include text content.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive to create the document in.
`title`	`string`	Required	File name without extension, or with .docx. The .docx extension is normalized.
`text_content`	`string`	Optional	Optional text content to include in the new document. If omitted, an empty document is created.
`folder_id`	`string`	Optional	Optional parent folder DriveItem ID. If omitted, the document is created in the root.
`conflict_behavior`	`string`	Optional	Optional conflict behavior when a file with the same name exists. One of: fail, rename, replace.

Requirements

No secrets required

Output

Type:json— The created Word document metadata.

MicrosoftSharepoint.CreateWorkbook

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Create

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Create a new Excel workbook (.xlsx) in a SharePoint drive. Only .xlsx files are supported.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive to create the workbook in.
`filename`	`string`	Required	File name for the new workbook. Adds the .xlsx extension if not provided.
`parent_folder_id`	`string`	Optional	Parent folder ID. If omitted, the workbook is created in the root of the drive.
`initial_data`	`string`	Optional	Optional JSON string for initial data in the first worksheet. Format: data[ROW][COL] = VALUE where ROW is a row number as string, COL is a column letter (uppercase), VALUE is string/number/boolean/null. Type: dict[str, dict[str, str \| int \| float \| bool \| None]].

Requirements

No secrets required

Output

Type:json— The created Excel workbook metadata with session ID.

MicrosoftSharepoint.DeleteItem

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Delete

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

Yes

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Delete a file or folder from a SharePoint drive.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the drive where the item lives.
`item_id`	`string`	Required	The ID of the file or folder to delete.

Requirements

No secrets required

Output

Type:json— Deletion confirmation.

MicrosoftSharepoint.DeleteWorksheet

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Delete

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

Yes

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Delete a worksheet from a SharePoint Excel workbook. Cannot delete the last worksheet in a workbook. Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the workbook.
`item_id`	`string`	Required	The ID of the Excel workbook.
`worksheet`	`string`	Required	Name of the worksheet to delete.
`session_id`	`string`	Optional	Optional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:json— Confirmation of the worksheet deletion.

MicrosoftSharepoint.GetAllSlideNotes

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Get all speaker notes from every slide in a SharePoint PowerPoint presentation. Returns notes for all slides in one call, which is more efficient than calling get_slide_notes for each slide individually. Notes are returned in markdown format.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the presentation.
`item_id`	`string`	Required	The ID of the PowerPoint presentation.

Requirements

No secrets required

Output

Type:json— All speaker notes from the presentation.

MicrosoftSharepoint.GetCopyStatus

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Check status of an async copy operation using the token returned by copy_item.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the drive where the copy operation runs.
`operation_url`	`string`	Required	The opaque operation token returned by copy_item. Pass it exactly as received.

Requirements

No secrets required

Output

Type:json— Copy operation status.

MicrosoftSharepoint.GetDrivesFromSite

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Retrieve drives / document libraries from a SharePoint site. If you have a site name, it is not necessary to call Sharepoint.SearchSites first. You can simply call this tool with the site name / keywords.

Parameters

Parameter	Type	Req.	Description
`site`	`string`	Required	Site ID, SharePoint URL, or site name to get drives from. Prefer using a site ID whenever available for optimal performance.

Requirements

No secrets required

Output

Type:json— The drives from the SharePoint site.

MicrosoftSharepoint.GetItemsFromList

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Retrieve items from a list in a SharePoint site. Note: The Microsoft Graph API does not offer endpoints to retrieve list item attachments. Because of that, the only information we can get is whether the item has attachments or not.

Parameters

Parameter	Type	Req.	Description
`site`	`string`	Required	Site ID, SharePoint URL, or site name to get lists from. Prefer using a site ID whenever available for optimal performance.
`list_id`	`string`	Required	The ID of the list to get items from.

Requirements

No secrets required

Output

Type:json— The SharePoint list items.

MicrosoftSharepoint.GetListsFromSite

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Retrieve lists from a SharePoint site.

Parameters

Parameter	Type	Req.	Description
`site`	`string`	Required	Site ID, SharePoint URL, or site name to get lists from. Prefer using a site ID whenever available for optimal performance.

Requirements

No secrets required

Output

Type:json— The SharePoint site lists.

MicrosoftSharepoint.GetPage

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Retrieve metadata and the contents of a page in a SharePoint site. Page content is a list of Microsoft Sharepoint web part objects, such as text, images, banners, buttons, etc. If `include_page_content` is set to False, the tool will return only the page metadata.

Parameters

Parameter	Type	Req.	Description
`site`	`string`	Required	Site ID, SharePoint URL, or site name to retrieve base pages from. Prefer using a site ID whenever available for optimal performance
`page_id`	`string`	Required	The ID of the page to retrieve.
`include_page_content`	`boolean`	Optional	Whether to include the page content in the response. Defaults to True. If set to False, the tool will return only the page metadata.

Requirements

No secrets required

Output

Type:json— The page from the SharePoint site.

MicrosoftSharepoint.GetPresentationAsMarkdown

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Get the content of a PowerPoint presentation stored in a SharePoint drive as markdown. This tool downloads the presentation and converts it to a markdown representation, preserving text content, tables, and chart data. Images and other media are represented as placeholders.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the presentation.
`item_id`	`string`	Required	The ID of the PowerPoint presentation to read.

Requirements

No secrets required

Output

Type:json— The presentation content as markdown.

MicrosoftSharepoint.GetSite

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Retrieve information about a specific SharePoint site by its ID, URL, or name.

Parameters

Parameter	Type	Req.	Description
`site`	`string`	Required	Site ID, SharePoint URL, or site name to search for.

Requirements

No secrets required

Output

Type:json— The SharePoint site information.

MicrosoftSharepoint.GetSlideNotes

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Get the speaker notes from a specific slide in a SharePoint PowerPoint presentation. Speaker notes are returned in markdown format, preserving basic formatting like bold, italic, and bullet points.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the presentation.
`item_id`	`string`	Required	The ID of the PowerPoint presentation.
`slide_index`	`integer`	Required	The 1-based index of the slide to get notes from.

Requirements

No secrets required

Output

Type:json— The speaker notes for the specified slide.

MicrosoftSharepoint.GetWordDocument

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Get a Word document's metadata and content from a SharePoint drive. Supports only `.docx`. Returns the document content as Markdown by default. Returns only metadata when metadata_only is True.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the document.
`item_id`	`string`	Required	The DriveItem ID of the Word document.
`metadata_only`	`boolean`	Optional	If True, return only the document metadata without downloading the content. Defaults to False.

Requirements

No secrets required

Output

Type:json— The Word document metadata and optionally its content.

MicrosoftSharepoint.GetWorkbookMetadata

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Get metadata about an Excel workbook in a SharePoint drive, including worksheet list.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the workbook.
`item_id`	`string`	Required	The ID of the Excel workbook.
`session_id`	`string`	Optional	Optional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:json— Workbook metadata including worksheet list.

MicrosoftSharepoint.GetWorksheetData

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Read cell values from a worksheet in a SharePoint Excel workbook. Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the workbook.
`item_id`	`string`	Required	The ID of the Excel workbook.
`worksheet`	`string`	Optional	Worksheet name to read from. If omitted, reads from the first worksheet.
`start_row`	`integer`	Optional	Starting row number (1-indexed). Defaults to 1.
`start_col`	`string`	Optional	Starting column letter. Defaults to A.
`max_rows`	`integer`	Optional	Maximum rows to return. Defaults to 1000, maximum allowed is 1000.
`max_cols`	`integer`	Optional	Maximum columns to return. Defaults to 100, maximum allowed is 100.
`session_id`	`string`	Optional	Optional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:json— Worksheet data in sparse dict format with pagination.

MicrosoftSharepoint.InsertTextAtEndOfWordDocument

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Update

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Append text to the end of an existing Word document. This tool only supports files with the `.docx` extension and enforces the 4MB limit.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the document.
`item_id`	`string`	Required	The DriveItem ID of the Word document.
`text_content`	`string`	Required	The text content to append to the document.

Requirements

No secrets required

Output

Type:json— The updated Word document metadata.

MicrosoftSharepoint.ListItemsInFolder

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Retrieve items from a folder in a drive in a SharePoint site. Note: The Microsoft Graph API requires retrieving all items, including those skipped by offset. Execution time increases with higher offset values.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the drive to get items from.
`folder_id`	`string`	Required	The ID of the folder to get items from.
`limit`	`integer`	Optional	The number of items to get. Defaults to 100, max is 500.
`offset`	`integer`	Optional	The number of items to skip.

Requirements

No secrets required

Output

Type:json— The items from the folder in the drive.

MicrosoftSharepoint.ListPages

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Retrieve pages from a SharePoint site. The Microsoft Graph API does not support pagination on this endpoint.

Parameters

Parameter	Type	Req.	Description
`site`	`string`	Required	Site ID, SharePoint URL, or site name to retrieve base pages from. Prefer using a site ID whenever available for optimal performance.
`limit`	`integer`	Optional	The maximum number of pages to return. Defaults to 10, max is 200.

Requirements

No secrets required

Output

Type:json— The pages from the SharePoint site.

MicrosoftSharepoint.ListRootItemsInDrive

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Retrieve items from the root of a drive in a SharePoint site. Note: The Microsoft Graph API requires retrieving all items, including those skipped by offset. Execution time increases with higher offset values.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the drive to get items from.
`limit`	`integer`	Optional	The number of items to get. Defaults to 100, max is 500.
`offset`	`integer`	Optional	The number of items to skip.

Requirements

No secrets required

Output

Type:json— The items from the root of a drive in a SharePoint site.

MicrosoftSharepoint.ListSites

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

List all SharePoint sites accessible to the current user.

Parameters

Parameter	Type	Req.	Description
`limit`	`integer`	Optional	The maximum number of sites to return. Defaults to 10, max is 100.
`offset`	`integer`	Optional	The offset to start from.

Requirements

No secrets required

Output

Type:json— The SharePoint sites matching the search criteria.

MicrosoftSharepoint.MoveItem

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Update

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Move a file or folder to a new location in a SharePoint drive.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the drive where the item lives.
`item_id`	`string`	Required	The ID of the item to move.
`new_parent_id`	`string`	Required	The ID of the destination folder.

Requirements

No secrets required

Output

Type:json— The updated item metadata.

MicrosoftSharepoint.RenameWorksheet

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Update

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Rename an existing worksheet in a SharePoint Excel workbook. Note: The new name may not be immediately visible to other tools due to a brief Graph API propagation delay (up to ~10 s). Pass the returned ``session_id`` to subsequent calls that reference the renamed worksheet to mitigate this. If referencing a recently added worksheet as the source, the same delay applies; retry with the ``session_id`` if a WorksheetNotFoundError occurs.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the workbook.
`item_id`	`string`	Required	The ID of the Excel workbook.
`worksheet`	`string`	Required	Current name of the worksheet to rename.
`new_name`	`string`	Required	New name for the worksheet.
`session_id`	`string`	Optional	Optional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:json— The renamed worksheet info.

MicrosoftSharepoint.SearchDriveItems

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Search for items in one or more Sharepoint drives. Note: When searching a single Drive and/or Folder, the API must retrieve all items including those skipped by offset. Execution time increases with higher offset values.

Parameters

Parameter	Type	Req.	Description
`keywords`	`string`	Required	The keywords to search for files in the drive.
`drive_id`	`string`	Optional	Optionally, the ID of the drive to search items in. If not provided, the search will be performed in all drives.
`folder_id`	`string`	Optional	Optionally narrow the search within a specific folder by its ID. If not provided, the search will be performed in the whole drive. If a folder_id is provided, it is required to provide a drive_id as well.
`limit`	`integer`	Optional	The number of files to get. Defaults to 50, max is 500.
`offset`	`integer`	Optional	The number of files to skip.

Requirements

No secrets required

Output

Type:json— The items from the drive(s).

MicrosoftSharepoint.SearchSites

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Search for SharePoint sites by name or description. In case you need to retrieve a specific site by its name, ID or SharePoint URL, use the `Sharepoint.GetSite` tool instead, passing the ID, name or SharePoint URL to it.

Parameters

Parameter	Type	Req.	Description
`keywords`	`string`	Required	The search term to find sites by name or description.
`limit`	`integer`	Optional	The maximum number of sites to return. Defaults to 10, max is 100.
`offset`	`integer`	Optional	The offset to start from.

Requirements

No secrets required

Output

Type:json— The SharePoint sites matching the search criteria.

MicrosoftSharepoint.SetSlideNotes

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Update

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Set or update the speaker notes on a specific slide in a SharePoint PowerPoint. Notes can be formatted using markdown: - **bold** for bold text - *italic* for italic text - __underline__ for underlined text - Lines starting with - or * become bullet points - Indent with spaces for nested bullets For presentations larger than 4 MB, the upload uses a resumable session. Concurrency protection (etag check) is best-effort in that case, since Microsoft Graph upload sessions do not support If-Match headers.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the presentation.
`item_id`	`string`	Required	The ID of the PowerPoint presentation.
`slide_index`	`integer`	Required	The 1-based index of the slide to set notes on.
`notes`	`string`	Required	The speaker notes in markdown format. Supports bold, italic, __underline__, and bullet points (- or *).

Requirements

No secrets required

Output

Type:json— Confirmation of the notes update.

MicrosoftSharepoint.UpdateCell

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Update

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Update a single cell value in a SharePoint Excel workbook. Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the workbook.
`item_id`	`string`	Required	The ID of the Excel workbook.
`column`	`string`	Required	Column letter or letters (e.g., 'A', 'BC').
`row`	`integer`	Required	Row number (1-indexed).
`value`	`string`	Required	The value to set. Supports strings, numbers, booleans, and formulas like '=SUM(A1:A10)'.
`worksheet`	`string`	Optional	Worksheet name to update. If omitted, updates the first worksheet.
`session_id`	`string`	Optional	Optional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:json— Confirmation of the cell update.

MicrosoftSharepoint.UpdateRange

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Update

Service domains

Cloud storageDocuments

MCP behavior

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Update multiple cells in a SharePoint Excel worksheet using sparse dict format. Only specified cells are updated; unspecified cells remain unchanged. Internally, a single PATCH request is sent covering the bounding box of all specified cells. Cells within the box that are not in the input are sent as ``null``, which the Graph API treats as "skip". Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.

Parameters

Parameter	Type	Req.	Description
`drive_id`	`string`	Required	The ID of the SharePoint drive containing the workbook.
`item_id`	`string`	Required	The ID of the Excel workbook.
`data`	`string`	Required	JSON string where data[ROW][COL] = VALUE. ROW is a row number as string, COL is a column letter (uppercase), VALUE is string/number/boolean/null. Type: dict[str, dict[str, str \| int \| float \| bool \| None]].
`worksheet`	`string`	Optional	Worksheet name to update. If omitted, updates the first worksheet.
`session_id`	`string`	Optional	Optional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:json— Confirmation of the range update with cell count.

MicrosoftSharepoint.WhoAmI

Add to selected tools

Execution hints

Signals for MCP clients and agents about how this tool behaves.

Operations

Read

Service domains

Cloud storageDocuments

MCP behavior

Yes

Reads data without modifying any state in the target system.

May permanently delete or overwrite data in the target system.

Yes

Repeated calls with the same inputs produce no additional effect.

Yes

Communicates with external APIs, databases, or other services.

Get information about the current user and their SharePoint environment.

Parameters

No parameters required.

Requirements

No secrets required

Output

Type:json— Get comprehensive user profile and SharePoint environment information.

Get Building

Use tools hosted on Arcade Cloud

Arcade tools are hosted by our cloud platform and ready to be used in your agents. Learn how.

Learn more

Self Host Arcade tools

Arcade tools can be self-hosted on your own infrastructure. Learn more about self-hosting.

pip install arcade_microsoftsharepoint

Learn more