You’re offline. This is a read only version of the page.
Hello
I am using a Canvas app connected to a table in the Dataverse.
When my users add new records, the Owner field shows their name.
I'd like the Owner field to be a team. The goal is that if people change from a business unit to another, the records stay in a team.
I know there are Owner/Access/AAD/O365 teams that exist but I'm not sure how this fits with my requirements.
Any help is appreciated! Thanks!
@Anonymous ,
In power automate use list rows action of dataverse for Teams table. Generate fetch xml from advanced find. Attached screenshot below.
Remove uiname, uitype and in value pass dynamic "Owning User (Value)" is nothing but unique identifier which you get from trigger stage of the flow(create of record). Set Row count to 1 in list rows action, hoping user belongs to one team. If not loop and get the required team.
In select columns include team id and add another action to update owner of the record.
If you are not familiar with using fetch xml in power automate. Please find below link
https://carldesouza.com/use-fetchxml-the-in-power-automate-cds-connector-for-list-records/
If it answers your question, please mark it as solution.
Regards,
Prakash
Let's say User A is part of Team A, then I want the Flow to change the ownership of the record to Team A.
If User B, who is part of Team B adds a record, then the Flow would have have to change the ownership of the record to Team B.
In other word, it should be able to detect the Team the user is in and change the ownership of the record to that Team right away.
@Anonymous ,
Do you want to find user's team or want to associate user to a team?
Sure but I would need the flow to be able to determine that User X belongs in Team X dynamically. How can I do that?
@Anonymous ,
Using power automate create automatic flow, that triggers when new record gets created. Update owner to a team.
Even if user moves from one business unit to another still that record belongs to team not to a user. Whoever part of that team will have access to that record based on security role.
If it answers your question, give kudo and mark it as solution.
Regards,
Prakash
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (