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