Dataverse custom table permission

(0) Share

Report

Posted on by Paul_M

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

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Paul_M 264 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Paul_M 264 on at

Like (0)

Report

Hi @ChrisPiasecki ,
Created as a copy from basic user.
Followed the creation steps mentioned in the link you have provided.

Was this reply helpful? Yes No
Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Paul_M 264 on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Paul_M 264 on at

Like (0)

Report

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.

Was this reply helpful? Yes No