Update Row

Update a row of values in an Excel Online worksheet.


Due to third-party API limitations, this action card doesn't update workbooks that are stored in OneDrive shared libraries. Updates are limited to workbooks stored in personal OneDrive storage.

If a workbook is moved from personal OneDrive storage to a shared library, the Microsoft API may continue to return the data for the version of the file at the time when it was moved. If the file is moved back to personal storage, the Microsoft API may return data for both the original file and the updated file after it was moved back to personal OneDrive storage.


Field Definition Type Required
Workbook List of workbooks available in your account. Workbook is another word for your Excel files.

If you select a Workbook from the dropdown, ignore the Workbook ID field.

If you select -- Enter Workbook ID -- from the dropdown, then enter an ID in the Workbook ID field.

Dropdown TRUE
Workbook ID Option to specify a Excel Online workbook by ID.

Example of a workbook ID: 015PGUOTTY6ZMVGBRB65DLDRED7VJJEJTP

To get the ID for an Excel Online workbook, see Get a DriveItem resource.

String FALSE
Worksheet List of worksheets available in the specified workbook. A worksheet is an individual spreadsheet within a workbook, displayed as a tab in an Excel file. Dropdown TRUE


Field Definition Type Required
Row Number Row number. Number FALSE
  • Columns (A, B, C...)
  • Values to be inputted at the column location in the row. String FALSE


    Field Definition Type
    Status Code

    Result of the operation. The connector returns an HTTP status code that indicates whether the action taken by the card succeeded or failed. For example:

    • A 201 Created status code indicates success where a new resource was created.
    • A 403 Forbidden error indicates that the HTTP request wasn't processed because the necessary permissions were missing.

    For a full list of possible status codes, see HTTP status codes.


    Related topics

    Excel Online connector

    Workflow elements

    Guidance for Excel Online connector

    Excel Online API documentation