Office Script failed

[Rupilisko]

Hi,

Trying the new version where the table selection is replaced with a script for Excel Connection. Had to manually fix the connections but when trying to save the model, I receive this error message (Several times as you can see in the attachment):

Flow save failed with code 'MultipleErrorsOccurred' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScript' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Script not found. It may have been unshared or deleted.\r\nclientRequestId: f4e01800-20c0-4828-8a92-66187042e504", "error": { "message": "Script not found. It may have been unshared or deleted." }, "source": "excelonline-we.azconn-we-002.p.azurewebsites.net" };

Looks like it's unable to find the script. Could this be just a block by corporate firewall to "excelonline-we.azconn-we-002.p.azurewebsites.net"? I would love to test with the older version used in a video of yours where you used table instead of script to see if this is not an issue with the script.

Thanks

[ben-howard]

I guess the 1st thing to do is check if you can create your own office scripts, that would point you to the issue. Re the older version, you mean the older version of the script? If so, you can re-create it from the pdf included in the repository (as I have not updated it) or use the solution attached here.
ExportPlannertaskstoExcel_220321.zip

[MrHofflich]

Hello Ben, I am facing the same issue. Where would I check if I can create my own office scripts?

[ben-howard]

Hi @MrHofflich - Please review the folloiwng URL - https://letmegooglethat.com/?q=how+can+I+test+Office+Scripts+in+Excel+365

[Rupilisko]

Hi,

Just to note, I recreated some of those flows without the scripts and it works nicely. Really nice solution. And yes I was not able to create own office scripts.

Kari