question

MasseOlivier-0573 avatar image
0 Votes"
MasseOlivier-0573 asked DSPatrick answered

Cannot run Excel script from power automate but works from Excel

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

not-supported
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I have the exact same issue with a Clear Range script

0 Votes 0 ·

I have the exact same issue with a Clear Range script

0 Votes 0 ·

has anyone found the solution yet?
I have a script and powerautomate that worked till Dec2021. Starting Jan2022, I started getting this error.

0 Votes 0 ·

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.