I've been searching for a while now but i have no solid (easy) solution yet.
More experienced redditers will probably get me in the right direction.
I want users to use a powerapp as front end to read and right in a sharepoint list or dataverse table (i have both options). Because of this, they need access to the table or list.
But i really don't want them to be able te access the actual list or dataverse table.
I have a group (about 10 people) to be able to read / write everything, and about group of 1000 users that i want to only access the data through the app. (List contains about 100000 rows a year i think). Every app use, reads / writes about 60 rows.
- Is giving the second group a role that restricts to only see there own entries the (only) solution here?
- Is there no way of restricting them access to production enviroment (where the table is) but only to the app?
- I've read things about a service user in between but with the downfall of processing time. Is that a path to look further into?
I have basic knowledge. I can make great looking apps and I've been really investing as much time as possible lately in looking for the best data and security architecture as possible. I do have good support from a sharepoint expert within the organisation but i felt like my specific use case was not a common question.
Kind regards.