Issues deleting sheets from excel workbook using office script

[KCarlton96]

I am using @DamoBird365's tutorial on how to separate an excel workbook into multiple files.

The initial file is a macro enabled worksheet stored in sharepoint.

When trying to run the delete script I am running into the following error: 

"We were unable to run the script. Please try again.\nRuntime error: Line 8: Cannot read property 'delete' of undefined

Due to the file being macro enables I had to add in a condition to remove certain sheets from the worksheet listing. Please see screen shots included:

Any advice or assistance would be highly appreciated.

[DamoBird365]

Hi @KCarlton96 

Might just be that you need to use Id rather than identifier for the office script (Delete Sheets via Script) file parameter.

Damien

[KCarlton96]

Hi @DamoBird365 ,

Thanks for your response. That produced the same error I mentioned above, so I'm still stuck unfortunately.

[DamoBird365]

Hi @KCarlton96 

Can you share a screenshot? And copy the output for the failing action.

Damien

[KCarlton96]

Hello @DamoBird365 ,

Sure. See below:

[DamoBird365 · Accepted solution]

@KCarlton96 

You’ve got extra [] around your array for sheets to delete. Check how you’ve built that.

damien

[KCarlton96]

Hi @DamoBird365,

Thank you so much. Power Automate put it in when I added the body of the filter array to that field.

Hope you and yours are safe and well