Excel Create table Wildcard

[mspowley]

I have an Excel file that gets passed to us that ends up having multiple tabs. I want to create a table on a specific tab of the multiple.

I understand how to do this. 

The one I am looking to create a table one where the name is not always the same. The tab name always starts with "Load" but gets created with a code after that is always changing. Is there a way I can use a wildcard in the table range to create a table on the first cell/tab range starting with "Load?" 

[v-xiaochen-msft]

Hi @mspowley ,

Firstly, do you want to use flow to create a wooksheet and a table in excel?

If so, you could try this:

Besides, what is the name suffix of worksheet? Could you give some examples?

If you already have these worksheets e.g. Load 01, Load 02, do you want to create a 'Load 03' worksheet?

Best Regards,

Wearsky

[mspowley]

Thanks @v-xiaochen-msft for your reply. An interesting solution above but not quite the problem I am having. The worksheets are already existing on the inbound files.

Example of workbook with four worksheets: 

Tab1name

Tab2name

Tab3name

Loadtab123

The worksheet above starting with Load is the one I need to create a table on. The numbers on the end can change, however it always starts with "Loadtab."