Send data from a form to a sharepoint list with another user account than the user connected to the application

[RodCapri]

Hello,

I'm trying to send data to a SharePoint list but I want only the admin account to be able to access this list but I need basic users to be able to add their information to the list.

So I'm trying to find a way that once the form is validated, the application takes into account that it's the admin who has filled in the information while it's the normal user who has used the application.

This is to avoid that the basic user can access the list with quick access to Office.

[RiccoHipp1903]

As I know, this is impossible. To upload and view data, every user (using the app) needs access to the sharepoint list

[RodCapri]

Let's say I give the rights to everyone, can I send the form data to the list with another user than the one using the application?

[RiccoHipp1903]

No, the connection can only use the conenction the specific user which uses the app has. So SP will always show in a  eg. list "Created By" and than the user which used the app. 

No possible solution to use another conenction

[RodCapri]

So I have to find a way to remove the SharePoint list from the Office 365 quick access.

[RiccoHipp1903]

yeah, maybe, but doesn't solve the problem I think

[RiccoHipp1903]

@RodCapri 

Thought about it. The idea I see could be, you make a dummy list where everyone has the right to edit. Everytime a item is created in the sharepoint list, you let run a Power Autoamte flow with the account you want and let that create that item in the new productive list and delete the old entry from the dummy list.

[RodCapri · Accepted solution]

In the end I modified the rights and accesses of the list so that when a user modifies the list, he can see only the value he modified