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.