Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

how to cascade update the ownership of related records when the ownership of the main record changes

(0) ShareShare
ReportReport
Posted on by 593

Dear,

 

What would be the best way to update the owner of *all* related records when the ownership of a record changes?

In our case we have one specific "master" (custom) table, that has multiple one-to-many relationships; if a record in the master table changes owner, all related records in all the other tables should be changed to the same new owner...

Best solution would be something that would work "automagically" without editing when, in the future, a new one-to-many relationship is added to the master table.

 

Thanks,

Koen

  • KoJaPD Profile Picture
    KoJaPD 593 on at
    Re: how to cascade update the ownership of related records when the ownership of the main record changes

    @ChrisPiasecki thanks, I had no idea the "Assign" relationship behavior was meant for that. I was thinking too complicated while I have been using this cascade thing since long time, but never for the ownership...

  • Verified answer
    ChrisPiasecki Profile Picture
    ChrisPiasecki 6,389 on at
    Re: how to cascade update the ownership of related records when the ownership of the main record changes

    Hi @KoenJanssensPD,

     

    You'll have to go into each individual one to many relationship on your master table in the maker portal and set the relationship behavior for Assign to either Cascade All or Cascade Active. There's no "automatic" way to set all relationship behavior this way at once without doing some custom coding. I believe the behavior is set to cascade all by default though. 

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics