Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Record owner and record privileges for specific users

I'm trying to implement my first model-driven powerapp based on CDS.


I have an entity "Insurance" for which I want to set the following security model:
A team of 5-10 people should be able to edit all insurance records.
In addition, one or two people should be defined as editors per record. That varies from record to record.


I have set the ownership of the entity to user/team.
I created an owner team with the appropriate members and I created an appropriate security role for this team.


Is it possible to set the field "owner" automatically to the corresponding team value (instead of the current user)? The field "owner" shouldn't be able to be changed and, ideally, the field should not be displayed to the user.


Is it possible to define a field which enables selected users access to the specific entry? How can this be implemented?
As far as I've read that, it should be possible with auto-created access teams. But is that the preferred way for such a simple requirement?

Solution Supplier
Solution Supplier

Taking each in turn:

1) Yes, you can create a workflow process to automatically set the owner to a team

2) Using teams is probably the simplest way, and I'd say it is slightly easier to use owner teams, as you can assign the record to the owning team (as per 1 above), and if the owning team is in a security role that grants Update access at the user level on this entity, this should do what you want

An alternative is to use sharing. This can be automated via a workflow, but needs an extension -

Thanks for your response.


@ 1) Is it also possible to hide the field in this case? The owner field is a required field by default.


@ 2) The additional privileged user is unknown until a member of the "insurance team" creates a new record. Only the creator knows who should get additional access to this new record.

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Kudoed Authors
Users online (74,656)