web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Let users view and add...
Power Apps
Unanswered

Let users view and add rows to SharePoint List in Power App (SharePoint Connector), but not directly on the SharePoint List url

(0) ShareShare
ReportReport
Posted on by 3

Hi, 

 

I am creating a Power App that lets users of the app fill out and submit a form that will be added as a row in a SharePoint List. The users of the app can also view all their submitted rows from the SharePoint List directly in the Power App.

 

I don't want users to be able to enter the SharePoint List directly (from the SharePoint url for example) and add and edit their rows there, I only want them to be able to add the rows in the Power App directly.

 

I have tried giving users read only perms directly in the SharePoint List. This lets them view their rows directly in the SharePoint List but not edit them, but this change gives a permission error in Power Apps when users try to submit a new row. I have also changed the permissions so that users can only view rows they created themselves, and not others.

 

Question:

 

Is there a way to make users of the Power App be able to read, create and edit rows in a SharePoint List from the Power App, but only have perms to read, and not create or edit, directly in the SharePoint List, through the SP List url etc.?

 

 

Categories:
I have the same question (0)
  • EricBLott Profile Picture
    248 on at

    Short answer: No. 

    One workaround would be to use a custom connector or power automate so that it's using a service account's credentials to write data. 

    This would require quite a bit of rework, as the native data source would no longer be used. 

  • kaspermelheim Profile Picture
    3 on at

    Thank you for your answer.

     

    When you say "power automate so that it's using a service account's credentials", is it what is shown in the following attached image you are refering to?

     

    SharePointPerms.PNG

     In this image the user is connecting to SharePoint using the creators connection credentials

  • EricBLott Profile Picture
    248 on at

    @kaspermelheim Correct

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 893

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 482

Last 30 days Overall leaderboard