
Announcements
Hello,
I am new to Power Automate and creating my first flow.
I am trying to use multiple tabs in one Excel to get data that I want to use to enter into another excel workbook.
How can I achieve this without increasing the running time of the flows?
Can anybody please help?
If you are using Power Automate Desktop to read data from Excel, it reads data only from active sheet.
So first you should Set worksheet you want as active
To set it as active you should specify it by index (starting from 1), or by sheet name.
If you do not know names, you can also Get all worksheets beforehand.
Hope it helps.