Forum Discussion

ManarYazji's avatar
ManarYazji
Copper Contributor
Jan 18, 2021

Giving permission to access the SharePoint list!

Hello there, I have an application made by power apps and it depends on SP lists to get data. the users of the application don't have permission to get into the SP so they can't see the data in the...
admin
Document Library
Permissions
sharepoint server
Sudharsan K's avatar
Sudharsan K
Iron Contributor
Jan 18, 2021

ManarYazji 

The best practice is to use actual user permission. If the app is intended to show only the data without any operations on the data, then it's better to provide the read access to the users so that you don't have to worry about the permission. Another option is to use the service account which you can use while making the connection while creating the power app.

 

  • ManarYazji's avatar
    ManarYazji
    Copper Contributor
    Jan 18, 2021

    Sudharsan K 

    The application is filtering the data according to the user which is not allowing the user to see any data that not belong to him. So, if I give him permission to read-only, there is a chance to get to the SP list and see the data which is private. 

     
    • daveyskills's avatar
      daveyskills
      Copper Contributor
      Jan 18, 2021

      ManarYazji 

      You can create a Flow to set item level permissions on the SharePoint list, here are some references,

      https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Microsoft-Flow-to-Provide-Item-Level-Permission-on-SharePoint/ba-p/351195

      https://noellawlor.wordpress.com/2018/01/18/setting-sharepoint-item-list-permissions-with-flow/

      Thanks,

Resources