Unanswered

Dynamic Row Level security for a Dataverse Table

(0) Share

Report

Posted on by ezFlow

100

Scenario:
- Internal staff will created Purchase Order Records in a Dataverse table, with a field to capture the Vendor and other details.
- Vendors are setup as AD guest (external) users and will login via a Model Driven App, to see their item.
How can I secure the rows so the Vendors can only see their own related records.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @ezFlow

The primary approach I would utilize to accomplish this would be to utilize an Access Team that you can assign the vendor when they are setup in the lookup field on the record. You can utilize a real time workflow to add the vendor to the access team dynamically.

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-access-teams-owner-teams-collaborate-share-information

https://www.azamba.com/2018/02/15/how-to-enable-access-teams-in-microsoft-dynamics-365-for-sales-crm-share-records/

Was this reply helpful? Yes No
ezFlow 100 on at

Like (0)

Report

Thank you for validating my thoughts. I was thinking of creating the Vendor table and have a flow assign ownership.

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @ezFlow,

Just a note that Access teams allow the ownership of the Purchase Orders to stay with an internal team / owner and the Access team allows you to assign the Vendor to the record with specific rights (without being the owner of the record).

Was this reply helpful? Yes No