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

Re: Record owner and record privileges for specific users

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 -

Frequent Visitor

Re: Record owner and record privileges for specific users

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


Microsoft Ignite

This will be a conference that you do not want to miss!


New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (3,408)