Skip to main content

Notifications

Power Up Program - Create Power Automate cloud ...
Suggested answer

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

Posted on by 77
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 77 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 29,268 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,685

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard

Featured topics