Update a Row Excel Error 403 Forbidden

(0) Share

Report

Posted on by Bajda

Hello,

I got the error message 403 in Power Automate with the action Update a Row.

Here is the Output:

{

"status": 403,

"message": "The request is forbidden by Graph API. Error code is 'AccessDenied'."

"source": "excelonline-we.azconn-we-003.p.azurewebsites.net"

}

I know it's the worksheet protection that's the problem. Is it still possible to somehow work with the protection without Power Automate going on strike?

Thank you!!

Best regards

Kamil Bajda

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

manuelstgomes 6,625 on at

Like (0)

Report

Hi @Bajda

I don't see it in the documentation, but I don't think it's possible to access a protected worksheet.

Sorry about that!

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members find the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,690 Moderator on at

Like (0)

Report

If you're open to it, you could use Power Automate Desktop, and have it populate the password when needed to circumvent the protection. Not sure if that's an option for you.

Was this reply helpful? Yes No
Bajda 52 on at

Like (0)

Report

But is it possible to Transfer Data from Excel to SQL with Power Automate Desktop? Thank you for help!

Was this reply helpful? Yes No