Excel Script - Change dynamic/unknown Table name

[SantaRow]

Hey,
I have an Excel file where I run some Office Script. Can't use VBA/macros, since MS Power Automate doesn't support Excel macro files. In the Excel file. I already have some scripts running to do the following:

• Create a new sheet every day
• Change the name of the new sheet to the current day (yyyy-mm-dd)
• Copy a table from a static sheet (another sheet I have in the file, that doesn't change) and inserting it into the newly created sheet

My flow in Power Automate then needs to be able to pull data from that newly created sheet and table. But to do that, it would need the name of the table. And that name changes at every new sheet and table created.
For that, thought it might work with having a script that changes the name of the newly created table to the current day, and with a letter first (since table names has to start with a letter). like; t31.05.2022.


My Power Automate flow is for having data pulled from the excel file and inserted into a MS List. But I can't pull the data from the excel file without knowing the name of the specific table.

 

[SantaRow]

EDIT:

Hey,
I have an Excel file where I run some Office Script. Can't use VBA/macros, since MS Power Automate doesn't support Excel macro files. In the Excel file. I already have some scripts running to do the following:

• Create a new sheet every day
  
  
  
  
• Change the name of the new sheet to the current day (yyyy-mm-dd)
  
  
• Copy a table from a static sheet (another sheet I have in the file, that doesn't change) and inserting it into the newly created sheet
  
  

My flow in Power Automate then needs to be able to pull data from that newly created sheet and table. But to do that, it would need the name of the table. And that name changes at every new sheet and table created.

For that, thought it might work with having a script that changes the name of the newly created table to the current day, and with a letter first (since table names has to start with a letter). like; t31.05.2022.
It could be incorporated into my "Copy a table..." script, but haven't had any success with renaming the table.
Does any have a good idea for dynamically renaming a table into a static letter + the current day?