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

john john 946 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

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,240 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,596 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Emily Du-MSFT 43,996 Reputation points Microsoft Vendor
    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.


  2. Shiv Sharma 1 Reputation point
    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