Skip to Content

Microsoft SharePoint

Microsoft SharePoint icon
Arcade Optimized

Arcade.dev LLM tools for Microsoft SharePoint

Author:Arcade
Version:0.9.0
Auth:User authorization via the Microsoft auth provider
36tools
PyPI VersionPython VersionsWheel StatusDownloadsLicense

Arcade.dev SharePoint toolkit for Microsoft enables programmatic access to SharePoint sites, drives, and Office files via the Microsoft Graph API. It lets developers create, read, update, and manage documents, presentations, worksheets, lists, pages, and drive items across sites and document libraries.

Capabilities

  • Manage and transform Office documents (Word, Excel, PowerPoint) and their content programmatically.
  • Perform file and folder lifecycle operations, copy/move, search, and create share links.
  • Query and manipulate site resources: sites, drives, lists, pages, and user context.
  • Batch and async-friendly workflows with resumable uploads and operation monitoring.

OAuth Provider: microsoft Scopes: Sites.Read.All, Sites.ReadWrite.All, User.Read

Available tools(36)

36 of 36
Tool nameDescriptionSecrets
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.
Copy a file or folder. Returns a completed item or an operation id.
Create a new folder in a SharePoint drive.
Create a new PowerPoint presentation in a SharePoint drive. The presentation will be created with a title slide containing the specified title.
Create a share link for a SharePoint drive item.
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.
Append a TWO_CONTENT slide with side-by-side content areas to the end of 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.
Create a new Word document in a SharePoint drive (4MB upload limit). Optionally include text content.
Create a new Excel workbook (.xlsx) in a SharePoint drive. Only .xlsx files are supported.
Delete a file or folder from a SharePoint drive.
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.
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.
Check status of an async copy operation using the full monitor URL.
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.
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.
Retrieve lists from a SharePoint site.
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.
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.
Retrieve information about a specific SharePoint site by its ID, URL, or name.
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.
Get a Word document's metadata and content from a SharePoint drive (supports only `.docx`). Returns the document content as Markdown by default, or just metadata when metadata_only is True.
Get metadata about an Excel workbook in a SharePoint drive, including worksheet list.
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.
Append text to the end of an existing Word document. This tool only supports files with the `.docx` extension and enforces the 4MB limit.
Retrieve items from a folder in a drive in a SharePoint site. Note: Due to how the Microsoft Graph API is designed, we have to retrieve all items, including the ones skipped by offset. For this reason, the tool execution time tends to increase with the offset value.
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

#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the workbook.
item_idstringRequiredThe ID of the Excel workbook.
namestringOptionalName for the new worksheet. If omitted, Excel generates a default name.
session_idstringOptionalOptional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:jsonThe created worksheet info.
#

Sharepoint.CopyItem

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

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the drive where the item lives.
item_idstringRequiredThe ID of the item to copy.
destination_folder_idstringOptionalOptional destination folder ID. If omitted, the item is copied to the same folder.
new_namestringOptionalOptional new name for the copied item.

Requirements

No secrets required

Output

Type:jsonCopy status and result.
#

Sharepoint.CreateFolder

Create a new folder in a SharePoint drive.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the drive where the folder will be created.
folder_namestringRequiredThe name of the new folder.
parent_folder_idstringOptionalOptional parent folder ID. If omitted, creates in the drive root.

Requirements

No secrets required

Output

Type:jsonThe created folder metadata.
#

Sharepoint.CreatePresentation

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

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive to create the presentation in.
titlestringRequiredThe title for the new presentation.
folder_idstringOptionalThe 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:jsonThe created presentation details.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the presentation.
item_idstringRequiredThe ID of the PowerPoint presentation to add a slide to.
slide_titlestringOptionalThe title for the new slide. Optional for layouts like BLANK.
slide_bodystringOptionalThe body content for the new slide. Supports markdown: **bold**, *italic*, __underline__, and bullet points (- item, indented with spaces for nesting). Optional for layouts like TITLE_ONLY or BLANK.
layoutstringOptionalThe 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:jsonThe updated presentation details with new slide info.
#

Sharepoint.CreateTwoContentSlide

Append a TWO_CONTENT slide with side-by-side content areas to the end of 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

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the presentation.
item_idstringRequiredThe ID of the PowerPoint presentation to add a slide to.
slide_titlestringOptionalThe title for the new slide.
left_bodystringOptionalContent for the left side of the slide. Supports markdown: **bold**, *italic*, __underline__, and bullet points (- item, indented with spaces for nesting).
right_bodystringOptionalContent for the right side of the slide. Supports markdown: **bold**, *italic*, __underline__, and bullet points (- item, indented with spaces for nesting).

Requirements

No secrets required

Output

Type:jsonThe updated presentation details with new slide info.
#

Sharepoint.CreateWordDocument

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

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive to create the document in.
titlestringRequiredFile name without extension, or with .docx. The .docx extension is normalized.
text_contentstringOptionalOptional text content to include in the new document. If omitted, an empty document is created.
folder_idstringOptionalOptional parent folder DriveItem ID. If omitted, the document is created in the root.
conflict_behaviorstringOptionalOptional conflict behavior when a file with the same name exists. One of: fail, rename, replace.

Requirements

No secrets required

Output

Type:jsonThe created Word document metadata.
#

Sharepoint.CreateWorkbook

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

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive to create the workbook in.
filenamestringRequiredFile name for the new workbook. The .xlsx extension is added automatically if not provided.
parent_folder_idstringOptionalParent folder ID. If omitted, the workbook is created in the root of the drive.
initial_datastringOptionalOptional 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:jsonThe created Excel workbook metadata with session ID.
#

Sharepoint.DeleteItem

Delete a file or folder from a SharePoint drive.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the drive where the item lives.
item_idstringRequiredThe ID of the file or folder to delete.

Requirements

No secrets required

Output

Type:jsonDeletion confirmation.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the workbook.
item_idstringRequiredThe ID of the Excel workbook.
worksheetstringRequiredName of the worksheet to delete.
session_idstringOptionalOptional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:jsonConfirmation of the worksheet deletion.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the presentation.
item_idstringRequiredThe ID of the PowerPoint presentation.

Requirements

No secrets required

Output

Type:jsonAll speaker notes from the presentation.
#

Sharepoint.GetCopyStatus

Check status of an async copy operation using the full monitor URL.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the drive where the copy operation runs.
operation_urlstringRequiredThe full monitor URL returned by copy_item (Location/Operation-Location header). DO NOT PROVIDE ONLY THE OPERATION ID, BUT THE FULL URL.

Requirements

No secrets required

Output

Type:jsonCopy operation status.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
sitestringRequiredSite 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:jsonThe drives from the SharePoint site.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
sitestringRequiredSite ID, SharePoint URL, or site name to get lists from. Prefer using a site ID whenever available for optimal performance.
list_idstringRequiredThe ID of the list to get items from.

Requirements

No secrets required

Output

Type:jsonThe SharePoint list items.
#

Sharepoint.GetListsFromSite

Retrieve lists from a SharePoint site.

Parameters

ParameterTypeReq.Description
sitestringRequiredSite 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:jsonThe SharePoint site lists.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
sitestringRequiredSite ID, SharePoint URL, or site name to retrieve base pages from. Prefer using a site ID whenever available for optimal performance
page_idstringRequiredThe ID of the page to retrieve.
include_page_contentbooleanOptionalWhether 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:jsonThe page from the SharePoint site.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the presentation.
item_idstringRequiredThe ID of the PowerPoint presentation to read.

Requirements

No secrets required

Output

Type:jsonThe presentation content as markdown.
#

Sharepoint.GetSite

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

Parameters

ParameterTypeReq.Description
sitestringRequiredSite ID, SharePoint URL, or site name to search for.

Requirements

No secrets required

Output

Type:jsonThe SharePoint site information.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the presentation.
item_idstringRequiredThe ID of the PowerPoint presentation.
slide_indexintegerRequiredThe 1-based index of the slide to get notes from.

Requirements

No secrets required

Output

Type:jsonThe speaker notes for the specified slide.
#

Sharepoint.GetWordDocument

Get a Word document's metadata and content from a SharePoint drive (supports only `.docx`). Returns the document content as Markdown by default, or just metadata when metadata_only is True.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the document.
item_idstringRequiredThe DriveItem ID of the Word document.
metadata_onlybooleanOptionalIf True, return only the document metadata without downloading the content. Defaults to False.

Requirements

No secrets required

Output

Type:jsonThe Word document metadata and optionally its content.
#

Sharepoint.GetWorkbookMetadata

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

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the workbook.
item_idstringRequiredThe ID of the Excel workbook.
session_idstringOptionalOptional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:jsonWorkbook metadata including worksheet list.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the workbook.
item_idstringRequiredThe ID of the Excel workbook.
worksheetstringOptionalWorksheet name to read from. If omitted, reads from the first worksheet.
start_rowintegerOptionalStarting row number (1-indexed). Defaults to 1.
start_colstringOptionalStarting column letter. Defaults to A.
max_rowsintegerOptionalMaximum rows to return. Defaults to 1000, maximum allowed is 1000.
max_colsintegerOptionalMaximum columns to return. Defaults to 100, maximum allowed is 100.
session_idstringOptionalOptional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:jsonWorksheet data in sparse dict format with pagination.
#

Sharepoint.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.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the document.
item_idstringRequiredThe DriveItem ID of the Word document.
text_contentstringRequiredThe text content to append to the document.

Requirements

No secrets required

Output

Type:jsonThe updated Word document metadata.
#

Sharepoint.ListItemsInFolder

Retrieve items from a folder in a drive in a SharePoint site. Note: Due to how the Microsoft Graph API is designed, we have to retrieve all items, including the ones skipped by offset. For this reason, the tool execution time tends to increase with the offset value.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the drive to get items from.
folder_idstringRequiredThe ID of the folder to get items from.
limitintegerOptionalThe number of items to get. Defaults to 100, max is 500.
offsetintegerOptionalThe number of items to skip.

Requirements

No secrets required

Output

Type:jsonThe items from the folder in the drive.
#

Sharepoint.ListPages

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

Parameters

ParameterTypeReq.Description
sitestringRequiredSite ID, SharePoint URL, or site name to retrieve base pages from. Prefer using a site ID whenever available for optimal performance.
limitintegerOptionalThe maximum number of pages to return. Defaults to 10, max is 200.

Requirements

No secrets required

Output

Type:jsonThe pages from the SharePoint site.
#

Sharepoint.ListRootItemsInDrive

Retrieve items from the root of a drive in a SharePoint site. Note: Due to how the Microsoft Graph API is designed, we have to retrieve all items, including the ones skipped by offset. For this reason, the tool execution time tends to increase with the offset value.

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the drive to get items from.
limitintegerOptionalThe number of items to get. Defaults to 100, max is 500.
offsetintegerOptionalThe number of items to skip.

Requirements

No secrets required

Output

Type:jsonThe items from the root of a drive in a SharePoint site.
#

Sharepoint.ListSites

List all SharePoint sites accessible to the current user.

Parameters

ParameterTypeReq.Description
limitintegerOptionalThe maximum number of sites to return. Defaults to 10, max is 100.
offsetintegerOptionalThe offset to start from.

Requirements

No secrets required

Output

Type:jsonThe SharePoint sites matching the search criteria.
#

Sharepoint.MoveItem

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

Parameters

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the drive where the item lives.
item_idstringRequiredThe ID of the item to move.
new_parent_idstringRequiredThe ID of the destination folder.

Requirements

No secrets required

Output

Type:jsonThe updated item metadata.
#

Sharepoint.RenameWorksheet

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

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the workbook.
item_idstringRequiredThe ID of the Excel workbook.
worksheetstringRequiredCurrent name of the worksheet to rename.
new_namestringRequiredNew name for the worksheet.
session_idstringOptionalOptional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:jsonThe renamed worksheet info.
#

Sharepoint.SearchDriveItems

Search for items in one or more Sharepoint drives. Note: when searching within a single Drive and/or Folder, due to how the Microsoft Graph API is designed, we have to retrieve all items, including the ones skipped by offset. For this reason, the tool execution time tends to increase with the offset value.

Parameters

ParameterTypeReq.Description
keywordsstringRequiredThe keywords to search for files in the drive.
drive_idstringOptionalOptionally, the ID of the drive to search items in. If not provided, the search will be performed in all drives.
folder_idstringOptionalOptionally 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.
limitintegerOptionalThe number of files to get. Defaults to 50, max is 500.
offsetintegerOptionalThe number of files to skip.

Requirements

No secrets required

Output

Type:jsonThe items from the drive(s).
#

Sharepoint.SearchSites

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. If you use the `Sharepoint.SearchSites` tool to retrieve a single site by its name, too much CO2 will be released in the atmosphere and you will contribute to catastrophic climate change.

Parameters

ParameterTypeReq.Description
keywordsstringRequiredThe search term to find sites by name or description.
limitintegerOptionalThe maximum number of sites to return. Defaults to 10, max is 100.
offsetintegerOptionalThe offset to start from.

Requirements

No secrets required

Output

Type:jsonThe SharePoint sites matching the search criteria.
#

Sharepoint.SetSlideNotes

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

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the presentation.
item_idstringRequiredThe ID of the PowerPoint presentation.
slide_indexintegerRequiredThe 1-based index of the slide to set notes on.
notesstringRequiredThe speaker notes in markdown format. Supports **bold**, *italic*, __underline__, and bullet points (- or *).

Requirements

No secrets required

Output

Type:jsonConfirmation of the notes update.
#

Sharepoint.UpdateCell

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

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the workbook.
item_idstringRequiredThe ID of the Excel workbook.
columnstringRequiredColumn letter or letters (e.g., 'A', 'BC').
rowintegerRequiredRow number (1-indexed).
valuestringRequiredThe value to set. Supports strings, numbers, booleans, and formulas (e.g., '=SUM(A1:A10)').
worksheetstringOptionalWorksheet name to update. If omitted, updates the first worksheet.
session_idstringOptionalOptional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:jsonConfirmation of the cell update.
#

Sharepoint.UpdateRange

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

ParameterTypeReq.Description
drive_idstringRequiredThe ID of the SharePoint drive containing the workbook.
item_idstringRequiredThe ID of the Excel workbook.
datastringRequiredJSON 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]].
worksheetstringOptionalWorksheet name to update. If omitted, updates the first worksheet.
session_idstringOptionalOptional session ID from a previous operation for better performance.

Requirements

No secrets required

Output

Type:jsonConfirmation of the range update with cell count.
#

Sharepoint.WhoAmI

Get information about the current user and their SharePoint environment.

Parameters

No parameters required.

Requirements

No secrets required

Output

Type:jsonGet comprehensive user profile and SharePoint environment information.
Last updated on