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 / Dataverse custom table...
Power Apps
Answered

Dataverse custom table permission

(0) ShareShare
ReportReport
Posted on by 264

Hi,

I have Canvas app/ Dataverse solution that I would like to share with all team members, who have the required power app licence.

I have a custom table in the solution, but other user cannot see the table data in canvas app: gallery control.

I am not sure, what I am missing:

 

My tried out solution that did not work:

1:  Editing security role and add full permission to custom entity/table, 

mentioned in: https://docs.microsoft.com/en-us/power-apps/maker/model-driven-apps/share-model-driven-app#create-or-edit-a-security-role-for-your-app

 

p_doc_0-1657675505190.png

 

2: Adding a new security role and add it in solution.

3: Adding a co author role to the user.

 

The only thing that worked was providing my user power platform admin access.

mentioned in : https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataverse-Environment-and-Table-Permission/m-p/948249#M11868

 

I cannot provide  admin access to all the user.

Is there any other solution or work around?

Please let me know if I have missed anything.

Any help is appreciated.

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

    Hi @PaulMatha,

     

    When you say you granted your user "co author role", is that that the name of your new custom security role? Or do you mean you set the person as co-owner of the app?

     

    You need to assign your user the custom security role with permissions to the custom tables in order for them to see the data. Setting the user as a co-owner of your app does not give them access to the data, only the ability to modify your app which you probably don't want.

     

    ---
    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.

  • Paul_M Profile Picture
    264 on at

    Hi @ChrisPiasecki ,

    Thank you for the reply.

    Yes, I have given the user: co-owner access. ( I am trying all possible solution)

    I have also created custom security role and assigned it to user.

    But I cannot see the Dataverse table in power app.

     

    I there something that I have missed?

  • ChrisPiasecki Profile Picture
    6,428 Most Valuable Professional on at

    Hi @PaulMatha,

     

    How did you create your custom security role? Did you copy the basic user role and then add the additional permissions for the custom table? Or did you create it from scratch? It's recommended to copy the basic user role and modify that copy since the basic user role has a bunch of core permissions needed to properly use an app (e.g read privileges to a bunch of tables under Customization tab).

     

    More details are mentioned 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.

  • Paul_M Profile Picture
    264 on at

    Hi @ChrisPiasecki ,

    Created as a copy from basic user.

    Followed the creation steps mentioned in the link you have provided.

  • Verified answer
    ChrisPiasecki Profile Picture
    6,428 Most Valuable Professional on at

    Hi @PaulMatha,

     

    Can you try to check the users access to a particular row in one of your tables to see if they truly have access?

     

    You can use the Check Access command in a form to do so. More information 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.

  • Paul_M Profile Picture
    264 on at

    Hi @ChrisPiasecki ,

     

    I am working on canvas app, I am not sure if I can use Check Access command in a form.

    However, user can see all the data, when login into table:

    p_doc_0-1657688309925.png

     

     

  • Paul_M Profile Picture
    264 on at

    Hi @ChrisPiasecki ,

    Thank you for all you help.

    I was able to solve my problem.

    The issue was with column security as table security and column security is different.

    Your comment to check row level access was helpful.

     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 404

#2
timl Profile Picture

timl 344 Super User 2026 Season 1

#3
WarrenBelz Profile Picture

WarrenBelz 320 Most Valuable Professional

Last 30 days Overall leaderboard