Power Platform Community Forum Thread Details

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 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 🙃)

Categories:

Building flows