Showing results for 
Search instead for 
Did you mean: 
New Member

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



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

sample flow looks like below:




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? 


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:

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

Helpful resources

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)