Actions16
Table → Append
AI-generatedSummary
Append rows of values to a selected Excel table in a workbook and sheet. Choose how to supply row data, and optionally insert the new row at a specified position.
Inputs
- Workbook (required) — Select a workbook from the list or provide its ID.
- Sheet (required) — Select a worksheet from the list or provide its ID.
- Table (required) — Select a table from the list or provide its ID.
- Data Mode — Choose Auto-Map Input Data to Columns, Map Each Column Below, or Raw. Auto-map uses incoming item properties whose names match destination columns; mapped mode sets values for selected columns; raw mode sends JSON data.
- Data (required) — JSON data for the rows to append, entered as an array of string arrays, for example [["Sara","1/2/2006","Berlin"]].
- Values to Send — In mapped mode, add one or more destination columns and the value to write to each.
- Options: Index — Zero-based position for the inserted row; rows below it shift down. Defaults to 0 in the UI, while the description says an unspecified index appends at the end.
- Options: RAW Data — Return the API response as raw data instead of parsing values into keys based on the table header.
- Options: Data Property — When RAW Data is enabled, the property name in which to place the raw response; defaults to
data.
Output shape
One output item per input item, containing the response for the appended row or rows.
The operation calls Microsoft Graph to add rows to the selected table. With RAW Data enabled, the response is placed in the configured data property; otherwise, results are parsed into keys based on the table headers. The source pack shows a table-column lookup to filter input fields to destination columns.