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

Notifications

Announcements

Community site session details

Community site session details

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

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,335 Super User 2025 Season 2 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,335 Super User 2025 Season 2 on at
    HI @IvoF
     
    My apologies, I didnt realize it was for Desktop
     
  • Suggested answer
    eetuRobo Profile Picture
    4,204 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard