Solved: Repeating Parent/Child Galleries a real humdinger!!

@RandyHayes @WarrenBelz

Ok I have a humdinger or a problem. I have a parent/nest child gallery with repeating table which work just fine, however I am using a button to add the whole thing all over again.

but when I click on the Add Org button which has this code on it

Collect(
    colOrganizations,
    Defaults(Organizations)
)

I am getting this

It is not clearing the previous selections from the first Org

this is the code for the Add Task button

Set(currentOrganization, galOrganizations.Selected.Name);


Collect(
    colSubOrgs,
    {
        ID: GUID(),
        Sub_Org_Name: "",
        TaskStatusDescription: "",
        Task_Org_Status: "",
        Parent_Org_Name: currentOrganization,
        TaskManagerID:cxtManager,
        isNew: true
    }
);

and here is the code for the items of the galChildren

SortByColumns(
    Filter(
        colSubOrgs,
        Parent_Org_Name = currentOrganization
    ),
    "isNew", 
    SortOrder.Ascending,  
    "ID", 
    SortOrder.Descending  // Newest saved tasks at the top
)

I am not sure how to get this to repeat the setup but not copy the previous selections

Categories:

Using Apps Using Formulas

General Questions