Microsoft SharePoint Excel icon

Microsoft SharePoint Excel

Read and write Excel files in SharePoint (bypasses WAC token issues).

Actions13

Table → Lookup

AI-generated

Summary

Searches a SharePoint Excel table for rows whose selected column equals the supplied value. Configure the SharePoint site, drive, Excel file, and table, then provide the column name and value to match.

Inputs

  • Site (required) — SharePoint site, selected from the list or entered by ID.
  • Drive (required) — Document library or drive containing the Excel file, selected from the list or entered by ID.
  • File (required) — Excel (.xlsx) file to search, selected from the list or entered by ID.
  • Table (required) — Table to search, selected from the list or entered by name.
  • Lookup Column (required) — Exact table column name to compare.
  • Lookup Value (required) — Value to match in that column.

Output shape

A list of n8n items, one per matching row; each item’s JSON has table column names as keys and the corresponding row values.

Matching compares string representations of cell values and the lookup value. If the column is missing, the operation errors. If no rows match, it returns one item with a message instead of an empty list.

Links

Discussion