Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Dynamically Get tables Data from multiple Excel files.



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.



Dynamically tables Data getting an issue. 



Dual Super User III
Dual Super User III

Re: Dynamically Get tables Data from multiple Excel files.

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!

Helper I
Helper I

Re: Dynamically Get tables Data from multiple Excel files.

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


Super User Program Update

Three Super User rank tiers have been launched!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (7,966)