Excel - Add Rows

Overview

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

Input File Types

The following file types are supported:

• XLSX
• XLS
• CSV

Example Flows

Please refer to the following example solutions:

• Add Rows to Excel or CSV files
• Retrieving or writing large datasets to and from Excel

Usage Notes

The 'Excel - Add Rows' action can add rows to both Excel tables and unstructured Excel/CSV worksheets and will default to add data to the last available row.

To add data to a specific location, please use the Insert from Row and Insert from Column fields.

To append data to a specific table, please set the 'Table Name' property

Key names in the 'Row Data' JSON input do not have to match column names. The action will populate from left to right therefore ensure your JSON data is in the correct order.

Please refer to this step-by-step guide: Add Rows to Excel and CSV Files with Power Automate

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different number credits. Please always check the action specific documentation and read What is an Encodian Action for a full description of how credits are consumed.

Default Parameters

The default 'Excel - Add Rows' flow action parameters are detailed below:

• 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 'Excel - Add Rows' flow action parameters are detailed below:

All output formats:

• Insert from Row: The row number after which the data provided will be inserted
  
• Insert from Column: The column number after which the data provided will be inserted
  
• Table Name: Specify the name of a table which the data provided will be appended. When setting this property, the 'Insert from Row' and 'Insert from Column' values will be ignored
• Worksheet Name: Specify the name of a specific worksheet
• Convert Numeric and Date: Auto parse numeric and date values, setting the cell format category to 'Number' or 'Date'
• Date Format: Set the date and time format - https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
• Numeric Format: Set the numeric format - https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings
• Ignore Attribute Titles: Ignores titles of JSON attributes when converting JSON to Excel
• Ignore Null Values: Ignore JSON properties which contain null values
• Culture Name: This setting is used to set the culture for the workbook prior to conversion. Please refer to the Culture Names article for a list of supported cultures. 

Return Parameters

The 'Excel - Add Rows' 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.