cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dual Super User
Dual Super User

Create Table in Excel with two Worksheets

So, I have successfully created a Table in an Excel with one Worksheet by using the "Create table" action from Excel Online (Business) connector, targeting as "Table range" the following:

A1:E1

Now I manually add a second Worksheet (named Hoja2) and modify the Flow, so in "Create table" I target as "Table range" the following:

Hoja2!A1:E1

Flow executiong fails.


CreateTable2worksheets.pngMy Flow is extremely simple, please find enclosed a screenshot

Is this use case (i.e. targeting an specific worksheet) currently supported?

Thank you in advance!

 





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





4 REPLIES 4
lreinhard7
Level 8

Re: Create Table in Excel with two Worksheets

Hi, 

Have you found a solution for this issue?

Best regards, 

Ludwig

Community Support Team
Community Support Team

Re: Create Table in Excel with two Worksheets

Hi @efialttes,

 

I assume that Hoja2 is the Sheet name. let’s say that the table that you are going to create has the same name with the worksheet. In the Table name field, please enter the worksheet name and try again.

I have made the following test. There are several sheets in the list, now I am going to format Sheet5 as a table. In the Table name field, enter the sheet name and it just works fine.

1.PNG 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dual Super User
Dual Super User

Re: Create Table in Excel with two Worksheets

@v-yamao-msft

Thanks for the tip!

Not sure I understood you. I have followed your advice and verified that:

 

-if I add a new worksheet manually, leave as the first worksheet on the right, and then execute the flow, the table is created on the first worksheet on the right, no matter the name assigned to the Table. So if I create a new Worksheet named Hoja3, leave it on the right; then execute the flow attempting to create Table named "Hoja5", the Table is created on Worksheet named Hoja3.

 

-if I add two new worksheets manually (Hoja4 and Hoja5, where Hoja5 is the first worksheet on the right), and then execute the flow targeting a new table name, the new table is not created on the first worksheet on the right (Hoja5) but on Hoja4, no matter the name assigned to it.

 

-If I execute the flow again, targeting a new table name, expecting new Table would be created on Hoja5, however flow execution fails. If I execute the flow again changing the range to avoid overlappings, the new Table is created on Hoja4.

 

 Am I missing something? If not, current implementation looks a bit weird

Thanks again for your help!

 

 

 

 

 

 





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





originaldoubleg
Level: Powered On

Re: Create Table in Excel with two Worksheets

Hi everyone.

I've been trying to create tables in a particular worksheet for some time now.

I don't know if it's relevant, but I'm using the Excel online (Enterprise, not onedrive) - Create table.

My personal notes on the matter:

- It seems that the table is created in the Active Worksheet (dependant on which sheet was active the last time the excel file was saved)

- It doesn't matter the name specified for the table (at least in my case)

 

- I got it working by specifying the Worksheet name in the table range, similarly to what was initially stated in this post.

So in the table range field you would use (very important to be precise with ' and ! symbols):

='WORKSHEET_NAME'!AX:BY

WORKSHEET_NAME = Name of the desired worksheet as seen in excel

AX:BY = Range desired for the table, A,B = Columns, X,Y = Rows

 

Example:

='Hoja2'!A1:E1

 

Hope this helps

origdgg

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 356 members 6,185 guests
Please welcome our newest community members: