Power Platform Community Forum Thread Details

I have this collection named colMealItems it was trim to make a checklist now I want the below to follow.

✅ When a checkbox is checked/unchecked, it patches immediately
✅ When navigating away and back, the checkboxes must stay as previously selected
✅ User can continue where they left off (no reset, no lost progress)

this is my code for trim collection.

With({
cleaned:Substitute(Substitute(Substitute(Substitute(uplift.Text,","," "),Char(10)," "),Char(13)," "),Char(9)," ")},ClearCollect(colMealItems,ForAll(MatchAll(cleaned,"(?i)\b\d+\s*[A-Z]{4}\b"
),{MealName:Upper(Substitute(ThisRecord.FullMatch," ","")
),IsChecked: false })))
this is my code for patch i want to change it
Patch(  BeltPlanAutomated,   ThisItem,  { 'Selected SPML': Coalesce( Concat(Filter(galMealItems.AllItems, chkMeal.Value), MealName, ", " ), "None") });



 

Categories:

Building Power Apps

Hello @jayceeb,

Please try with below approach:

Upon selection of uplift (On Select Property); - Gallery

UpdateContext({_selectedItem:ThisItem});
//This will help us to update the item when the click on checkbox


With(
    {
        cleaned: Substitute(Substitute(Substitute(Substitute(uplift.Text, ",", " "), Char(10), " "), Char(13), " "), Char(9), " ")
    },
    ClearCollect(
        colMealItems,
        ForAll(
            MatchAll(cleaned, "(?i)\b\d+\s*[A-Z]{4}\b"),
            {
                MealName: Upper(Substitute(ThisRecord.FullMatch, " ", "")),
                IsChecked: !IsBlank(LookUp(ThisItem.'Selected SPML', MealName = Upper(Substitute(ThisRecord.FullMatch, " ", ""))))
            }
        )
    )
)

Default Selection:

Default Property of the checkbox

ThisItem.MealName in colMealItems.MealName

Put below code on Check/Uncheck of checkbox:

// Update the local collection
UpdateIf(
    colMealItems,
    MealName = ThisItem.MealName,
    { IsChecked: chkMeal.Value }
);

// Patch immediately to Dataverse
Patch(
    BeltPlanAutomated,
    _selectedItem,
    {
        'Selected SPML': Coalesce(
            Concat(
                Filter(colMealItems, IsChecked),
                MealName,
                ", "
            ),
            "None"
        )
    }
)