Answered

Office Script not found - but appears in drop down

(0) Share

Report

Posted on by jmwillithree

I have a simple office script that deletes the first two rows of an Excel spreadsheet. Here is the code:

function main(workbook: ExcelScript.Workbook) {
  let selectedSheet = workbook.getActiveWorksheet();
  selectedSheet.getRange("1:2").delete(ExcelScript.DeleteShiftDirection.up);
}
 
I have the Office script in a SharePoint folder. The action recognizes the folder I am pulling the .ost file from in the drop-down:

For some reason, every time I run automation I receive the following error:

Action 'Run_script_from_SharePoint_library' failed: Script not found. It may have been unshared or deleted. clientRequestId: 240f072e-cd25-4be2-b17b-d5d7a7dcffbc

Any suggestions?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Michael E. Gernaey on at

Like (0)

Report

Hi @jmwillithree

That script is called Main not DeleteTop28Rows or whatever.

Can you share where its got the name

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
Verified answer

mosessouth 13 on at

Like (2)

Report

Hi @jmwillithree

I had the same situation yesterday. In my case, I got the same error message related to the script which can't be found.

But the real error was the Workbook. I had an error in the path for the selected workbook, which resulted in the situation that the script could not be executed. Once I corrected the path, everything was running smoothly.

Give it a try and validate your entries for the wokrbook.

Cheers

Was this reply helpful? Yes No
jmwillithree 6 on at

Like (0)

Report

Thank you @mosessouth.

In my case, the path for the selected workbook was in a private channel, which I was not able to access. I copied the private channel to a public one, after which I was able to access the selected workbook. Thanks again.

Was this reply helpful? Yes No