Unanswered

« 401 » error - PowerAutomate Excel Online (Onedrive)

(2) Share

Report

Posted on by CU03041438-0

I have flow to add or read some lines in an Excel spreadsheet store on Onedrive (personnal).

All flows were operating very well for year but everything stopped working couple of month ago with access error : « 401 », message : « The request is unauthorized by Graph API. Error code is 'FileOpenUserUnauthorized'. Error message is 'You do not have permissions to open this file in the browser.'. clientRequestId: xxx

Obviously I have check credentials for my connections, deleted & rebuilt those connections... flows are working perfect when I ask to send again the flow from the historical but the day after "401" is back !!!

I have check my excel spreadsheet : no protection, no password... nothing that should prevent flows to access this file?!?
I have deleted my flows & rebuilt new ones from scratch... without success 🤬

May you halp me to fix that?

Categories:

Using connectors

I have the same question (0)

All responses (8)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU03041438-0

please share your flow, we need to see that including your inputs and outputs.

If you can share both the flow build with details so we can review it as well as a run.

I am going to see if I can reproduce this.

I assume this is Power Automate Cloud , not PAD?

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Since 401 is an authorization error and you seem to be using the Graph API did you try accessing the files using the Graph Explorer? Have you considered using a SharePoint library or switching to OneDrive for business instead of your personal OneDrive?

Was this reply helpful? Yes No
CU03041438-0 12 on at

Like (1)

Report

Many thanks for first feedbacks.

I'm using PA Cloud not PAD... do you think I can get value added using PAD?

I have a Microsoft 365 family plan that should deliver me all services I need, I'm not considering moving to a business plan as far too expensive to manage my private needs.

Please find attached first screenshots of a failing flow :
- it went on fail for past 4 days,
- I did nothing else than connecting to PowerAutomate cloud, access this flow homepage and reload failing flow without any modification or reconnection to any connection... success first attemp (as usual).

As said : I'm so disapointed this flow suddenly fail!

Maybe an investigation area : in the excel spreadsheet is now 1178 lines long (1 line per day)... any problem in processing only 1178 lines table to add 1 line?

looking forward your support.

Capture d’écran 2...

connections.png

Capture d’écran 2...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Was this reply helpful? Yes No
CU03041438-0 12 on at

Like (1)

Report

Some other screenshots

Capture d’écran 2...

Capture d’écran 2...

success.png

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Was this reply helpful? Yes No
CU03041438-0 12 on at

Like (1)

Report

final ones with detailled Excel action

Capture d'écran 2...

Capture d’écran 2...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Was this reply helpful? Yes No
CU10041312-0 2 on at

Like (0)

Report

I’m experiencing the same issue in Power Automate Cloud with an Excel file. Here's the error message:

{

"status": 401,

"message": "The request is unauthorized by Graph API. Error code is 'FileOpenUserUnauthorized'. Error message is 'You do not have permissions to open this file in the browser.'.\r\nclientRequestId: ---------------------------",

"error": {

"message": "The request is unauthorized by Graph API. Error code is 'FileOpenUserUnauthorized'. Error message is 'You do not have permissions to open this file in the browser.'"

},

"source": "excelonline-bs.azconn-bs-001.p.azurewebsites.net"

}

I’ve already tried authorizing all permissions related to files in Graph Explorer, including app permissions, connections, and authentication, but nothing has worked so far.

This issue seems to be related to the Excel OneDrive connection and started occurring last week. Has anyone found a solution for this?

Was this reply helpful? Yes No
Jean-Pierre Huls-Pl... 9 on at

Like (0)

Report

Hi,

For what it is worth, here are my experiences with similar problem(s): It seems this started to occur with Graph API updates around March 30 2025 as far as I can conclude from similar issues starting on this date. Before all involved flows ran just fine.

I actually encountered a 2nd issue where when updating a text file on your OneDrive Online, the OneDrive Online "Update file" does not recognize the file ID from the previous "Get file metadata" action. The format of the file id has also changes from a short number to a 32 characters, guid like string (e.g. from <OneDrive Online ID>!1234567 to <OneDrive Online ID>!se5fdfbde76d04df5a6e771d0ab40186e).

So, Microsoft, please fix the Excel Online and OneDrive Online connectors to work properly with your Graph API updates.

Kind regards

Jean-Pierre

PS: CoPilot suggests, if nothing helps to report these issues to Microsoft. Per this.

Was this reply helpful? Yes No
TI_NFibra 8 on at

Like (1)

Report

Hello everyone, I am still facing the same issue of the unauthorized 401 error, but when I open the file and refresh several times, the flow starts to work. Can someone tell me how to report this error to Microsoft since it has been about 3 months that this is ongoing?

Thanks!

Error PA.png

Was this reply helpful? Yes No