Skip to main content

Notifications

Community site session details

Community site session details

Session Id : zWiVbXJ70CvYdZa6opinjX
Power Automate - Building Flows
Suggested answer

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

Like (1) ShareShare
ReportReport
Posted on 24 Feb 2025 02:53:00 by
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" }
 
 
 
  • trice602 Profile Picture
    13,768 Super User 2025 Season 1 on 24 Feb 2025 at 14:38:51
    Power automate flow cannot access xlsx file "Could not obtain a WAC access token."
    Great to hear! Tom
  • JC-24020237-0 Profile Picture
    on 24 Feb 2025 at 06:49:05
    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 Profile Picture
    on 24 Feb 2025 at 04:15:46
    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 Profile Picture
    13,768 Super User 2025 Season 1 on 24 Feb 2025 at 03:07:49
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 105

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 82 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 62 Super User 2025 Season 1

Overall leaderboard