SharePoint

Lists and downloads files from a SharePoint folder on demand.

Overview

The SharePoint action node retrieves all files from a specified SharePoint folder. Unlike the SharePoint Trigger which polls for changes over time, this node fetches files once as part of a workflow execution.

Use it to:

• Process all existing files in a SharePoint document library or folder
• List files for filtering and selective processing
• Retrieve files on demand from Microsoft SharePoint

Subfolders are not included — the node returns only the files directly inside the specified folder.

Parameters

Parameter	Description	Required
Credential	SharePoint account to use	Yes
Folder URL	SharePoint folder URL	Yes

Folder URL

The URL of the SharePoint folder to list files from, for example:

https://company.sharepoint.com/sites/MySite/Shared Documents/Folder

Supports expressions for dynamic folder selection:

{{$item.data.folderUrl}}

Settings

Setting	Description
Execution Mode	Once per item (default) or Once
Output Mode	How to output results when running once
Batch Size	Items to process concurrently (default 5)
Stop on Error	Stop workflow on failure

Output

One item per file found in the folder:

{
  "file": {
    "type": "fileData",
    "name": "spreadsheet.xlsx",
    "mimeType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
    "fileInfo": {
      "type": "sharepoint",
      "credentialId": "..."
    }
  }
}

Access file properties in expressions:

• File object: {{$item.data.file}}
• File name: {{$item.data.file.name}}
• MIME type: {{$item.data.file.mimeType}}

Examples

Process SharePoint Files

[Manual Trigger] → [SharePoint (folder)] → [Data Extractor] → [Insert Rows]

Batch Convert Excel Files

[SharePoint (folder)] → [Filter (mimeType contains "spreadsheet")] → [Excel to PDF] → [Copy File]

Process Files from Multiple Folders

[Import Table (folder URLs)] → [SharePoint] → [Data Extractor] → [Insert Rows]

Authentication

This node requires a connected Microsoft account with SharePoint access. Configure credentials in your workspace settings.

Tips

• Returns files only — subfolders are not included
• Not recursive — only lists files directly in the specified folder
• Use the SharePoint Trigger for continuous monitoring; use this node for one-time retrieval
• Each file in the folder becomes a separate output item