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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get rows from multiple...
Power Automate
Unanswered

Get rows from multiple excel tables & insert into new excel table

(0) ShareShare
ReportReport
Posted on by 130

Hi all,

 

I have an excel file with multiple tables with about 3000 rows altogether.

I want to add all of them into a new excel table.

 

I tried List rows present in a table action for each of the tables & then having apply to each action for inserting into new table. But with the no. of rows which are more than 3000, it takes quite a bit of time.

 

Is there any other way to reduce the time taken to execute the flow.

 

Any pointers will be really helpful.

 

Thanks.

Categories:
I have the same question (0)
  • tom_riha Profile Picture
    10,185 Most Valuable Professional on at
    Re: Get rows from multiple excel tables & insert into new excel table

    Hello @TheOpeningBat ,

    I don't think you can optimize that, from your description it's as simple as it can be, List rows -> Add rows. And since you're updating them all into a single Excel file, you can't run it in parallel.

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard