Microsoft SharePoint Excel icon

Microsoft SharePoint Excel

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

Actions13

Workbook → Get Workbooks

AI-generated

Summary

Lists .xlsx files in the selected SharePoint drive's root folder. Choose a SharePoint site and drive, either from the lists or by entering their IDs.

Inputs

  • Site (required) — Select a SharePoint site or enter its site ID. The operation's execution code does not use this value directly.
  • Drive (required) — Select a document library or drive, or enter its ID. The operation lists files from this drive's root folder.

Output shape

A list of items, one per matching Excel file.

Each item contains the file's id and name. Only root-level files whose names end in .xlsx are included; the operation does not traverse subfolders. If none are found, it returns one item with message: "No Excel files found in drive". The operation reads the drive and does not modify files.

Links

Discussion