List Rows Present in a Table -- Access Denied on Protected Sheet

(1) Share

Report

Posted on by cgreenmzr

I'm creating a process where I'm taking an uploaded file to SharePoint and using 'List rows present in a table' to create a SharePoint list. The uploaded file is an Excel document (.xlsx) which is formatted like a 'template' so the end user enters in specific information. I have the Workbook protected, and also want to protect the sheet so the end user cannot make column header changes, but when I protect the Sheet, my Power Automate flows throws "The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'You cannot perform the requested operation.'"

If I leave the sheet 'unprotected', the flow runs successfully. Any thoughts? Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Andrew_Unick776 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, I just had the same problem. Fixed when I allowed Autofilter when protecting sheet. Switched off filter buttons for tables before applying Protect Sheet.

Was this reply helpful? Yes No
andrelr2001 2 on at

Like
a
(0)

Report
Copy link

Link copied!

hmmmm, did not work for me 😞

Was this reply helpful? Yes No
Suggested answer

gamos 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this detail. Very important. Sure wish the error code was more specific:
Action 'List_(filtered)_rows_present_in_a_table' failed: The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'You cannot perform the requested operation.'

^ That really tells you nothing about the fact the worksheet/tab being protected is the cause of the problem

In my case, I unprotected the sheet and hid it - good enough.

It would be a nice feature to be able to pass the sheet password into the request, to allow a user to get past the AccessDenied blockage.

1 people found this reply helpful.

Was this reply helpful? Yes No