Skip to main content
Community site session details

Community site session details

Session Id : iLF4AbDJv5/QdQ99rNmmDP
Power Automate - Building Flows
Answered

Get dynamic table name in excel file using power automate using list rows present in a table action

Like (1) ShareShare
ReportReport
Posted on 31 Jul 2023 16:11:32 by 431

Hello Power Users,

 

I was building a flow where a user uploads an excel sheet inside a sharepoint document library and that should trigger flow to grab the file content and start the process. But I'm stuck at a point where I need to select a table and not sure how I make it dynamic. So that I don't need to get into the flow always and select the table name by myself. Below is the example for clear understanding on table name.

 

Referring the below action, each excel file may have different table name how can I dynamically let the flow read the table name?

 

I can also have all the excel sheets that are uploaded in the library to have a unique name, may be "FinalTable" if that helps my process to make it easy.

 

KrishR_1-1690819555585.png

Can anyone please suggest me or help me?

 

Thank you so much in advance!

 

 

  • shiva1969 Profile Picture
    9 on 15 Oct 2023 at 05:03:13
    Re: Get dynamic table name in excel file using power automate using list rows present in a table action

    Thank you very much. I am already a subscriber of your YT channel. Your YT videos are very useful. previously saw in YT similar concept using Excel Offset function in a channel called PragmaticWorks. Will try this out. So the get tables action will not work?

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 14 Oct 2023 at 16:53:04
    Re: Get dynamic table name in excel file using power automate using list rows present in a table action

    Hi @shiva1969 

     

    Try to watch one of my tutorial video.

     

    https://youtu.be/Q4Q_OWEa-Jw

     

    This might be helpful.

     

    Thanks

  • shiva1969 Profile Picture
    9 on 14 Oct 2023 at 13:36:03
    Re: Get dynamic table name in excel file using power automate using list rows present in a table action

    I am getting a null file (empty) when i use the Get tables action followed by List rows present in a table.  the excel table is successfactors report file without any table name inside it. my bot will access a new excel file every day when run. hence passing table names dynamically. what might be the issue here?

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 13 Oct 2023 at 09:10:12
    Re: Get dynamic table name in excel file using power automate using list rows present in a table action

    Hi,

     

    You can add all the properties dynamically including the name.

     

    Thanks

  • shiva1969 Profile Picture
    9 on 13 Oct 2023 at 07:09:37
    Re: Get dynamic table name in excel file using power automate using list rows present in a table action

    Hi @abm ,

     

    Is the excel file name also need to be dynamically added or the name has to be pre-selected? thanks

  • KrishR Profile Picture
    431 on 31 Jul 2023 at 17:46:42
    Re: Get dynamic table name in excel file using power automate using list rows present in a table action

    Hi @abm ,

     

    Thanks for the help. Solution you suggested is helpful for single table. 

  • Verified answer
    abm abm Profile Picture
    32,506 Most Valuable Professional on 31 Jul 2023 at 17:03:03
    Re: Get dynamic table name in excel file using power automate using list rows present in a table action

    Hi @KrishR 

     

    Add the below action step before the 'List rows present in a table'. Then map the table name dynamically in next step.

     

    image.png

     

    Assuming you only have one table in your excel worksheet.

     

    image.png

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1