Skip to main content

Notifications

Create Power Automate cloud flows
Suggested answer

Flow Requires Edit Access on SharePoint Library to Read Data From Excel Table

Posted on by 66
Hello Everyone - I am facing an issue where a user is having Read access to a SharePoint Library. I have a flow that reads the excel table data. However since the user is having read access on the library he is unable to get the table and receives an error unable to find the table. Once his permissions is increased to contribute he is able to read the table.
 
Is this a normal behavior in flow that minimal access to read a table is contribute? If yes i would need to update the permission on library to contribute which will expose the documents to Edit. Why for a basic actions just to read table data from an excel the SharePoint Read access not sufficient.
 
Anyone has any idea or a solution for this? Thanks!
Categories:
  • ST-24070323-0 Profile Picture
    ST-24070323-0 66 on at
    Flow Requires Edit Access on SharePoint Library to Read Data From Excel Table
    It is failing at List Rows present from a Table action. The error is Unauthorized and Message is blank.
  • Suggested answer
    FLMike Profile Picture
    FLMike 23,361 on at
    Flow Requires Edit Access on SharePoint Library to Read Data From Excel Table
    Hi,
     
    Can you share your flow run please where it was failing.
     
    Also, did you go right to contribute or did you try other permissions.
     
    Its possible whatever your flow is doing i thinks requires to be able to modify and you don't have that permission, but would need to see your flow to verify.

Helpful resources

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,745

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics