Unanswered

We were unable to run the script. Please try again.

(0) Share

Report

Posted on by David999

I'm currently struggling with the below error code in Power Automate.

We were unable to run the script. Please try again.
Office JS error: Line 8: {"message":"code":"InvalidArgument","type":"Worksheet","method":"getRange","line":8}
clientRequestId: 53f4345c-6629-4eef-a2aa-76fc5aa0b748

I made a flow that automatically filled an Excel sheet in a shared folder based on the reply of a survey in Forms.

To fill the sheet, I use a script file and it's like below.

I tried to fix but I still don't know what's wrong with this code.

function main(

workbook: ExcelScript.Workbook,

sheetName: string,

cellAddress: string,

updateValue: string

) {

let sheet = workbook.getWorksheet(sheetName);

let updateCell = sheet.getRange(cellAddress).setValue(updateValue);

let cellValue = sheet.getRange(cellAddress).getValue();

return cellValue;

}

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @David999

Your office script seems has no error. Your error code means that you pass the invalid cellAddress in the getRange() function.

Can you check what the value you pass to the Office script in the flow?

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
David999 5 on at

Like (0)

Report

Thank you for your reply. I double-checked what values are delivered to each cell but there's nothing strange. I think it could be a kind of temporary bug(?) since this error doesn't always happen.

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (1)

Report

Hi , @David999

If you can run it successfully, but the error has occurred a few times, then it is indeed possible that it is a temporary error, because your code really doesn't look like a problem, if the pass value doesn't change.

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No