SharePoint Lists Tools MCP server reference

Overview

Available tools

sharepoint_createList

Create a new SharePoint list on a site.

Required Parameters

• siteId: The unique ID of the site
• displayName: Display name of the list
• list: List info such as template (for example, genericList, documentLibrary, issueTracking)

sharepoint_createListColumn

Create a new column (columnDefinition) in a specific SharePoint list. You must provide the target siteId and listId, plus a valid column definition that specifies the column's name, display name, and exactly one column type (such as text, number, choice, dateTime, personOrGroup, lookup, boolean, or hyperlinkOrPicture).

Required parameters:

• siteId: The unique ID of the site
• listId: The unique ID of the list
• name: API/static name of the column (no spaces, 1-64 characters)

Optional parameters:

• displayName: User-facing display name
• description: Column description
• enforceUniqueValues: If true, values must be unique
• hidden: If true, column is hidden
• indexed: If true, values are indexed
• required: If true, a value is required
• readOnly: If true, values can't be changed
• text, number, choice, boolean, dateTime, personOrGroup, lookup, hyperlinkOrPicture: Column type settings (one required)

sharepoint_createListItem

Create a new item in a SharePoint list.

Required parameters:

• siteId: The unique ID of the site
• listId: The unique ID of the list
• fields: Field values for the list item (key/value map)

sharepoint_deleteListColumn

Delete an existing columnDefinition from a specific SharePoint list. Provide siteId, listId, and columnId. This action permanently removes the column from the list schema.

Required parameters:

• siteId: Unique ID of the site
• listId: Unique ID of the list
• columnId: Unique ID of the column to delete

sharepoint_deleteListItem

Delete a list item.

Required parameters:

• siteId: The unique ID of the site
• listId: The unique ID of the list
• itemId: The unique ID of the list item

Optional parameters:

• ifMatch: Optional ETag for concurrency control (e.g., "*")

sharepoint_editListColumn

Update an existing columnDefinition on a specific SharePoint list. Provide siteId, listId, and columnId. The body is partial - include only the properties you want to change (such as displayName, description, hidden, required, or facet settings).

Required parameters:

• siteId: Unique ID of the site
• listId: Unique ID of the list
• columnId: Unique ID of the column to update

Optional parameters:

• displayName: User-facing display name
• description: Column description
• hidden: If true, column is hidden
• required: If true, a value is required
• enforceUniqueValues: If true, values must be unique
• indexed: If true, values are indexed
• readOnly: If true, values can't be changed
• text, number, choice, dateTime, personOrGroup, lookup, hyperlinkOrPicture: Update column type settings

sharepoint_getSiteByPath

Resolve a SharePoint site by using its hostname and server-relative path.

Required parameters:

• hostname: Host name of the SharePoint tenant (for example, contoso.sharepoint.com)
• serverRelativePath: Server-relative path to the site (for example, sites/Marketing)

sharepoint_listListColumns

List column definitions (columnDefinition resources) for a specific SharePoint list. Requires siteId and listId. Supports OData params like $select, $top, and $skiptoken.

Required parameters:

• siteId: The unique ID of the site
• listId: The unique ID of the list

Optional parameters:

• select: Comma-separated list of properties to return
• filter: OData filter expression to restrict results
• orderBy: Comma-separated list of properties to order by
• top: Page size (1-999)
• skiptoken: Opaque token for paging to the next set

sharepoint_listListItems

List items from a SharePoint list.

Required parameters:

• siteId: The unique ID of the site
• listId: The unique ID of the list

Optional parameters:

• expand: Optional OData expand (for example, fields)
• top: Optional page size
• filter: Optional OData filter expression
• select: Optional OData select clause

sharepoint_listLists

List all SharePoint lists on a site.

Required parameters:

• siteId: The unique ID of the site

sharepoint_listSubsites

List child sites (subsites) for a given site.

Required parameters:

• siteId: The unique ID of the site

sharepoint_search

Search SharePoint using Microsoft Graph Search API with entityTypes=["site"].

Required parameters:

• requests: Array of searchRequest objects

Optional parameters:

• entityTypes: Must be ["site"] for SharePoint site searches
• query: Query object with KQL-style search string
• from: Zero-based offset of the first result
• size: Number of results to return (1-50)
• fields: Optional list of fields to select in the response

13. sharepoint_searchSitesByName

Search SharePoint sites by display name or partial URL (natural language).

Required parameters:

• search: Display name or partial name/URL of the SharePoint site to search for

Optional parameters:

• consistencyLevel: Required by Microsoft Graph (default: eventual)

14. sharepoint_updateListItem

Update fields of an existing list item.

Required parameters:

• siteId: The unique ID of the site
• listId: The unique ID of the list
• itemId: The unique ID of the list item
• fields: Field values to update (partial)

Optional parameters:

• ifMatch: Optional ETag for concurrency control (for example, "*" to force)

Key Features

List Management

• Create new SharePoint lists with templates
• List all lists on a site
• Support for various list templates (genericList, documentLibrary, issueTracking)

Column Operations

• Create columns with multiple data types (text, number, choice, dateTime, personOrGroup, lookup, boolean, hyperlinkOrPicture)
• Edit existing columns
• Delete columns
• List all columns in a list
• Column validation and uniqueness constraints

Item Operations

• Create list items with field values
• Update existing list items (partial updates)
• Delete list items
• List items with filtering and pagination
• Concurrency control via ETag

Site Discovery

• Search sites by name or URL
• Resolve sites by hostname and path
• List subsites
• KQL-style search with Microsoft Graph Search API

OData Query Support

• Use $select to choose properties.
• Use $filter to filter results.
• Use $expand to include related entities.
• Use $orderby to sort results.
• Use $top for pagination.
• Use $skiptoken to page through large result sets.

Column Type Support

• Text columns (single-line or multiline, plain or rich text).
• Number columns (with decimal places, minimum, and maximum values).
• Choice columns (checkboxes, dropdown, or radio buttons).
• Boolean columns.
• DateTime columns (date only or date and time).
• Person or Group columns (single or multiple selection).
• Lookup columns (reference other lists).
• Hyperlink or Picture columns.

Notes

1. All operations use Microsoft Graph API v1.0.
2. Column names must be 1-64 characters with no spaces.
3. Each column must specify exactly one column type.
4. Concurrency control is available through the If-Match header.
5. Site searches require consistencyLevel set to eventual.
6. Search results are limited to 50 items per page.
7. Partial updates are supported for columns and list items.