You’re offline. This is a read only version of the page.
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.
Hi Geoff! Following your message, that very same day I posted on a thread dedicated to the type of action Im having the error with... Still no reply from Microsoft and Im in a very critical position here... My client has been for more than a week without the flows running! How can I have sb at Microsoft answer our dedicated thread?
Link: https://powerusers.microsoft.com/t5/General-Power-Automate/Unauthorized-Excel-List-Rows-in-a-Table-read-error/m-p/2776096#M170788
I'm running into what appears to be similar authorization issue for the last day or so. Has been working fine for months without any changes.
I'm trying to List Rows in a table, of an excel file I successfully created in SharePoint the step before and I'm getting a 401 Unauthorized issue. Person creating the file can open/read it via SharePoint interface but PowerAutomate is giving me a 401 when I try to read the table.
To verify, are you seeing issues with the Run Script action? I can't find your ids in our logs and I'm unaware of any serviceRequestId property. Did you get the clientRequestId from the output like what's underlined in this screenshot?
@GeoffRen sure!
clientRequestId: d661be94-d7d3-49ce-9325-7406c913553c
serviceRequestId: 65c0c26c-d2f9-401a-bf93-7587cc7d2d53
"Unauthorized"
Thanks
@Camila2 @lucinaperich @ACDBT I do not see much evidence of the outage on Thursday/Friday appearing since then. Can you post your clientRequestIds along with the error message? Otherwise we have no way of looking into your issue.
@mmccollom It looks like there was an outage on Thursday/Friday. Looking at your logs it seems that your Flow is working again.
Geoff, good morning. There are several fluxes depending on this error on the company I work for. All of them are stopped. Are there any updates on its resolution? Estimated resolution date-time? Thanks.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (