Create Table in an existing Excel Online

[Kamacete]

Hi,

Every day I received an email with attach (Excel with several worksheets). I have to save the attach in SharePoint and extract the information existing in one worksheet to another excel.

Problem:

The main problem is when I tried to create a table in the excel, in a specific worksheet the flow don't do nothing.

Result:

FLOW:

Could you please help?

thank you

[ChristianAbata]

hi @Kamacete  mmm I'm not excel expert but the range you have says 2003!A1:b1, and for me a valid range is just A1:B1

[Kamacete]

@ChristianAbata thank you for your answer.

But, how can I identify one worksheet from others?
I have several worksheets in the same excel. 

[ChristianAbata]

oh @Kamacete  is a worksheet is ok, mmm just to ask my friend your table name is called Source2 right?

[efialttes]

@Kamacete 

With the example I just implemented, it is working fine.

THe potential differences I find are:

1.-It took to your flow 5 secs to read your Worksheets, in my case the excel was simple, it just took 1 sec. MAybe you should add a delay action block, let's say 10 secs in between, just in case.

2.- My excel file has a single Worksheet

3.- I defined two rows, you defined just once

4.- I use capital letters to define range

5.- I didn't add a semicolon at the end of the Column List

Hope this helps

[efialttes]

Hi again

Differences #3, #4 #5 doesn't seem to influence the result

Hope this helps

[efialttes]

Hi again

I just added manually a second sheet to my excel file, now my flow creates the table in 'Hoja1' instead of 'Hoja2'.

So either the error you got is a random one; or the delay is needed for bigger files than mine, or... how many excel sheets do you currently have in your excel file?

Thanx!

[ChristianAbata]

@efialttes  I did the same test for 5 sheets and my flows gets a delay @Kamacete  I think this is an normally performance flow.

[Kamacete]

I have 4 worksheets, but maybe I see this from a wrong perspective.

Is there any way to get the information from the worksheet without a table and insert the data into an existing excel, with just a worksheet and table?

if yes, this solve my problem

[ChristianAbata]

@Kamacete  far as I know unfortunally not my friend just all the worksheets all the content 

[Kamacete]

this is the result

could you please share the flow that you do with me?