cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kenneth
Frequent Visitor

Run Script Failing Error 504

Hello I have created a Script which when run directly from the Workbooks, work flawlessly, but for a particular workbook on flow it is giving me the following error.

 

 
  "message""We were unable to run the script. Please try again.\nOffice JS error: Line 13: Worksheet getCell: The request failed with status code of 504, error code UnknownError and the following error message: \r\nclientRequestId: ",
  "logs": [
    "[2021-03-22T14:59:33.6140Z] Last Column Index: 33"
  ]
 
 
This is Line 13:  selectedSheet.getCell(0,LastColumnIndex+1).setValue("Base Agreement");
 
Before Line 13 there is another getCell and it work okay it is actually providing the column index on the Logs.  Additionally as mentioned above, it work on flow for other workbooks but not for this particular one.
 
Update: now it is failing randomly, but only on the lines that contains getCell.
 
Thanks!
0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,936)