The Add Row Action lets you automatically add rows to the top or bottom of your spreadsheet as part of your flow. You can add a row containing data from a specified set of cells or from another action flow step, or you can add a specified number of empty rows and allow users to insert the data.
To create an Add Row action
In the ribbon menu, click the Actions drop-down menu and select Add Row. The Add Row Action window opens.
Complete the fields described in the following table.
Field
Description
Name
Type a descriptive name for action (for example, Add Row – Opportunities).
Save Map
Select an existing Save Map to use when adding rows.
List Object
Select the list object for which you will add rows.
Location
Specify whether to add the new rows before or after the existing data.
Disable Excel Events during execution
Select to disable excel events while performing add row action.
Input Type
Select the method used to determine how many rows will be added.
Action Flow Step Input – The number of rows added will be determined by the outcome of a previous step in the action flow. For example, if you have a Search and Select action in the flow, the number of rows added will equal the number of rows selected during that step.
Cell Reference – Select this option to specify a cell in the workbook, such as Sheet3!A1, that contains the numerical value of the number of cells you want to add.
Number of Rows – Select this option to specify a static number of rows to add.
User Input – Select this option to allow the runtime user to specify the number of rows to add.
