Microsoft SharePoint icon

Microsoft SharePoint

Interact with Microsoft SharePoint API

Actions11

Item → Create or Update

AI-generated

Summary

Creates a new item or updates an existing one in a SharePoint list based on matching column values.

Inputs

  • site (required) — Select the SharePoint site to retrieve lists from. Can be selected from a list or specified by ID.
  • list (required) — Select the list in which to create or update items. Can be selected from a list or specified by ID.
  • columns (required) — Define the field values to send. The mapper loads available columns from the list. If matching columns are configured (e.g., Title), the node searches for an existing item by those values. If found, it updates the item; otherwise, it creates a new one. Note: Hyperlink, Location, and Metadata column types cannot be updated.
  • requestOptions — Advanced request options including batching settings, SSL certificate validation, proxy, and timeout.

Output shape

A single record (the created or updated item) for each input item.

If an item is updated, the ID is included in the matchingColumns. Returns the full item details. Errors are thrown for invalid requests (e.g., unique constraint violations) or if matching columns do not match an existing item.

Examples

Example 1: Create a new task item

Select a site and list, then define column values (e.g., Title, Status) in the mapper to create the item.

Example 2: Update an existing task

Select site and list, and configure matching columns (e.g., Title) to find and update the specific item.

Links

Discussion