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);