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!