Power Automate

The request is unauthorized by Graph API. Error code is 'FileOpenUserUnauthorized'.

(2) Share

Report

Posted on by jianminong

Dear All,

I have recently gotten this error. It was working fine previously.

Error

Action 'List_rows_present_in_a_table' failed

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: 709b0d31-ecad-4cab-9efd-5c26af095885

Below is the image of the actual error. I have actually tried consent access to all the excel permissions under Graph Explorer but still this error comes up.

I also did relogin and clear my browser's history.

Please help.

Currently solution is that I have to open up the excel file via office.com for it to detect and read this excel table.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

trice602 15,888 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @jianminong,

Delete the action List rows present in a table and save. Exit. Re-edit, re-add. Your connection string probably is corrupt.

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @jianminong

As @trice602 has mentioned the connection string is probably corrupt. However, before deleting the list rows action, you can also try clicking the three dots on that action and add a new connection.

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
jianminong 8 on at

Like (1)

Report
Copy link

Link copied!

Hi @yashag2255 @trice602

I got this error instead.

Is it they recently disallow personal account to use this Power Automate flow?

Test connection failed. Details: Failed to get onbehalfof access token: connectionId=excelonlinebusiness, message={"error":"invalid_grant","error_description":"AADSTS500200: User account '{EUII Hidden}' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try signing out and signing back in with an organizational account. Trace ID: 9972f14d-dd53-4a10-85e4-3f87ed251400 Correlation ID: a7cde2ad-9a60-49b5-8352-41d6ce79ce3b Timestamp: 2025-07-11 06:12:14Z","error_codes":[500200],"timestamp":"2025-07-11 06:12:14Z","trace_id":"9972f14d-dd53-4a10-85e4-3f87ed251400","correlation_id":"a7cde2ad-9a60-49b5-8352-41d6ce79ce3b"}

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @jianminong

You may want to check with IT and confirm if your personal account has access in Entra. I was assuming that you have been using a Business account with access to the excel file on SharePoint/OneDrive.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No