Get rows in Google Sheets Connector(Power Automate Cloud flows)

10/01/2023

Japanese version.

This action retrieves multiple rows of data by specifying the file, sheet, and number of rows to be retrieved.

How to use

The target Google Sheets file must have an header line at the top.

Select the "Google Sheets" connector when adding steps to the flow.

Select the "Get rows" from the "Action" menu.

Set Parameters.

ParameterDescription
FileRequired field.
Specify the Google Sheets file for data acquisition.
WorksheetRequired field.
Specify the Google Sheets worksheet from which to retrieve data.
Top CountSpecifies the maximum number of items to be retrieved. If omitted, it is 256.
The first line (item line) is not included.
Skip CountSpecifies the number of cases not to be read (number of cases from the top). If omitted, the number is 0.
The first line (item line) is not included.

To use the rows you get, you also need "Apply to each".

Specify a "Records value" for the dynamic content in "Select an output from previous steps".

This will cause the action specified in "Apply to each" to be repeated.
(Each iteration will target a different row).

Google Sheets data is available as dynamic content for item names in "Apply to each".

Note that the row retrieved by this action will have the column "__PowerAppsId__" added to the far right.

This column is an ID set for each row to be handled by PowerAutomate in the column that is forced to be added to the right side if it does not exist in the sheet.
(Once deleted, a different ID will be assigned.)

This field is required when specifying row ID in "Get row", "Delete row", and "Update row".

If empty when executing "Insert row" or "Get rows", a random string will automatically be set.

You can also create your own "__PowerAppsId__" column and set any ID.

When dynamic content is specified for a file or sheet

If dynamic content is specified for a file or sheet, it will not appear in the dynamic content.

If you want to use it, use an expression. (Change the red text accordingly.)

items('Apply to each’s Action name')?['Field name']

If an action or field name containsField namehe spaces must be changed to "_".

---

Links

Google Sheets Connector(Power Automate Cloud flows)