BadGateway - Running a flow to split excel workbook into multiple worksheets

(0) Share

Report

Posted on by EvanE86

138

Hiya,

@DamoBird365 I am trying to follow your guide on running the Split Workbook into Multiple Worksheets Based on Key Column however encountering a number of issues:

1) I saw your video where you ran the script against a large spreadsheet and seemed to work within a minute or so however I tried to run it on a spreadsheet with 13k rows and it takes over 7 minutes and I get 'BadGateway' along with several re attempts.

2) Here is a screenshot of the error which appears to be down to the flow creating a table, then re attempting and failing because the table is already there.

My question is why does this happen and how is it not able to do 13k rows unlike the video.

Kind REgards

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report

Are you able to provide a link to Damo's video, and also a copy of the Office Script?

The error isn't because you're trying to create a table with the same name, but rather because it's trying to create a table over the top of another table which would indicate that there are two tables within the same worksheet.

Was this reply helpful? Yes No
EvanE86 138 on at

Like (0)

Report

Hiya,

This is the video I was following:

(1) Effortlessly Split Excel Workbooks: Power Automate & Excel Office Scripts Solution - YouTube

and here is a link to the scripts used in both the video and mine:

Split Workbook into Multiple Worksheets Based on Key Column

Split a Workbook into Multiple Worksheets - DamoBird365

The excel spreadsheet I have has 13k rows, with about 8 columns, I'm using column 2, unitRef, as the subject column to split on but when I re run it I noticed, prior to it failing, It retries several times so i suspect it runs, inserts a table then re attempts and fails as it sees the table exsists however in the example video Damien runs this on a spreadsheet with 100k rows so not sure why his runs in about a minute or two and mine fails.

Kind Regards

Was this reply helpful? Yes No