Dataverse Table data won't show in app for other users

[mjmedina97]

Hello people! 

After long hours of building my app, I'm finally at the point where I can share it with my end users. However, I must admit that I'm struggling with the whole Environment and Security Roles situation.  

After sharing the app with one user for testing purposes, they were able to see and enter the app but no data is being displayed. Here's what they see: 

I believe it's important to mention that I used only Dataverse tables to build the app and I did it all in the Developer environment. After some reading, I learned that I apparently need a production environment and assign my users a specific security role (which I believe is customizable). Can someone please briefly explain what I need to make my app usable when sharing? 

Thank you!

[dpoggemann]

Hi @mjmedina97 ,

When you create custom tables in Dataverse the security to read / create / update / delete etc. are not added to any of the roles except the System Administrator by default.

Best practice would be to create a new security role for your application like <appname> User and when you do this you will need to add the the security for the tables.  You want to start with "least privilege" security and the link below shows the approach to create a custom role.  

Note, you will see your custom tables listed on the "Custom Entities" tab in the security role.   

See details here on creating / updating roles:  https://learn.microsoft.com/en-us/power-platform/admin/database-security#create-or-configure-a-custo... 

[mjmedina97]

Hey!

thanks for the tip, I was able to create the security role and assign it to my test user. However, I still haven't figure out how to add the new role to the tables required for the App. 

[dpoggemann · Accepted solution]

Hi @mjmedina97 ,

You actually add the table security (read, update, delete, etc.) to the security role.  Please see the "Custom Entities" tab, find your table and assign the appropriate security.

[nslbsa19]

Hello, did you finally find a way to share the dataverse table?

[mjmedina97]

Hi!

Yeah I did, if you read above @dpoggemann actually helped me find the solution. Here's the article that got me out of my issue: Configure user security in an environment - Power Platform | Microsoft Learn 

In a nutshell, you just need to do the following;

1. Open the Power Apps Admin center
2. Create or use an existing security role
3. Assign the tables that you want to share with your end users to the role you picked.