Deactivate the parent record and the related active child records

(0) Share

Report

Posted on by EBMRay

905

Hello,

Upon deactivation of the parent record in a table, I want to deactivate all the child records related to the parent. as I want to set their status to Inactive.

I believe there is no OOB feature that does that and it requires a custom plugin/workflow.

What will be logic to get all child records related to the parent entity in a query from different tables and deactivate them in bulk?

Can someone provide an example or documentation guidance to achieve the above?

Any help is greatly appreciated.

Best regards,

EBMRay

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (3)

Report

Hello,

If you're ok with Async processing I would say the easiest way to design the Power Automate flow. You can see a good example here - carinaclaesson.com/.../

If you want this to happen in a sync way you will have to use a plugin - himbap.com/.../

Was this reply helpful? Yes No
Suggested answer

Sayen Zhang on at

Like (0)

Report

Hi EBMRay,

If you want to deactivate all contacts related to an account whenever the account is deactivated.

You can try this solution without having to write any code: How to cascade activate / deactivate (SetState) in CRM - Microsoft Dynamics CRM Community

Hope this link help you!

Best Regards,

Sayen Zhang

Was this reply helpful? Yes No