Unanswered

Error 403 when adding a row to an excel table (OneDrive)

(0) Share

Report

Posted on by wsescobedo

My flow has been working for several days, until it stoped working by its own. When I checked I saw that even though I can select the excel file from the browser icon, apparently I cannot access the table information anymore, causing this an error.

The dynamic operation request to API 'excelonline' operation 'GetTable' failed with status code 'Forbidden'. This may indicate invalid input parameters. Error response: { "status": 403, "message": "Graph API prohíbe la solicitud. El código de error es \"AccessDenied\". El mensaje de error es \"Could not obtain a WAC access token.\". clientRequestId: e910fbc7-a1b9-4d7f-a8d9-a8a2a2e859d5", "error": { "message": "Graph API prohíbe la solicitud. El código de error es \"AccessDenied\". El mensaje de error es \"Could not obtain a WAC access token.\"." }, "source": "excelonline-bs.azconn-bs-001.p.azurewebsites.net" }

I checked and my connections are fine.

I do not understand what the problem is and how to fix it.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Hi @wsescobedo

Sometimes there are issues with the connection. Power Automate breaks the connection silently and then there are strange errors like this.

Can you please go to your connections in Data > Connections, check the account that you're using, and if there are any issues with it? If possible, re-create it and use the new connection in your Power Automate and see if it works.

This happens all the time, and re-setting the connection usually sets everything correctly again.

Was this reply helpful? Yes No
wsescobedo 2 on at

Like (0)

Report

I checked the connections, and they were ok. Still, I deleted the Excel Online (OneDrive) connection and created it again. Went back to the flows, I had to select the recently created connection, but even then the issue persists. I even tried to create a new connection from the flow tab, but same result. Some other suggestion? Thanks!

Was this reply helpful? Yes No
Ab3l 45 on at

Like (0)

Report

Were you able to fix it, bro?

I am having the exact problem with no solution.

Ref: https://powerusers.microsoft.com/t5/Building-Flows/Facing-Error-in-Power-Automate-Flow-Could-not-retrieve-values-in/td-p/2438191

Was this reply helpful? Yes No