CONNECT APP
Build with Sharepoint
Business Management
- OAuth
MCP
Give your agent Sharepoint tools
Every Sharepoint action is exposed as an MCP tool on Pipedream's remote server. Point a client at it with your end user's ID and Connect resolves that user's Sharepoint account for each tool call — you store no tokens.
API PROXY
Call the Sharepoint API directly
For an endpoint with no pre-built tool, the Connect proxy forwards your request to the Sharepoint API with the connected user's credentials attached. You store no tokens and write no refresh logic.
SDK
Run Sharepoint actions from your backend
Connect a user's Sharepoint account once, then run Create Folder on their behalf from your own code — TypeScript, Python, or plain HTTP.
TOOLS
Sharepoint actions
On-demand operations your product or agent can configure and run on behalf of a connected user.
-
Create Folder
actionCreate a new folder in SharePoint. See the documentationWritev0.0.12 -
Create Item
actionCreate a new item in a SharePoint list. Provide the column names and values for the new item as afieldsobject. See the documentationWritev1.0.0 -
Create Link
actionCreate a sharing link for a DriveItem. See the documentationWritev0.0.14 -
Create List
actionCreate a new list in Microsoft Sharepoint. See the documentationWritev0.0.18 -
Download File
actionDownload a Microsoft Sharepoint file to the /tmp directory. See the documentationRead-onlyv0.0.19 -
Download Files
actionBrowse and select files from SharePoint and get their metadata along with pre-authenticated download URLs (valid ~1 hour). See the documentationRead-onlyv0.0.8 -
Find File by Name
actionSearch the site's default drive for files or folders matching a query. Matches are recursive across the drive and span filename, metadata, and file content — this is not an exact filename lookup, and results are relevance-ranked.
Backed by the SharePoint Search index and eventually consistent, so newly created, renamed, or moved items may not appear until SharePoint reindexes them.
For exact, immediately-consistent lookups, prefer:
- Get File by ID when the ID is known
- Search and Filter Files for OData
$filteragainst a list/document library
See the documentation
Read-onlyv0.1.11 -
Find Files in List with Metadata
actionSearch and filter items in a SharePoint list based on metadata and custom columns. See docs hereRead-onlyv0.1.4 -
Get Current User
actionReturns the authenticated Microsoft user's ID, display name, email, and principal name via Microsoft Graph. Call this first when the user says 'my files', 'my documents', or needs identity context. Use the returnedidto identify file ownership in List Files in Folder or Find File by Name results. See the documentation.Read-onlyv0.0.6 -
Get Excel Table
actionRetrieve a table from an Excel spreadsheet stored in Sharepoint See the documentationRead-onlyv0.0.13 -
Get File by ID
actionRetrieves a file by ID. See the documentationRead-onlyv0.0.12 -
Get File Contents
actionRetrieves a Microsoft SharePoint file and returns its contents as extracted plain text or markdown. Supports plain text formats, HTML, DOCX, PDF, and other Office documents convertible to PDF (xlsx, pptx, etc.). See the documentationRead-onlyv0.0.5 -
Get Site
actionRetrieve a site by its identifier. This is a direct path/ID lookup, so it's immediately consistent and returns newly created sites without indexing delay.
Use this when you know the site path; for discovery, use Search Sites or List Sites.
See the documentation
Read-onlyv0.0.10 -
List Drives
actionList the drives available within a Microsoft Sharepoint site. See the documentationRead-onlyv0.0.5 -
List Files in Folder
actionRetrieves a list of the files and/or folders directly within a folder. See the documentationRead-onlyv0.0.12 -
List Items
actionGet the collection of items in a SharePoint list, including their field values. Supports OData filtering and field selection. See the documentationRead-onlyv0.0.1 -
List Lists
actionGet the collection of lists for a SharePoint site. Returns each list's ID, name, and template type. See the documentationRead-onlyv0.0.1 -
List Sites
actionList sites across the tenant. Backed by the SharePoint Search index and eventually consistent — newly created sites may not appear until indexing catches up.
To resolve a known site by path, prefer Get Site for an immediate lookup.
See the documentation
Read-onlyv0.0.10 -
Retrieve File Metadata
actionBrowse and select files from SharePoint to retrieve their metadata (name, size, dates, etc.) without download URLs. See the documentationRead-onlyv0.0.8 -
Search and Filter Files
actionSearch and filter SharePoint files based on metadata and custom columns. This action allows you to query files using SharePoint's custom properties, managed metadata, and other column values. See the documentationRead-onlyv0.1.4 -
Search Files
actionSearch for files across the tenant. Supports KQL via the optional query template.
Backed by the Microsoft Search index and eventually consistent — newly created or modified files may not appear until indexing catches up.
For immediate, deterministic results, prefer:
- Get File by ID when the ID is known
- List Files in Folder for path-based listing
- Search and Filter Files for OData
$filteragainst a document library
See the documentation
Read-onlyv0.0.10 -
Search Sites
actionSearch for sites across the tenant. This is a free-text search across multiple site properties — not an exact slug match.
Backed by the SharePoint Search index and eventually consistent, so newly created or renamed sites may not appear until indexing catches up.
To resolve a known site by path, prefer Get Site for an immediate, exact lookup.
See the documentation
Read-onlyv0.0.10 -
Select Files
actionA file picker action that allows browsing and selecting one or more files from SharePoint. Returns the selected files' metadata including pre-authenticated download URLs. See the documentationRead-onlyv0.0.3 -
Update Item
actionUpdate an existing item in a SharePoint list. Provide only the fields you want to change — omitted fields are left unchanged. See the documentationWritev1.0.0 -
Upload File
actionUpload a file to OneDrive. See the documentationWritev0.0.13
EVENTS
Sharepoint triggers
Event sources your backend can deploy for users and receive through a webhook.
-
File Updated or Deleted (Instant)
triggerEmit a new event when specific files are updated or deleted in a SharePoint document libraryv0.0.9 -
New File Created
triggerEmit new event when a new file is created in Microsoft Sharepoint.v0.0.11 -
New Folder Created
triggerEmit new event when a new folder is created in Microsoft Sharepoint.v0.0.11 -
New List Item
triggerEmit new event when a new list item is created in Microsoft Sharepoint.v0.0.16 -
Updated List Item
triggerEmit new event when a list item is updated in Microsoft Sharepoint.v0.0.16
MULTI-APP
Use Sharepoint with other popular apps
Most products don't stop at one integration. Pair Sharepoint with the other apps your users rely on, and ship use cases that span both.
- App slug
- sharepoint
- Authentication
- OAuth
- Categories
- Business Management
- Actions
- 25
- Triggers
- 5
- API proxy
- Available
OAuth scopes
These are the scopes Pipedream's managed Sharepoint OAuth client requests when one of your users connects an account. Supply your own OAuth client to request a different set.
- offline_access
- openid
- User.Read
- Sites.Read.All
- Files.Read.All
- Sites.ReadWrite.All
- Sites.Manage.All