Im looking for a way to take the most recent excel file in one drive and convert the worksheet to tables. Im having a hard time finding a way to choose the most recent file as the selections I see want to point to a specific file.
Under if yes branch, add a Compose to return the file name.
Screenshot for your reference.
To convert the worksheet to Excel table, we will have to use the Excel Online action Create table. However, dynamic content in File&Table inputs are not supported in Excel Online connector. So I am afraid that we could not achieve creating a table in this scenario.
There is a similar request on supporting dynamic content in File&Table inputs for connector Excel Online, please feel free to vote the idea at here:
How can I add "@equals(ticks(items('Apply_to_each_2')?['LastModified']), outputs('Compose'))" when it is asking for a value that is equal to (or some other condition) to some other value? I don't see a way of simply adding "@equals(ticks(items('Apply_to_each_2')?['LastModified']), outputs('Compose'))"