Microsoft SharePoint icon

Microsoft SharePoint

Interact with Microsoft SharePoint API

Actions11

Item → Get Many

AI-generated

Summary

Retrieve items from a selected SharePoint list, optionally filtering the results with a Microsoft Graph filter formula. The operation returns each matching item as an n8n output item and can simplify the returned data or include selected fields.

Inputs

  • Site (required) — Select a SharePoint site from the list or enter its ID.
  • List (required) — Select a list within the site or enter its ID.
  • Filter by Formula — Optional Microsoft Graph filter expression, such as fields/Title eq 'item1'. If empty, the operation requests all items.
  • Return All — When enabled, follows the response's @odata.nextLink pagination to retrieve all results. Defaults to off.
  • Limit — Maximum results when Return All is off; defaults to 50 and must be at least 1.
  • Simplify — Defaults to on. The request selects item metadata and expands the Title field; post-processing removes OData context and ETag properties. Turn off to request fields using Options.
  • Options: Fields — When Simplify is off, choose fields to request. Selecting Fields also expands the item's fields object.

Output shape

A list of n8n items, one per SharePoint list item returned.

The response's value array is unwrapped. With Simplify enabled, the request selects id, createdDateTime, lastModifiedDateTime, and webUrl, and expands fields(select=Title); post-processing removes OData context and ETag properties. With Simplify disabled, the selected Options fields determine the $select query.

Links

Discussion