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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract tables and dat...
Power Automate
Suggested Answer

Extract tables and data from Excel worksheet

(1) ShareShare
ReportReport
Posted on by 47
Hello, I need to extract multiple tables and its data from an excel worksheet, I have 4 tables and would like to extract them all, i dont know if its possible to retrieve its data and the table name from excel. 
Does anybody knows if its possible?
Those are my tables, id like to find a way to get the table and store it into a datable, there must be a way... right?
Thanks!
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,978 Moderator on at
    Hi @IvoF
     
    Essentially you would do something like this and please... you asked a question hehe I will answer. if you want help building it you will have to open another question for that purpose.
     
    Assuming those are Tables
     
    You would create a Flow (Manual or Automated or Scheduled)
     
    1. Add Trigger
    2. for each Table do the following
    List Rows in a Table Action for Excel
    Add an Apply to each Action
    --Inside this Loop which will loop through the Table you named in the previous step,
    ----Add the action to Add it to SQL, or SharePoint, Or Dataverse, accessing the data in the Table using the item()?['FieldName'] expression that works inside the Apply to each (where it loops through each row), or you can use the Dynamic Property Field Name either or
     
    If you wanted data from all 4 or from like 2 or 3 of them to be added together to create a single row in a Table/List etc you would still have to loop through them all, but you would start with the first... then inside ITS apply to each, you would do List Rows in a table, with a Filter on it using data from Table 1, and so on for each table you wanted data from. Then add it to your database etc.
     
    So the answer is yes, if those are tables, its easy enough to do, but can get complicated if you expect to join Table data to create single rows etc.
     
    As this answers the question if you could Mark as such please and make a like. 
     
    Feel free to ask more questions here but once you start building please start a new thread.
     
    Cheers
     
  • IvoF Profile Picture
    47 on at
    thanks for the reply!! But are we talking of power automate desktop or cloud??
    I want to use it on a desktop excel file
  • Michael E. Gernaey Profile Picture
    53,978 Moderator on at
    HI @IvoF
     
    My apologies, I didnt realize it was for Desktop
     
  • Suggested answer
    eetuRobo Profile Picture
    4,522 Super User 2026 Season 1 on at
    Do you need the them to be in same table so merged together or 4 different table variables? If you want like this:



    Read all cell values and then loop the columns and remove all the ones that start with "Column" so they are the ones that are not in your table. 



    If you want them to be 4 different data tables then are those tables always at the same position? Then you could use Read from Excel Worksheet -action 4 times to read all the tables one by one.

    If you have premium license you could upload it to OneDrive and use "Get tables" -action and then "List rows present in a table" -action to each table

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 959

#2
Valantis Profile Picture

Valantis 872

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard