Power Automate Run Excel Script task failed with error: "Range setValue: Timeout"

[Rick-Maxinsheng]

Article URL

https://github.com/OfficeDev/office-scripts-docs/blob/main/docs/resources/samples/combine-worksheets-into-single-workbook.md

Issue

I compose a simple Power Automate Flow for combining two Excel Workbooks by above two Office Scripts. The first script worked well to read the source file worksheet data, but the second one popped up an error when adding data into the destination workbook. The error is about the "range.setValues(value.data)" and feedback a Timeout. Some background information is that the source worksheet intended to be added contains more than 8000 rows. Please see the attached picture for detail.

[AlexJerabek]

Hi @Rick-Maxinsheng,

I'm sorry to hear you're have trouble creating this flow. You have correctly identified the cause is that the workbook is large. Power Automate has a 120-second timeout for this operation. The solution involves adding a loop to your flow that calls the scripts multiple times. I'm going to see if there's an existing example to share with you.

[Rick-Maxinsheng]

Thank you very much, Alex.
I will update my testing status once you have found the example

[AlexJerabek]

Hi @Rick-Maxinsheng,

Just a quick update. It doesn't look like there's anything helpful to share, so I'm creating a new sample to illustrate this pattern. I should have something for you tomorrow.

[AlexJerabek]

Hi @Rick-Maxinsheng,

I created PR #583 to help demonstrate how to avoid timeouts in Power Automate when working with large datasets. Does this help illustrate how to address the problem you're having?

[Rick-Maxinsheng]

Thank you very much, Alex. That does shed light on my way.