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.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1