Execute Excel Script - Unauthorized

[gersontun]

Hello,

In order to accomplish a couple of things I cannot do directly in Power Automate, I started executing regular expressions using the "Run Excel Script" activity. It had been working fine, but on Monday it started to fail. This execution of the Excel script is inside of an "Apply to each" activity.

What I've done so far to try to fix it:

1. Removed default concurrency to the trigger, so I make sure this process is not executing multiple times in parallel.

2. Removed default concurrency of the "Apply to each" activity, to make sure the process is not trying to execute the script multiple times at the same time.

3. On the Run Excel Script, I've played with the Retry Policy, with no luck.

The issue persists.

The weirdest thing is that this issue might or might not happen on the same execution and within the apply to each.

The Error:

In the apply to each activity:

Execution number 5 failed, number 6 succeeded and number 8 failed again.. and so on.

Failed:

Succeeded:

Failed:

This is the configuration of the RunScriptPageNumber:

Hope anyone here can help!

UPDATE: Now that I am editing the flow, the issue started appearing on the top like this:

It seems like the file was not available or I didn't have permissions on the file.

The excel file is saved and closed, no one else is using it.

[tomkeysers]

Same issue here since today... Western Europe

[branut]

Hi, people! Same issue today, Brazil, SP

[LCarmona]

I have the same error today. In the morning it worked and after noon it didn't anymore. Western Europe

[GeoffRen]

Hi everyone,

Sorry to hear you're experiencing this problem. It might be an issue on our side and we have been actively investigating the root cause. Will let you know once it's been addressed. Thanks for your patience!

Geoff

[joellasotaPF]

Same issue in UK since early afternoon.

Scripts fail to execute in some of our Power Platform environments.

Excel script editor is displaying authorization errors as well, when trying to view/edit script.

[GeoffRen]

The issue should be mitigated, there was an issue with some certificate. Thanks for your patience!

[Koczek]

Just checked and it is working as expected. Thanks

[alegson]

Issue appears to have been fixed, thanks.

[LCarmona]

The issue seems to be resolved, but now when running the flow the following error appears. Cant find the connection. I have created new connections and have the same result.

[drakarin]

I am still getting 401 errors. East US GCC.

It fails regardless if I do a test run or let the scheduled trigger run it.

Thank you!

[GeoffRen]

This seems like the same issue with the other region. We are actively investigating the root cause. Will let you know once it's been addressed. Thanks for your patience!

[GeoffRen]

The issue should be mitigated. Thanks again for your patience!

[drakarin]

I concur.  Thank you for the update!

[LearningJonas]

I had no problem for 3 weeks and then suddenly it stopped working. I tried to reconnect my account and used 'Run script' instead of 'Run script from SharePoint library' but it still does not work. (I am still able to edit the excel file by hand)

The error message:
{
"message": "We were unable to run the script. Please try again.\nYou do not have permission to view this directory or page.\r\nclientRequestId: [confidential]",
"logs": null
}

The problem went away as suddenly as it appeared. Without me changing the flow. Now it has worked 10 times in a row.

[Skobu]

Same here... It worked for 15 files, error in the last 4. Unfortunately things are so unstable that we are checking other possibilities to change our business to

[Linda777]

Hello Yutao,

The flow was working. but today failed with "We were unable to run the script. Please try again.
You do not have permission to view this directory or page.". even if I created new connections, still got this error message.
please help.

thanks!

[DesarrollosEdu]

Hello, I'm experiencing the exact same 401 issue in Prod since yesterday.

Is there any permanent way to avoid this from happening?

[GeoffRen]

Can you post your clientRequestId?

[Linda777]

I set up the property on the excel file, then works

[Linda777]