cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhavinrshah
Helper I
Helper I

Dynamically Get tables Data from multiple Excel files.

Hello,

 

I have 4 Excel sheets in oneDrive Folder.

 

I want to collect all Table Data from multiple sheets and create 1 more sheet with the same data.

 

Note:

Dynamically tables Data getting an issue. 

 

 

2 REPLIES 2

Hi @bhavinrshah 

 

Currently a limitation with the excel connector is that you cannot dynamically refer to a file/table to get the data directly on the action. Now, as you have mentioned that you have 4 excel sheets, to get the data all these should be appropriately formatted as tables. You can select the table then in the List rows present in a table action. 

 

Now, to create one table with all the data in these tables, you can add individual List rows in a table action for each sheet's tables and add rows to a new table based on the returned rows. (makes sense?)

 

For this, you will also have to create the blank final table in the excel sheet. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hello @yashag2255 

 

I have done it in a different manner as below.

 

Step 1: Create/Manage an existing sheet with a TABLE structure.

Step 2: Choose 'List rows present in a Sheet' - Choose a specific sheet.

Step 3: If you choose the right sheet then Table will be populated automatically.

Step 4: you need to start your looping on that specific column.

Step 5: 'Apply Each' you need to add 'Add a row into table'

Step 6: Run/Trigger your Flow.

Step 7: Once done you can see your column will be copied and paste in a new sheet.

 

Let me know if you want any further information in this regards.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,794)