Get Rows
Use the Get Rows action to retrieve rows from the specified workbook.
Complete the following steps to use the Get Rows action in your workflow:
1. Drag the
Get Rows action under
Excel Online to the canvas, place the pointer on the action, and then click
or double-click the action. The Get Rows window opens.
2. Edit the Label, if needed. By default, the label name is the same as the action name.
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 for which you want to get rows.
8. In the Sheet Name list, select or specify the name of the sheet for which you want to get rows.
9. In the Start field, enter the cell index from which you want to retrieve data.
10. In the End field, enter the cell index up to which you want to retrieve data.
11. Click Done.
Output schema