Power Platform Community Forum Thread Details

Hi,

I have a canevas app in which users can modify items of a sharepoint list. i dont want users could modify my sharepoint list directly in sharepoint site, but only within the app. Is it possible to do that ? could they use another sharepoint connexion (i.e service account connexion) that their own? how?

Thanks a lot for your help.

Categories:

Building Power Apps

@FrancoGui

You cannot create a "service account" connector for SharePoint as that connector passes through the user credentials to the SharePoint list.

The only way you can emulate this is to utilize PowerAutomate. It's ugly because you would need to have a common list that all users have access to. Your flow would trigger whenever there is a change in that list. It would then pick up the info from the shared list and put it in the restricted list...and then remove from the shared list.

Because the flow would not be "called" from the app, it would run under the connector definition made in PowerAutomate (i.e. your service account).

Warning though...this can get ugly quickly because your app is not longer "in-sync" with the main restricted list, and you would need to perform Refresh statements often to resync.

So...you might want to consider the nature of not allowing edit control on the primary list and see if there are other options for you to explore.

I hope this is helpful for you.