User Has No Access to Table

(0) Share

Report

Posted on by IPC_ahaas

1,387 Moderator

I created an App and multiple Tables in a Solution in my "Dev" Environment.

I pushed the solution to our "Beta" Environment.

The "Beta" Environment has a "Power App - Inventory" Security Group applied to it with the "Basic User" Security Role applied.

The App is shared to the same "Power App - Inventory" Security Group.

My test user who is a member of the "Power App - Inventory" Security Group can see the app.

When my test user goes to use the app, they get:

Seems like it's saying that the user doesn't have read. How is that so?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

the "Basic User" security role doesn't have the privileges for your custom tables, you usually create an additional security role with access to your custom tables and give this new security role to your users as well.

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

How would that work? When creating a new Security Role, I don't get the option of what it applies to.

This seems backwards and unnecessary. I should just be able to specify that X Roles have X access to X Datasources.

Was this reply helpful? Yes No
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

after the role is created you have the option to indicate which tables (and which permission, like read, write, delete and at which level, like user, bu, organization) the security role applies

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

The tables for my solution aren't listed:

Tables in my solution for the same Environment.

Was this reply helpful? Yes No
Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

where you see "Show only assigned tables", click and change to "Show all tables" and your tables will appear

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

Are you freaking kidding me Microsoft. If only there was some way to identify something as a drop-down menu.

Was this reply helpful? Yes No