web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / On Delete/Remove child...
Power Apps
Unanswered

On Delete/Remove child entity from sub-grid - Disassociate Parent (N to N relation)

(0) ShareShare
ReportReport
Posted on by 4

Hi All,

 

I am trying to achieve disassociation of a N to N entity.

Scenario:  Entity A(Parent) , Entity B(Child) they have N : N relationship. 

Entity C is a child of Entity B (1 : N) 

I am associating Entity B to Entity A (N:N) on addition of Entity C.

I want to remove Entity Association between A and B when C is removed/deleted. 

Is there a way to achieve this using Power flows? or are there any alternative methods to capture the entity before it gets removed/deleted.

I have the same question (0)
  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @Priya_Kondepudi,

    By "Power flow" I assume you mean Power Automate cloud flows. Yes it's possible using the Common Data Service (current environment) connector with an update trigger when Entity B is updated. Here are the high-level steps:

    1. On the trigger, add a column filter to filter on the lookup column/field of entity C so that the flow doesn't trigger on any update.
    2. On the trigger, add a row filter to filter when the lookup row is empty (e.g. "cr42sa_entityc eq null"). This will ensure to execute the following steps only when the lookup is cleared.
    3. Add an unrelate action to unasscoiate Entity B from A (or vice-versa)

    Hope this helps!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard