SharePoint
Microsoft integration · 6 node(s).
00Overview
Microsoft SharePoint sites, lists, and document libraries
Every field below is exactly what you see in the Flomation editor. Fields marked ● live picker let you choose from a list pulled live from your account — no IDs to look up.
01Connecting SharePoint
SharePoint signs in with a Microsoft account you connect to Flomation — there is no API key or secret to paste. Connect the account once and every SharePoint node picks it up automatically. Two optional fields let you steer it:
| Field | Type | Details | |
|---|---|---|---|
| Microsoft Account (email) | string | ||
| Microsoft OAuth Credential | credential | ${credentials.MICROSOFT_SHAREPOINT} |
${credentials.GOOGLE_DRIVE}), not an environment secret. Leave both fields blank and the node just uses your connected account.02Create
Create List Item
microsoft/sharepoint/create_list_item · Action
Create a new item in a SharePoint list
| Field | Type | Details | |
|---|---|---|---|
| Site ID | string | Required | |
| List ID | string | Required | |
| Fields (JSON object) | text | Required | {"Title":"My Item","Status":"Active"} |
Returns: tool_result, item_id, success, error
03Delete
Delete List Item
microsoft/sharepoint/delete_list_item · Action
Delete an item from a SharePoint list
| Field | Type | Details | |
|---|---|---|---|
| Site ID | string | Required | |
| List ID | string | Required | |
| Item ID | string | Required |
Returns: tool_result, success, error
04Get
Get List Items
microsoft/sharepoint/get_list_items · Action
Retrieve items from a SharePoint list
| Field | Type | Details | |
|---|---|---|---|
| Site ID | string | Required | |
| List ID | string | Required | |
| Max Results | integer |
Returns: tool_result, items, count, success, error
05List
List Lists
microsoft/sharepoint/list_lists · Action
Retrieve all lists from a SharePoint site
| Field | Type | Details | |
|---|---|---|---|
| Site ID | string | Required |
Returns: tool_result, lists, count, success, error
List Sites
microsoft/sharepoint/list_sites · Action
Search and list SharePoint sites
| Field | Type | Details | |
|---|---|---|---|
| Search Query | string | Search term (leave empty for all) | |
| Max Results | integer |
Returns: tool_result, sites, count, success, error
06Update
Update List Item
microsoft/sharepoint/update_list_item · Action
Update fields on a SharePoint list item
| Field | Type | Details | |
|---|---|---|---|
| Site ID | string | Required | |
| List ID | string | Required | |
| Item ID | string | Required | |
| Fields (JSON object) | text | Required | {"Status":"Completed"} |
Returns: tool_result, success, error
07Notes & Limitations
Behaviours and constraints worth knowing before you build with these nodes.
- Site search returns only sites the connected account can access, and an empty search term will not enumerate every site — supply a name or keyword to locate the site you want.
- List-item retrieval is paginated, so a large list returns only the first page of results unless you follow through the additional pages.
- Filtering list items on a custom column requires that column to be indexed in SharePoint, otherwise the request is rejected.
- When creating or updating items, custom columns must be referenced by their internal name — which can differ from the display label and renders spaces as
_x0020_— not the name shown in the SharePoint UI. - Deleting a list item moves it to the site Recycle Bin where it can be restored, rather than removing it permanently.