Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Experimental Features / Restrict SharePoint l...
Power Apps - Power Apps Experimental Features
Suggested answer

Restrict SharePoint list view/edit access but allow record creation through PowerApps.

(0) ShareShare
ReportReport
Posted on by lisha 80
Hello Everyone,
 
I have a PowerApps application, where I have entered details using form and viewing in the gallery.  and the Datasource I am using is SharePoint, creating the lists.
For accessing the data in powerapps, we have to give all the users access to sharepoint site. which automatically give permission to view the list from sharepoint to all users.
I want to restrict the users editing and viewing permission but they should have access to create and modify record from Powerapps.
How can we implement this , so that no one can change any record from backend to make the details secure.
 
  • WarrenBelz Profile Picture
    WarrenBelz 148,463 Most Valuable Professional on at
    Restrict SharePoint list view/edit access but allow record creation through PowerApps.
    Hi @lisha
    With those permissions, they should not be able to access any views whether they have a link or not. The other option is to "lock down" the list as per this blog of mine and have the default view filtered so it does not show any records they should not see. 
     
    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • lisha Profile Picture
    lisha 80 on at
    Restrict SharePoint list view/edit access but allow record creation through PowerApps.
    Hi Warren Belz,
     
    Thanks for your response, but in this case if user has the link, they can able to view the list and have an option to update the data as well. 
    Is there any option we can remove the edit option and also restrict to view as well.
     
    Thanks,
    Lisha
  • WarrenBelz Profile Picture
    WarrenBelz 148,463 Most Valuable Professional on at
    Restrict SharePoint list view/edit access but allow record creation through PowerApps.
    A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps        Buy me a coffee
  • WarrenBelz Profile Picture
    WarrenBelz 148,463 Most Valuable Professional on at
    Restrict SharePoint list view/edit access but allow record creation through PowerApps.
    Hi @lisha
    If you create a custom permission level in SharePoint based on Contribute, but with View Application Pages unchecked, the users should not be able to access any SharePoint view on the list. There are also ways of hiding the list - this video may be useful to you.
     
    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • Suggested answer
    ShaileshP Profile Picture
    ShaileshP 31 on at
    Restrict SharePoint list view/edit access but allow record creation through PowerApps.
    You can use Power Automate as a mediator between powerapps and sharepoint to achieve it.. Give permission to the user of powerautomate in the Sharepoint list to create and update.. The same goes with the retrieving as well..
    Its an indirect task, but this should be one of the approach...

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans