Forum Discussion
Allowing users to submit data to a SP list but disable the Add new Button
Chris_Clark1968 what I have done before (and am currently doing on one site for award nominations) is to have an "open" list where everyone has Contribute access. and they submit new items via a form in Microsoft Forms. A flow in Power Automate gets each newly-created item, creates an item in a "secure" list (where only a couple of people have access) then deletes the item from the "open" list.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Chris_Clark1968 It all depends on how you've built your Power App.
If it's directly connected to the SharePoint list and you're using Form controls to submit the data, then it will use the credentials of the user that is running the Power App, and they will need permission to add to the list.
If it's a standalone Power App and you're using Power Automate to take the data from the Power App and add it to SharePoint via a Create Item connector, then you should be able to configure the SharePoint connection to run under the credentials of the Power Automate owner/co-owner. You would set this up when you're adding the Run only permissions. In the screenshot below, you would select Use this connection.
