cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yoshimitsu411
New Member

FLOW to Create a Table in an Excel Worksheet with 2000 plus rows

Hello

 

I'm trying to create a Table in a worksheet of an Excel document in my SharePoint Library using FLOW. It works for upto 1000 rows but anything after that it will error - Workbook not found. There are approximately 2500 rows which increases daily.

 

FlowToCreateATable.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Is there a way to do this?

 

Thank you.

 

Yoshi

6 REPLIES 6
v-lin-msft
Post Prodigy
Post Prodigy

Hi @Yoshimitsu411,

 

I have test on my side and it runs successfully. Firstly, if you have no worksheet or want to create a new worksheet, you need create a worksheet, then put the worksheet name into the action create table without quotes.Annotation 2019-06-25 140846.png

 

Annotation 2019-06-25 140922.png

I hope it will help you. If you have any questions, please contact us.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your response and assistance.

 

Unfortunately I am seeing an error.

 

I am updating a master file and then creating tables in the master file worksheets. Worksheet names have spaces and I cannot change this as it is generated by another system daily.

 

 

FlowToCreateATableErroring.PNG

 

FlowToCreateATableErroring1.PNG

 

 

Error I am seeing - Workbook not found

 

 

FlowToCreateATableErroring2.PNG

 

Hi @Yoshimitsu411,

 

Currently, there is no action could create a table after you created or update an excel file.

Because in this case, excel files cannot be selected in a flow run, you must select a fixed excel file to create worksheets and tables.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

The master file is the fixed file.

Hi @Yoshimitsu411,

Annotation 2019-06-26 095649.png

Could you have a try to remove the quotes of the worksheet name?

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Still doesn't work.

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (51,445)