Deleting Related Child Records

[krispag]

I have five screens.

• BrowseScreen with gallery listing parent records
• DetailScreen1 showing selected parent record details. There is a child gallery at the bottom of this screen filtering related child records. When a child record is selected, the user navigates to DetailScreen2.
• EditScreen1 allowing user to edit selected parent record details
• DetailScreen2 showing selected child record details.
• EditScreen2 allowing user to edit selected child record details
• BrowseScreen has add record icon to add new parent record
• DetailScreen1 has back arrow icon to return to BrowseScreen, trash icon to delete selected parent record, and an edit icon to edit the selected parent record. On the child gallery, there is a plus icon to add new child record which is related to selected parent record
• EditScreen1 has X icon to discard changes and go back to previous screen, and a checkmark icon to save changes to parent record.
• DetailScreen2 has a back arrow icon to return to DetailScreen1, trash icon to delete child record, and a edit icon to edit child record
• EditScreen2 has X icon to discard changes and go back to DetailScreen2, and a checkmark to save changed to child record

EVERYTHING WORKS GREAT!

Goal, when selected parent record is trashed from DetailScreen1, delete all related child records.

Browse Screen

DetailScreen1

DetailScreen2 (when related child record selected)

Your assistance is greatly appreciated.

[WarrenBelz]

Hi @krispag ,

You have not included the key (linking) field names, but you would do something like this

RemoveIf(
   ChildList,
   ChildKeyField = ParentKeyField
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[krispag]

@WarrenBelz 

The child gallery items...

Sort(Filter(Reports, 'Report Ref ID'.Id=varParentItem.ID), 'CFS Number', SortOrder.Descending)

When they select a parent record from BrowseScreen, I set a variable called varParentItem.ID

The OnSelect behind the parent record trash icon is

Remove([@Patrols], BrowseGallery1.Selected); If (IsEmpty(Errors([@Patrols], BrowseGallery1.Selected)), Back())

Do either of these help?

I am obviously not well versed here.

[WarrenBelz]

Hi @krispag ,

Firstly what is your data source. From what I can see the field 'Report Ref ID'.Id in the child matches the ID field in the parent.

[krispag]

The data source for the parent is Patrols. The data source for the child is Reports.

[WarrenBelz]

@krispag ,

Sorry I meant data source type (SharePoint/Dataverse/SQL etc). Also did you try with the two fields I suggested ?

[krispag]

SharePoint lists. Once again, the current OnSelect behind the parent record trash icon is

Remove([@Patrols], BrowseGallery1.Selected); If (IsEmpty(Errors([@Patrols], BrowseGallery1.Selected)), Back())

Basically just deleting the parent record from Patrols that was selected on the primary browse gallery on the home screen. User selects a record from home screen gallery, go to detail screen to view, child gallery is at the bottom displaying the child records.

[WarrenBelz]

@krispag ,

This makes is easier (sort of), but I still need to know the two fields that "link" the parent and child lists. You have said the Items of the child gallery is

Sort(
   Filter(
      Reports, 
      'Report Ref ID'.Id = varParentItem.ID
   ), 
   'CFS Number', 
   SortOrder.Descending
)

 I am assuming (as before) that the "link" on the parent is the ID field. What type of field is 'Report Ref ID' in Reports ? Please do not tell me it is a Lookup column as that creates Delegation issues.

[krispag]

After your comment about Lookup column, I spent a great deal of time changing that column to Text. Here's the scoop. When a user creates a new, or selects an existing parent record, I set the varParentItem.ID. Then, when the user navs to the selected parent detail screen, the child gallery is at the bottom and it filters the records to show those where the Patrol ID (a text column) in the list REPORTS matches the parent record ID as set in varParentItem.ID. All of that is working. If the user taps the add child record icon from the parent record view detail screen, the new edit form for the child record sets the default value for Patrol ID in REPORTS to equal that of varParentItem.ID (the parent record ID). Again, all works great!

So to answer your question, parent list is PATROLS, child list is REPORTS, the common value is the PATROLS record ID which I am storing in the Patrol ID, now a text column, in REPORTS.

We simply need the correct OnSelect formula for the parent record view detail screen trash icon so that in addition to deleting the selected item from the parent browse gallery, we also delete any related child record.

The current trash icon OnSelect formula is...

Remove([@Patrols], BrowseGallery1.Selected); If (IsEmpty(Errors([@Patrols], BrowseGallery1.Selected)), Back())

I am thinking it would be safer to not use BrowserGallery1.Selected, but rather use the varParentItem to delete from PATROLS and where REPORTS, Patrol ID equals that varParentItem.

[WarrenBelz]

@krispag ,

Yes that was a good idea for many other reasons than this. as mentioned previously, the syntax required should be

Remove(
   [@Patrols],
   BrowseGallery1.Selected
);
RemoveIf(
   Reports,
   'Patrol ID' = varParentItem.ID
);
If(
   IsEmpty(Errors([@Patrols])) && IsEmpty(Errors([@Reports])),
   Back()
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps