Get worksheets in Excel Connector(Power Automate Cloud flows)

Japanese version.

Get information on all worksheets existing in the book.

How to use

Select the "Excel Online (Business)" connector when adding steps to the flow.

Select the "Create worksheet" from the "Action" menu.

Set Parameters.



A list of OneDrive and SharePoints that can be connected will be displayed.

From among them, select the location where the target file is located.

Document Library

For OneDrive, select "OneDrive"; for SharePoint, select "Document".


Select a file.

It looks like a file path, but it is only a display and the content is an ID.

If you delete the specified file and then create a file with the same name,

it will be treated as a different file. (Reassignment is required.)

Dynamic contents

Place an "Apply to each" action.

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

This will cause the action placed in "Apply to each" to loop through the number of worksheets retrieved.

The action specified in "Apply to each" is repeated for each worksheet present in the file.



Worksheet ID, used in the "Worksheet" item of the action that manipulates the worksheet.


Worksheet Name.


The position of the worksheet with the left edge as 0.


Worksheet Status.

  • Visible
  • Hidden

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.


Excel Online (Business) Connector(Power Automate Cloud flows)