Skip to main content
Community site session details

Community site session details

Session Id : SzoE6swpNU9btHtLke/pm0
Power Automate - Building Flows
Unanswered

XLS can not be processed by Excel Online (Business)

Like (1) ShareShare
ReportReport
Posted on 11 Jul 2024 08:16:27 by 4

We have a workflow that starts with an Excel File with multiple lines of new Customers/Orders. By default this file is still of type .xls

 

This file is saved to a OneDrive Folder and should be processed by a PowerAutomate Flow as seen in the picture below:

I did not include the whole flow as it always fails on "Get Tables"I did not include the whole flow as it always fails on "Get Tables"

I tested this flow with XLSX-Files and it works fine. (If there is a table it will process each row. If  there is no table it will create one and save the file with a new name to trigger the flow once again)

 

As soon as someone else saves an XLS-File though, I will get the following error (the Flow failing):

 

 

Action 'Get_tables' failed: The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'Could not obtain a WAC access token.'. clientRequestId: b934893-0fcb-7834-87d-90adf9d09df9 serviceRequestId: d09sdf90-09sd-0sdf-f09d-afd098dfd098

 

 

 

I don't see how this error is related to the Filetype. I would expect another error, or much rather no error at all. 

 

I would appreciate any ideas on how to avoid this issue (apart from using xlsx 🙃)

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete