I am working on a flow to receive an excel file as an email attachment and then to upload each record from the file into a sharepoint list. So far, I am continually running into the following error message when trying to retrieve the rows in the table:
The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'Could not obtain a WAC access token.'.
Any thoughts on how I can resolve? The highlighted portion of the flow is where the error occurs.
Hello @tlevine
It seems you are creating the file in a SharePoint site, but on the other hand, the location of the excel file says "Group" instead of "SharePoint":
Hope it helps!
Ferran
It seems its trying to get the location of the file via its browser based URL (Office web apps). I am not sure you will be successful in the way you're doing it given limitations in the Excel actions unfortunately as I understand they don't support dynamic fields. Here's a blog with the only workaround I am aware of though there may be others.
Also, I don't know how you can guarantee that the files you receive always have a table in it (which the connectors require). Are you filtering the email trigger to only fire if it contains attachments as well?
----------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
User | Count |
---|---|
78 | |
55 | |
52 | |
43 | |
40 |
User | Count |
---|---|
81 | |
79 | |
75 | |
67 | |
43 |