Forum Discussion
Giving permission to access the SharePoint list!
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.
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.
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,
