Power Platform Community Forum Thread Details

Hello all,

I have been building a multi screen app and all the screens are connected with each other in the SQL Server Database. Think it as a tree structure, so A > B > C > D > E > F, in this case A is the parent of all and B is child of A and C is child of B etc...

What i do want to achieve is when I delete a Parent Record for example C, I would like to automatically delete D,E,F also. so to achieve this i used this formula but it works for the parent but not for the child;

// Remove the selected article
Remove(Articles, ExistingArticle_Gallery.Selected);
// Remove associated records in ArticlesLookup
RemoveIf(Article_Volumes, Article_Parent_LookUp_ID = ExistingArticle_Gallery.Selected.Article_ID);
 
does any of you know a solution to this?
 
Thanks in advance