How to Get All Worksheets from an Excel XLSX File in Power Automate 

In this video, you will learn how to retrieve the worksheets from any Excel file using the Cloudmersive Document Conversion API Connector in Power Automate. This action returns an object containing the individual paths to all worksheets within an Excel file, along with the name of each worksheet.
To use this connector for free, you'll need to provide a free-tier Cloudmersive API key during the connector authentication step. You can get one by registering a free account on the Cloudmersive website (this allows a limit of up to 800 API calls per month with no additional commitment).