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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Creating Permissions f...
Power Apps
Unanswered

Creating Permissions for a Dataverse Table

(0) ShareShare
ReportReport
Posted on by 55

I have created an app with multiple dataverse tables and I want to be able to allow users to edit their own entries in the table and add new ones but the ones they havent created cant be changed. How can I edit uniquely the permissions for the tables. I have seen documentation for doing it through Teams App but our app is not set up through Teams. 

 

@Granting permission to tables in Dataverse for Microsoft Teams (contains video) - Power Apps | Microsoft Learn 

Please let me know!

I have the same question (0)
  • Verified answer
    ChrisPiasecki Profile Picture
    6,422 Most Valuable Professional on at

    Hi @sarahbrooks,

     

    You can create and manage security roles through the Power Platform Admin Center. You will want to apply user/team scoped permissions for create/edit/read on each of the tables in question so that users only see and modify their own records. 

     

    Detailed steps are provided in the documentation here

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

  • Verified answer
    gulshankhurana Profile Picture
    1,397 Moderator on at

    Hi @sarahbrooks 

     

    The users would need to be assigned a security role in dataverse - a role that has the required level of permissions for different actions such as Create, Read, Write etc. 

    1. Go to the Power Platform Admin Centre

    2. Select the environment in which the app is built and go to its settings

    3. Under Security, look for the security roles. 

    4. Either assign a security role that closely matches the user's profile or make a copy and amend permissions on that copied role before assigning the copied role to the users.

    5. If you have created any custom tables, they wouldn't have any permissions assigned by default so you'd need to do so by finding those table in the Custom Entities/Tables tab.

    6. The User level permission will allow user to perform the action on a particular table record only where the user is the owner of the record. E.g. User Level permission for Read action on a custom table 'Quality Sample' will allow the user to only see records that they own. 

     

    Here's the link with further information:

    https://learn.microsoft.com/en-us/power-platform/admin/security-roles-privileges

     

    I hope this information helps. Please give my reply a Thumbs Up if you appreciate my efforts. If it helps resolve your query then please accept it as a solution.

     

    Kind regards

    Gulshan

  • sweb Profile Picture
    117 on at

    https://learn.microsoft.com/en-us/power-platform/admin/security-roles-privileges#access-levels

    Users can access records they own, objects that are shared with the organization, objects that are shared with them, and objects that are shared with a team that they're a member of.

     

    It does not give access only to the records they own, but also to records shared with them.

    So in a Canvas app, if you use a table as a source, it will give access to the whole table.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard