MS OneDrive Business icon

MS OneDrive Business

Access MS OneDrive for Business and SharePoint

Actions16

Excel → Append or Update Row

AI-generated

Summary

Append or update a row in an Excel worksheet. Specify the drive type (user, site, sharedLink) and locate the Excel file via browse, path, or ID. Choose the worksheet. Optionally set a match column and value to update an existing row (if no match, a new row is appended). Map data using autoMap (input properties to columns by header name) or manual (define column-value pairs). Returns per input item: row number, update flag, and written column values.

Inputs

  • driveType (required) — Type of drive to access (user, site, sharedLink)
  • sharedLinkUrl (required) — Required when driveType is sharedLink; the sharing link to the folder
  • userId — Optional when driveType is user; user email or ID (empty uses authenticated user)
  • siteId (required) — Required when driveType is site; SharePoint site (by list, ID, or URL)
  • fileSelection (required) — Method to specify the Excel file (browse, path, id)
  • browseFolder1 (required) — Required when fileSelection is browse; first level folder or file ID
  • browseFolder2 — Optional when fileSelection is browse; second level folder or file ID
  • browseFolder3 — Optional when fileSelection is browse; third level folder or file ID
  • browseFolder4 — Optional when fileSelection is browse; fourth level folder or file ID
  • browseFolder5 — Optional when fileSelection is browse; fifth level folder or file ID
  • filePath (required) — Required when fileSelection is path; file path (by list, path, or ID)
  • fileId (required) — Required when fileSelection is id; file unique ID
  • worksheet (required) — Worksheet name or ID
  • columnToMatchOn — Optional column to match on for updating; if empty, always appends
  • valueToMatchOn — Value to look for in the match column (required if columnToMatchOn is set)
  • dataMode (required) — How to map data (autoMap or manual)
  • fieldsUi — Required when dataMode is manual; fixed collection of column-value pairs

Output shape

Per input item: { updated: boolean, row: number, [columnHeader]: string }

Returns an array of output items (one per input item). Each item contains the written values for all columns, plus 'updated' (true if row was updated, false if appended) and 'row' (1-indexed row number).

Examples

Example 1: Append a new row using autoMap

Drive Type: user, File Selection: browse, Worksheet: Sheet1, Data Mode: autoMap, Match Column: (empty)

Example 2: Update a row by matching on 'ID' column

Drive Type: site, File Selection: path, Worksheet: Inventory, Data Mode: manual, Match Column: ID, Matching Value: {{ $json.id }}, Fields Ui: [{ column: 'Quantity', fieldValue: {{ $json.quantity + 50] }}]

Links

Discussion