Cannot run Excel script from power automate but works from Excel

Question

Hi,

I have a script that runs fine when called directly from Excel but encounters the error message below when triggered by power automate. Line 14 selects a range and copy-pastes onto itself to remove formulae and keep values only.

Error Message:
We were unable to run the script. Please try again.
Office JS error: Line 14: Range copyFrom: There was an internal error while processing the request.
client
RequestId: 63d0c6ef-289b-4936-acb7-fb4299a77a65

Line 14:
table2.getColumn("Responder's Email").getRangeBetweenHeaderAndTotal().getRow(1).copyFrom(satCube.getRange("C3:W100"), ExcelScript.RangeCopyType.values, false, false);

Answer 1

Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to upvote and Accept as answer if the reply is helpful--