You’re offline. This is a read only version of the page.
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!
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?
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?
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.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
