Due to missing inheritance rules, we have 250,000 child data records (customer assets) in our system which have a different owner to the parent data record (account).
I would now like to change the owner of the child data record to the owner of the parent data record as efficiently as possible.
To do this, I have created a Power Automate Flow with a manual trigger which looks at all accounts and customer assets and compares the owners. If there is a discrepancy, it changes the owner.
However, I am unsure whether this flow is performant as it involves ~250,000 data records which would be changed.
Does anyone have an idea how else it could be solved?
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.