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?"
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
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."
User | Count |
---|---|
100 | |
37 | |
27 | |
23 | |
16 |
User | Count |
---|---|
131 | |
52 | |
48 | |
36 | |
24 |