Giving permission to access the SharePoint list!

%3CLINGO-SUB%20id%3D%22lingo-sub-2069649%22%20slang%3D%22en-US%22%3EGiving%20permission%20to%20access%20the%20SharePoint%20list!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2069649%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%3CBR%20%2F%3EI%20have%20an%20application%20made%20by%20power%20apps%20and%20it%20depends%20on%20SP%20lists%20to%20get%20data.%3C%2FP%3E%3CP%3Ethe%20users%20of%20the%20application%20don't%20have%20permission%20to%20get%20into%20the%20SP%20so%20they%20can't%20see%20the%20data%20in%20the%20app.%3C%2FP%3E%3CP%3EHow%20can%20I%20let%20them%20use%20the%20app%20without%20giving%20them%20access%20to%20SP%20which%20has%20private%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2069649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2069773%22%20slang%3D%22en-US%22%3ERe%3A%20Giving%20permission%20to%20access%20the%20SharePoint%20list!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2069773%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F932662%22%20target%3D%22_blank%22%3E%40ManarYazji%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20best%20practice%20is%20to%20use%20actual%20user%20permission.%20If%20the%20app%20is%20intended%20to%20show%20only%20the%20data%20without%20any%20operations%20on%20the%20data%2C%20then%20it's%20better%20to%20provide%20the%20read%20access%20to%20the%20users%20so%20that%20you%20don't%20have%20to%20worry%20about%20the%20permission.%20Another%20option%20is%20to%20use%20the%20service%20account%20which%20you%20can%20use%20while%20making%20the%20connection%20while%20creating%20the%20power%20app.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2069800%22%20slang%3D%22en-US%22%3ERe%3A%20Giving%20permission%20to%20access%20the%20SharePoint%20list!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2069800%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F144422%22%20target%3D%22_blank%22%3E%40Sudharsan%20K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20application%20is%20filtering%20the%20data%20according%20to%20the%20user%20which%20is%20not%20allowing%20the%20user%20to%20see%20any%20data%20that%20not%20belong%20to%20him.%20So%2C%20if%20I%20give%20him%20permission%20to%20read-only%2C%20there%20is%20a%20chance%20to%20get%20to%20the%20SP%20list%20and%20see%20the%20data%20which%20is%20private.%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%20class%3D%22gtx-trans-icon%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

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 app.

How can I let them use the app without giving them access to SP which has private data?

 

Best

4 Replies

@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.

 

@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. 

 

@ManarYazji 

 

Possible solution you can try:

 

Use item level permissions on SharePoint list items. This way users will be able to see only those item on which they have access.

 

You can set item level permissions from SharePoint lists for each list item. If you want to automate permission management on item creation/updating then you can do that using Power Automate.


Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.