web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Looking to use multipl...
Power Automate
Unanswered

Looking to use multiple tabs of an excel sheet in one flow as the source. Is it possible?? Will it increase the time of the running of the flow

(0) ShareShare
ReportReport
Posted on by 46

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?

 

Categories:
I have the same question (0)
  • kseniia-p Profile Picture
    10 on at

    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.

    kseniiap_0-1624542114601.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard