Announcements
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)?
Hi @Anonymous ,
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
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.
@Anonymous ,
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.
How I can hide the list only for end user?
Exactly as I posted - give the relevant users a custom permission level in SharePoint. An example of mine is below
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Hi @WarrenBelz , Can you pls post the path to arrive to that settings page ? I cant find it in my sharepoint list permission.
In the advanced permissions you need to click "permission levels" then "add new permission level". That's the screen above. You then probably need a new group to assign the permission level to.
Refer Reza Dorrani Video- https://www.youtube.com/watch?v=ts-ggDAy7IQ
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 387
timl 340 Super User 2026 Season 1
Vish WR 301
