web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Error Message: We were...

Power Automate

Unanswered

Error Message: We were unable to run the script

(0) Share

Report

Report

Posted on by RichardC

2

Hi,

I am attempting to run a PowerAutomate Flow and got the following error:

"message": "We were unable to run the script. Please try again.\nRuntime error: Line 8: Cannot read properties of undefined (reading 'delete')\r\nclientRequestId: 027b7552-7d6f-47cd-82ec-5f01590efbe4"

Below is the code for the script:

function main(workbook: ExcelScript.Workbook,

SheetsToDelete: Array<string> = [],

)

{

// for each of the worksheets in the array

for (let worksheet of SheetsToDelete) {

//delete the worksheet

workbook.getWorksheet (worksheet).delete();

}

//get current worksheets in workbook

let sheets = workbook.getWorksheets();

let names = sheets.map((sheet) => sheet.getName());

//return the number of sheets left

return(names.length)

}

Any thoughts as to why this is not functioning?

Thanks,

Rich

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @RichardC ,

Pease try

let sheet = workbook.getWorksheet (worksheet)[0]; sheet.delete();

Best Regards,
Bof

Was this reply helpful? Yes No
RichardC 2 on at

Like (0)

Report
Copy link

Link copied!
Hi, Thanks Bof,

I got the following error:
See line 8, column 11: Office Scripts cannot infer the data type of this variable. Please declare a type for the variable.

Was this reply helpful? Yes No

Join the conversation