Answered

Change owner of child record to owner of the parent record (Dataverse)

(1) Share

Report

Posted on by MichaelFo96

Hello together,

I try to set up a flow that changes the owner of all existing child records (e.g. Table "Assets") to the owner of the parent Records (e.g. Table "Accounts"). The relationship takes place in the field "Current Owner" which is a lookup N:1 relationship on the asset table to the account table.

Background: When the owner of an account changed in the past there was no inheritance to the child record and I has to clean the mess up.

I think the best way to do this is a manuall flow that list all accounts and all assets. Afterwards there should be an apply to each where it takes each asset and check if the owner of the asset and the account is not the same. If that is the case the owner should be changed.

In my mind it looks clear but I am currently unable to set up the flow correctly.

Could you please help me?

Thank you very much in advance.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Michael E. Gernaey 53,429 Super User 2025 Season 2 on at

Like (0)

Report

Hi

I will come back in a bit to answer, but one thing that should be looked into is Child Hierarchy, it is exactly for this situation so you aren't manually having to fix them.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi

Here is my blog about how to update the ownership records. Please have a look.

https://mydevexperience.wordpress.com/2024/07/27/how-to-change-owner-of-a-dataverse-record-using-power-automate/

Thanks

Was this reply helpful? Yes No
MichaelFo96 14 on at

Like (1)

Report

Hello FLMike,

I know about this Child Hierarchy topic and will adjust it after I cleaned up the database. But thanks for that information.

-------------

Hello abm abm,

thank you for the link. I used that "template" and it worked. Thank you.

Was this reply helpful? Yes No