;}%20.st6{fill:url(%23SVGID_00000021089067129159788970000008246765442136188072_);}%20.st7{fill:url(%23SVGID_00000117639240116366130650000015074833605515028638_);}%20.st8{opacity:0.4;fill:url(%23SVGID_00000101781798616409025840000016567063639337360777_);}%20.st9{opacity:0.4;fill:url(%23SVGID_00000052086836598721292040000002033117744178971046_);}%20.st10{opacity:0.4;fill:url(%23SVGID_00000159460939004760751800000002448009281983951536_);}%20.st11{opacity:0.4;fill:url(%23SVGID_00000013177830667419993080000017721442101626521532_);}%20.st12{opacity:0.4;fill:url(%23SVGID_00000152235521444854938490000006526001119318383285_);}%20.st13{opacity:0.4;fill:url(%23SVGID_00000119823135212293698520000012774889010992664993_);}%20%3c/style%3e%3cg%3e%3cpolygon%20class='st2'%20points='134.78,14.22%20114.31,48.21%20101.33,69.75%20158.22,69.75%20177.97,36.95%20191.67,14.22%20'/%3e%3cpolygon%20class='st3'%20points='227.55,69.75%20186.61,69.75%20101.33,69.75%20129.78,119.02%20158.16,119.02%20228.61,119.02%20256,119.02%20'/%3e%3cpolygon%20class='st3'%20points='136.93,132.47%20116.46,167.93%2073.82,241.78%20130.71,241.78%20144.9,217.2%20180.13,156.18%20193.82,132.46%20'/%3e%3cpolygon%20class='st3'%20points='121.7,131.95%20101.23,96.49%2058.59,22.63%2030.15,71.91%2044.34,96.49%2079.57,157.5%2093.26,181.22%20'/%3e%3cpolygon%20class='st2'%20points='64.81,131.95%2025.15,131.21%200,130.74%2028.44,180.01%2066.73,180.72%2093.26,181.21%20'/%3e%3cpolygon%20class='st2'%20points='165.38,181.74%20184.58,216.46%20196.75,238.47%20225.19,189.2%20206.66,155.69%20193.83,132.46%20'/%3e%3c/g%3e%3c/svg%3e)
Windmill HubWork with SharePoint sites from any Windmill script, flow or app: upload, download, search and organize files in document libraries, and read, create and update list items.
Set up in 2 steps
Connect from the Resources page
Open Resources, click Add a resource/API and pick ms_sharepoint from the OAuth APIs list. Click Connect and sign in with your Microsoft account, then name the resource and save it.
Run your first script
Fork the list list items or list files script below and pick a site from the dropdown. File scripts act on the site's default document library unless you pick another one.
Scripts
Building blocks, if none of the projects above fit. Fork one, run it, or call it as a step inside your own flow.
New or Updated List Item
New or Updated File
Upload File
Update List Item
Search Files
Search Files Across Sites
Move or Rename File or Folder
Search Sites
List Lists
List List Items
List Files in Folder
List Document Libraries
List Columns
Get Site
Get List Item
Get File or Folder
Get Current User
Download File
Delete File or Folder
Create Sharing Link
Create List Item
Create List
Create Folder
Copy File or Folder
Trigger flows from Microsoft SharePoint
Microsoft SharePoint is not only a destination. These inbound paths are supported today.
New or updated list item (scheduled poll)
In a flow, add a trigger, choose Scheduled Poll, pick the New or Updated List Item script and an interval. Each run emits the items created (or also modified) in the list since the previous one, with their column values. It polls because Microsoft Graph push notifications need a subscription that is renewed against a public endpoint.
New or updated file (scheduled poll)
Same setup with the New or Updated File script: each run emits the files created (or also modified) in a document library since the previous one, optionally only under one folder.
Resource type
The shape of the credential every script on this page expects.
ms_sharepoint
View raw schema →| Field | Type | Required | What it is |
|---|---|---|---|
| token | string | Yes | Microsoft Graph access token. Filled in and refreshed by Windmill when you connect with OAuth. |
Questions
What can Windmill do in SharePoint?
By default: read and edit files, lists and list items in every site the account you sign in with can reach (Sites.ReadWrite.All, plus User.Read and offline_access). Windmill never sees more than that account does. Creating a list needs Sites.Manage.All, which is not in the default: tick it when connecting.
How do I read a document library's metadata columns?
A document library is also a list. Use List List Items on the library's list: each item is a file with its column values, and you can filter on them, for example fields/Status eq 'Approved'.
Why does my list filter fail?
SharePoint refuses to filter or sort on a column that is not indexed. Index the column in the list settings, or set allow_unindexed on the script, which works but is slow on large lists.
Does it work with a personal Microsoft account?
No. SharePoint sites only exist for work or school accounts. For personal files use the OneDrive integration.
There is no Connect button on my instance
Self-hosted instances need an admin to register an app in Microsoft Entra ID once, then add SharePoint under Instance settings, OAuth, with its client id, secret and tenant. Use common as the tenant for a multi-tenant app or personal accounts, or your tenant id for a single-tenant app. The app's redirect URI is <your instance>/oauth/callback/ms_sharepoint. The same Entra app can serve the Outlook, OneDrive, SharePoint and Excel connections.