Dynamically Get tables Data from multiple Excel files.

[bhavinrshah]

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. 

[yashag2255]

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!

[bhavinrshah]

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.