Add Rows to Table
Use the Add Rows to Table action to add rows to the specified table.
Complete the following steps to use the Add Rows to Table action in your workflow:
1. Drag the Add Rows to Table action under Excel Online to the canvas, place the pointer on the action, and then click 
or double-click the action. The Add Rows to Table window opens.
or double-click the action. The Add Rows to Table window opens.2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. To add an Excel Online connector type, refer to Supported Excel Online Connector Types.
If you previously added a connector type, select the appropriate Connector Type, and under Connector Name, select the connector.
4. Click TEST to validate the connector.
5. Click MAP CONNECTOR to execute the action using a connector that is different from the one that you are using to populate the input fields. In the Runtime Connector field, provide a valid Excel Online connector name. For more information about MAP CONNECTOR, see Using Map Connector.
6. In the Folder Name list, select or specify the name of the folder under which the workbook is created.
7. In the Workbook ID list, select or specify the workbook ID in which the table is created.
8. In the Sheet ID list, select or specify the sheet ID in which the table is created.
9. In the Table ID/Name list, select or specify the ID or name of the table where you want to add rows.
10. In the Select Entry Type list, select the entry type, and perform its respective task:
Entry Type | Task |
|---|---|
Single Row Entry—Specify column values for a single row. | Under Row Values, in the Column field, provide a value for the specified column. Click Add to add multiple values for multiple columns. Click  to delete any value that you added. |
Multiple Row Entries—Specify row data as comma-separated row values or a JSON array. | In the Input Data Type list, select one of the following options to provide row values: • Select Comma Separated Values, and in the Row Data field, provide comma-separated values in the Abc,123 format. If you do not want to update a cell in a row, then provide this value as null,123. Provide multiple CSV lines to add values for multiple rows. • Select JSON Array, and in the Row Data field, provide a JSON array in the [\"Abc\",\"123\"] format. If you do not want to update a cell in a row, then provide this value as [null,\"123\"]. Provide an array of JSON arrays to add values for multiple rows. |
11. Click Show additional fields.
12. In the Row Index field, provide the sheet index of the row in which you wish to add row data.
13. Click Done.
Output schema
