Submit form without sharing the Sharepoint list

[Salehkhalil]

I have form in power apps and the data source is sharepoint list,

how can the end-user submit the form without sharing my data source (I have secret data that can't be shared)?

[WarrenBelz]

Hi @Salehkhalil ,

If you want the end user to submit to the data source, the list needs to be shared with them. You can "hide"the List however, the simplest way being giving the user a custom permission (based on contribute) with "View application pages" unchecked (that way they cannot view pages in SharePoint).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Pstork1]

As @WarrenBelz says, user's can't submit information to a SharePoint list unless they have access to SharePoint.  The only way to do this without giving them access would be to create a Microsoft Form with one question for each column you want them to submit and then create a Power Automate flow to trigger when the form is submitted and add the responses to SharePoint.  Since the flow is automated it will run in the security context of the maker (you). so no one else will need access to the list.

[WarrenBelz]

@Salehkhalil ,

I agree with @Pstork1 - just note this will only work on new records. I use another form provider that can take incoming parameters and email the pre-populated form link to the user with a Flow writing it back to the record. The restriction here is that someone else has to email the user as they need access to the list record.

[Salehkhalil]

How I can hide the list only for end user?

[WarrenBelz · Accepted solution]

@Salehkhalil ,

Exactly as I posted - give the relevant users a custom permission level in SharePoint. An example of mine is below

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[WarrenBelz]

Hi @Salehkhalil ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[JayAdamspt]

Hi @WarrenBelz , 

Can you pls post the path to arrive to that settings page ? I cant find it in my sharepoint list permission.