Power Automate - Building Flows

Power automate flow cannot access xlsx file "Could not obtain a WAC access token."

Like (1) Share

Report

Posted on 24 Feb 2025 02:53:00 by JC-24020237-0

My power automate flow started failing today accessing xlsx file "Could not obtain a WAC access token."

The error message is showed while getting table list in "List rows present in a table":

The file is showed in the dropdown list of the "List rows present in a table" component, but cannot get table list.

It is a critical flow for ADO intake process of 80+ Teams services. It was working yesterday; no change was made.

I tried a couple of new connections, didn't work.

I created spreadsheet and it is accessible via excel.

Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'Forbidden'. This may indicate invalid input parameters. Error response: { "status": 403, "message": "The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'Could not obtain a WAC access token.'.\r\nclientRequestId: 5a1a2d2f-595f-4402-98c9-f6dcecb4c1b4", "error": { "message": "The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'Could not obtain a WAC access token.'." }, "source": "excelonline-cc.azconn-cc-001.p.azurewebsites.net" }

Categories:

Business Process Flows

All responses (4)

Answers (0)

trice602 13,768 Super User 2025 Season 1 on 24 Feb 2025 at 14:38:51

Like (0)

Report

Power automate flow cannot access xlsx file "Could not obtain a WAC access token."

Great to hear! Tom
JC-24020237-0 on 24 Feb 2025 at 06:49:05

Like (1)

Report

Power automate flow cannot access xlsx file "Could not obtain a WAC access token."

I tried again a couple hours later and made no changes at all. But it worked. Then I tried again, and it failed with 504 gateway error. Then I tried again, this time it succeeded...... Feels it is a service issue.

We need to understand the reason and get it fixed.
JC-24020237-0 on 24 Feb 2025 at 04:15:46

Like (1)

Report

Power automate flow cannot access xlsx file "Could not obtain a WAC access token."

hi @trice602, thanks for checking, but I still have access to the file, verified by opening it in excel.
Suggested answer

trice602 13,768 Super User 2025 Season 1 on 24 Feb 2025 at 03:07:49

Like (0)

Report

Power automate flow cannot access xlsx file "Could not obtain a WAC access token."

Hi,

Seems like you don't have access to the file anymore. Even though it is available in the dropdown, it doesn't mean you have access to it. Is this in SharePoint? Can you verify you have access to the file outside of Power Automate? If the file is in OneDrive for Business, is the file shared with you?

If that doesn't work, also try this:

Get the Table name and in the Table field, use custom value and type it in but it seems like your access has recently changed.

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

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Community site session details

Power automate flow cannot access xlsx file "Could not obtain a WAC access token."

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Power automate flow cannot access xlsx file "Could not obtain a WAC access token."

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates