Share via

Can we remove users' permission from SharePoint lists and libraries and interact with SharePoint using a service account

john john 1,031 Reputation points
2022-11-16T22:07:08.157+00:00

I come from ASP.NET with SQL server web development. where the database is not exposed to the end users, and we interact with the database using service account inside the connection string. but in SharePoint things by default are different. Where all users can access the SharePoint lists. so my question, does SharePoint online support a scenario, where we can block the users from accessing the SharePoint lists (using built-in forms, API call, etc ) so they do not have any permissions on the lists and instead we interact with SharePoint from Power Apps or other means using a service account. so we can apply all the business logic and validation we want inside the code (Power Apps or custom application which interact with SharePoint)?

Thanks

Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | SharePoint Server | Development

2 answers

Sort by: Most helpful
  1. Shiv Sharma 1 Reputation point MVP
    2023-12-29T12:41:18.0033333+00:00

    You can use power automate to add and remove permissions of your SharePoint list items.

    https://pnp.github.io/blog/post/how-to-break-and-change-list-item-permission-using-power/

    0 comments No comments

  2. Emily Du-MSFT 51,986 Reputation points Microsoft External Staff
    2022-11-17T07:36:38.723+00:00

    @john john

    Per my knowledge, if users want to interact with SharePoint lists from Power Apps or other means, users should have at least read permission for SharePoint lists. When users have read permission for SharePoint lists, all users can access SharePoint lists.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.