Add Rows to Excel


The 'Add Rows to Excel' Power Automate action allows you to add rows to the file provided.

Input File Types

The following file types are supported:

  • XLSX
  • XLS
  • CSV

Default Parameters

The default 'Add Rows to Excel' flow action parameters are detailed below which are contextually based on the selected Output format:

  • File Content: A Base64 encoded representation of the Excel file to be processed.
  • Row Data: The JSON dataset to be processed and added as rows to the Excel file provided

Advanced Parameters

The advanced 'Add Rows to Excel' flow action parameters are detailed below:

All output formats:

Return Parameters

The 'Add Rows to Excel' flow action returns the following data. 

Action Specific Return Values

  • File Content - The processed file (Base64)

Standard Return Values

  • OperationId - The unique ID assigned to this operation.
  • HttpStatusCode - The HTTP Status code for the response.
  • HttpStatusMessage - The HTTP Status message for the response.
  • Errors - An array of error messages should an error occur.
  • Operation Status - Indicates whether the operation has been completed, has been queued or has failed.


Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk