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

(0) Share

Report

Posted on by KoJaPD

597

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
KoJaPD 597 on at

Like (0)

Report

@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...

Was this reply helpful? Yes No