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

Like (1) Share

Report

Posted on 31 Jul 2023 16:11:32 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!

All responses (7)

Answers (1)

Verified answer

abm abm 32,506 Most Valuable Professional on 31 Jul 2023 at 17:03:03

Like (1)

Report

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.

Assuming you only have one table in your excel worksheet.