Unanswered

Dataverse Security access table

(0) Share

Report

Posted on by Jsmith2

Hello All,

I'm a newbie to the Powerapps/ Dataverse world.
Scenario:
The business owner wants me to lock down access to our main Dataverse table based on a user Access table. This user access table has three fields: User Email, Entity ID, And ID and is populated dynamically from our Payroll System. Is this possible within Dataverse?

Categories:

Microsoft Dataverse with Power Apps

Screenshot 2022-1...

I have the same question (0)

All responses (2)

Answers (1)

Tolu_Victor 197 Super User 2024 Season 1 on at

Like (0)

Report

Yes. This can be easily achieved with Security roles.

You can create a security role either from the PowerApps Admin Center or go to Solutions and scroll down to "Default Solutions" and then add new security role.

Once in the security role, go to the custom entities tab and scroll to your User Access table, set your desired permissions.
Assign this security role to whichever individual or group that needs access to the table

More details on security roles can be found in the official documentation
https://learn.microsoft.com/en-us/power-platform/admin/security-roles-privileges

Was this reply helpful? Yes No

Verified answer

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Jsmith2, for your use case, the best approach that you can take is using ADD security groups. and the Dynamic membership rules for groups in Azure Active Directory. Then assign security role to that AAD security group to access the the underline data. You will also share the app with that security group.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com