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

Question

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

Answer 1

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/

Answer 2

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