Excel get table rows
This activity retrieves the rows of data based on the filter provided. For Azure permissions, refer to the Microsoft Azure Integration section.
| Parameters | Description |
|---|---|
Connection |
Drop-down list of Graph connections. |
UserId |
The query will be run under the selected userID. The user should be the owner of the Excel file; otherwise, it will fail to update. |
Workbook |
Name of the xlsx file. |
Sheet |
The tab name on the worksheet to which the values must be modified. |
Table |
The defined name of the table. |
Filter |
Filter criteria to be applied for the query. Refer to the Graph API for information on the filter format. |
| Parameters | Description |
|---|---|
Rows |
The rows of data that are returned from the query. |
RowCount |
Number of rows returned. |
↑