cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dybrienaldrin
New Member

Custom Value to select the first available table in List rows present in a Table

Hi,

 

How do i put custom value to select first available table in an .xlsx file?

sample flow looks like below:

 

Capture.PNG

 

Basically this flow sends an email from the content of the excel file presented in a table format(i used html format).
but the challenge i am experiencing is that the file gets updated or replaced everyday.

When the old file gets deleted, Table1 is changed into encrypted code(e.g. a774421ca811f26f246c9f63) and the flow fails.

because i think this was registered to previous Table1 data.
i have to reload again the file and select Table1 from the dropdown.

 

is there a way to automatically select first available table? there's only one table in the file so i think it can be forced like custom value expression.

How can I achieve that? 

1 REPLY 1
Jcook
MVP

Hello @Dybrienaldrin 

 

Unfortunately you have to use graph API to use dynamic table names or file names.

 

check out my blog. I cover this in very simple steps:

https://flowaltdelete.ca/2020/06/25/power-automate-excel-dynamic-file/


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,724)