How to provide access on a specific row to a user who is not part of power platform environment?

(0) Share

Report

Posted on by vinayakb93

Hello Everyone,

I am looking for a solution for below problem statement

Issue: We have a migrated data from SharePoint list to dataverse table and created a canvas powerapps which is using the data from dataverse table. The table contains people picket field (lookup to MS Entra ID table). The requirement is whenever a record is created, the person who is added in the item details should also get access to the record for edit purpose. The user is not part of the environment, we are talking about providing access to the user on the record and app on the fly. The user should have access to only that particular record.

Is it possible to have row level security to a user (not part of environment, it can be anyone from organization) on a specific record on the fly provided user must not see other records from the table.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Jonathan Manrique 2,687 on at

Like (0)

Report

Re: How to provide access on a specific row to a user who is not part of power platform environment?

Hi @vinayakb93

Dataverse security is role-based, and you can use it at the user and team level.

Every time a user creates a queue, if you have a security role where security is user-based, you can achieve what you ask for. But important to be able to access you need a Power Apps Premium license. The user cannot see a record in the application if they do not have a license

https://learn.microsoft.com/es-es/power-platform/admin/wp-security

Was this reply helpful? Yes No
vinayakb93 2 on at

Like (0)

Report

Re: How to provide access on a specific row to a user who is not part of power platform environment?

I agree with your solution but here the problem is that the user is not part of my dataverse environment and I want to provide access to the user on a record on the fly (user may not be available in the users table as not part of environment but present in AD)
Every user in my organization have the premium license so its not a problem.
I am looking for a solution like item level unique permission to a user present in AD without getting concerned about having it in environment or not.
Any other solution based on my problem using power automate?

Was this reply helpful? Yes No
Jonathan Manrique 2,687 on at

Like (0)

Report

Re: How to provide access on a specific row to a user who is not part of power platform environment?

Hi @vinayakb93

For your approach, the ideal is to use Power Page, which allows access to authenticated users (inside and outside the organization) and then you control what they can see through the security roles and Power Page web roles.

Was this reply helpful? Yes No
Fubar 8,319 Super User 2025 Season 2 on at

Like (0)

Report

Re: How to provide access on a specific row to a user who is not part of power platform environment?

Agree that functionally Power Pages could work, but be mindful of licensing. If your user is an internal user (just not in your Dataverse environment), they will still need a license to access the data in Dataverse (e.g. you cannot just use Power Pages and treat them as a user that is External to your organization as this is different licensing - they still need to be licensed appropriately as an internal user).

Was this reply helpful? Yes No