Hello!
I'm creating a flow to record rows in an Excel table via a card in Microsoft Teams.
When I created it last Friday, it worked perfectly, however, it stopped working, always generating the "403 - Forbidden" error in the excel step.
This is my currently flow:
I've already tried using the shared spreadsheet on my OneDrive for Business and also on the team's Sharepoint, and the same error appears.
I've already updated all my connections and recreated the flow from scratch, but the errors continue.
Connection's Page:
Can someone help me?
Below is the error message.
The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'Você não pode realizar a operação solicitada.'.
clientRequestId: 2fc07b1c-0be7-4e31-a52b-4e3a5782f29f
serviceRequestId: 181cd0c5-5cab-41ae-949f-b79bfb595c7c;e4362298-85d8-4ab6-abf2-b7540bc6d09c;99465b6e-f015-488a-a6bd-db1c1a54f069;b643afb2-545d-4388-ad14-b620898111d6
Hi @douglasklann ,
Nice! Glad Monday is starting this way! Please mark as a solution to help others find this answer too! (Common issue).
I made a very dumb mistake ahaha
I had protected (locked) the Excel table for editing. I unlocked it and it worked! hahaha
Thank You so much for the help!
Hi @douglasklann ,
With OneDrive connector, I would allow for enough time for this to sync, meaning I have found closing and running immediately doesn't solve this. I would recommend checking other things but if it worked on Friday, it is most likely a file locked issue.
If your flow is small, you can verify by deleting the action and readding, if the file is locked you cannot add the action.
I asked for the guys to close the file and I closed too, but it didn't work. Same Error.
Any other probably cause?
Hi @douglasklann ,
Most likely the root cause is the file is open by someone. Please make sure everyone is logged out of the file and it is checked in.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional