Get sheets in Google Sheets Connector(Power Automate Cloud flows)
This action retrieves information on all sheets that exist in the specified file in Google Sheets.
How to use
Select the "Google Sheets" connector when adding steps to the flow.
Select the "Get sheets" from the "Action" menu.
Set Parameters.
| Parameter | Description |
|---|---|
| File | Specify the Google Sheets file to be retrieved. |
To use the information retrieved, "Apply to each" is also required.
Specify the dynamic content "Table List Value" in "Select an output from previous steps".
This will repeat the action put in place in "Apply to each" for the number of times the sheet exists.
Dynamic content "Table List Table Name" are available for the "Worksheet" option in the Add, Update, and Delete actions.
For those who want to learn Power Automate Cloud flow effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Cloud flow to streamline your workflow.