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.
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.
table2.getColumn("Responder's Email").getRangeBetweenHeaderAndTotal().getRow(1).copyFrom(satCube.getRange("C3:W100"), ExcelScript.RangeCopyType.values, false, false);