cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Dual Super User II
Dual Super User II

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,498)