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.

Table 1. Excel get table rows action - Inputs
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.

Table 2. Excel get table rows action - Outputs
Parameters Description

Rows

The rows of data that are returned from the query.

RowCount

Number of rows returned.