Forum Discussion
Allowing users to submit data to a SP list but disable the Add new Button
Hi,
I'm trying to stop users from accessing the SP list directly and using the 'Add new item' button, but still allow them to submit a record via a PowerApp.
I've looked this up and what I found was. As long as the owner or co-owner of the app have the appropriate permissions (Edit, Full Control) in the list permissions the group that contains 'Every one except external users' normally in the visitors group, can be set to Read.
This will stop the users accessing the list??
I'm the owner of the app and have edit permission for the site and the list, but it seems to cause issues with users submitting new records via the PowerApps.
When I change the permissions back to Contribute the records are submitted. Sometimes, if the user as submitted two records these are both submitted?
Can someone please confirm if this process is correct and suggest if I'm doing anything wrong??
Regards
Chris
- Rob_ElliottBronze Contributor
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) - grant_jenkinsIron Contributor
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.