Output
SharePoint Output
Files the rows as a document (CSV, JSON, Excel or TXT, by the name's extension) — or the files a path column names — in a SharePoint library folder.
When to use it
Use it to file reports where the team already looks.
In a pipeline
Summarize (Multi-Aggregate)SharePoint Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Library | text | — | Documents |
| Folder | text | — | Reports/Monthly |
| Upload | select | — | rows |
| File name | text | — | report-{date}.xlsx |
| File path column | select | — | Default: the path a file node gives |
Example
File a monthly report
- Folder=Reports/Monthly
- File name=sales-{date}.xlsx
| Region | Total |
|---|---|
| North | 4120 |
| Region | Total |
|---|---|
| North | 4120 |
Worth knowing
- Folders are created as needed; a file with the same name is replaced (a new version in SharePoint).
- Files up to 250 MB are uploaded in one request.
- Previews upload nothing.