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

(1) Share

Report

Posted on by KrishR

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.

Can anyone please suggest me or help me?

Thank you so much in advance!

Categories:

Building flows

I have the same question (1)

All responses (7)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @KrishR

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

Assuming you only have one table in your excel worksheet.

Was this reply helpful? Yes No
KrishR 431 on at

Like (1)

Report

Hi @abm ,

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

Was this reply helpful? Yes No
shiva1969 9 on at

Like (0)

Report

Hi @abm ,

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi,

You can add all the properties dynamically including the name.

Thanks

Was this reply helpful? Yes No
shiva1969 9 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @shiva1969

Try to watch one of my tutorial video.

https://youtu.be/Q4Q_OWEa-Jw

This might be helpful.

Thanks

Was this reply helpful? Yes No
shiva1969 9 on at

Like (0)

Report

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?

Was this reply helpful? Yes No