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

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!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



7 REPLIES 7
Highlighted

Re: Create Table in Excel with two Worksheets

Hi, 

Have you found a solution for this issue?

Best regards, 

Ludwig

Highlighted
Community Support
Community Support

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.
Highlighted
Dual Super User III
Dual Super User III

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!

 

 

 

 

 

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Regular Visitor

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

Highlighted
Helper III
Helper III

Re: Create Table in Excel with two Worksheets

Hi,

I have a problem where.

I have a document that I receive per email, and I had to archive the attachment in one folder. However, I have to take the information from one worksheet to another Excel. the problem is, the attach do not have any table created and I have tried several approaches unsuccessful.

 

this is base on the last comment.

1.png

2.png

Could you please help me?

thanks

Highlighted
Dual Super User III
Dual Super User III

Re: Create Table in Excel with two Worksheets

@Kamacete

If your challenge is to build an excel table on an excel file which originally didn't have, this article covers the topic

https://sharepains.com/2018/10/17/microsoft-flow-read-large-excel-files-within-seconds-without-creat...

 

If you face problems when implementing it, my suggestion is to open a new thread. Most superusers tend to pay attention to new unanswered topics, and this seems to have several replies already

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper III
Helper III

Re: Create Table in Excel with two Worksheets

Hi,

I didn't solve this problem until now.

there is no other way?

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (9,705)