Patching Nested Child Gallery back to SharePoint

[Dorinda]

@RandyHayes @WarrenBelz 

Rather than keep beating my head against a wall I am begging for help.

I have a canvas app that has a form that creates a record in one SharePoint list.

I have Gallery1 that is a list of Hazards that creates a collection with this code on the onselect of a button in the gallery :

Select(Parent);
If(
    IsBlank(LookUp(colParentGalleryData, Title = ThisItem.Title)),
    Collect(
        colParentGalleryData, 
        { 
            Title: ThisItem.Title, 
            Examples: ThisItem.Examples,
            JSRAction: "Safe", // Placeholder
            HazardIssue: "None", // Placeholder
            FurtherAction: "None", // Placeholder
            CRNumber: "0", // Placeholder
            Recognition: "", // Placeholder
            OverallComments: "", // Placeholder
            Data: Table()  // Initialize with an empty table
        }
    ), 
    RemoveIf(colParentGalleryData, Title = ThisItem.Title)
);

this is where the frustration starts.  I have a parent/child nested gallery that is tied to the collection referenced above.

This is on the ParentGallery

SortByColumns(
    GroupBy(
        colParentGalleryData,
        "Title",
        "Examples",
        "Data"
    ),
    "Title",
    SortOrder.Ascending
)

And this is on the ChildGallery

ThisItem.Data

When the form and all of the gallery information is completed I have two things that should be happening.

The submit button on the screen has this:

Patch(
  'Job Site Review(Testing)',
  LookUp('Job Site Review(Testing)', ID = CurrentFormID),
  {
    SafetyMeetingGroup: DataCardValue1.Selected.Title,  
    'Location Choice': DataCardValue4.Selected.Value,
    'Location of Observation': DataCardValue7.Selected.ChildLocation
  }
);

and on the OnSuccess of the form I have this 

ClearCollect(colChildItems, ChildGallery.AllItems);

// Loop through each parent record
ForAll(
    ParentGallery.AllItems,
    
        Patch(
            'Job Site Review(Testing)',
            Defaults('Job Site Review(Testing)'),
            {
                'Reviewer 1': {
                    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                    Claims: "i:0#.f|membership|" & DataCardValue2.Selected.Email,
                    DisplayName: DataCardValue2.Selected.DisplayName,
                    Email: DataCardValue2.Selected.Email,
                    Id: "",
                    JobTitle: "",
                    Department: "",
                    Picture: ""
                },
                'Review Date': DataCardValue59.SelectedDate
            }
        ).ID
    );
    
    // Nested loop to patch each child record for the current parent
    ForAll(
        colChildItems,
        Patch(
            JobSiteReviewHazards,
            Defaults(JobSiteReviewHazards),
            {
                MasterID: CurrentFormID,
                JSRAction: JSRAction,
                HazardIssue: HazardIssue,
                FurtherAction: FurtherAction,
                CRNumber: Value(CRNumber),
                Recognition: "",
                OverallComments: ""
            }
        )
    )

What is happening is the first patch is working just fine but nothing is patching with the second for the ChildItems.  I am stumped and I have been looking for days for this solution.

Any help would so be apprecaited.

[Dorinda]

My hero thank you for the help I truly appreciate it.!!

[Dorinda]

@cwebb365 so I logged in this morning and nothing was saved or published, I lost it all and have no idea what we did!  I am devasted!!

This is horrible.  PowerApps has been white screening all week and I thought I had it save.  I am so screwed!!