how to patch multiple selections checkbox gallery inside a gallery in powerapps

159 views Asked by At

need your help please...

I have i created a form in powerapps but without using form control. i used a gallery control instead. so i am using forall and patch function to write back all the answers to sp list. The issue is, theres a couple of questions that im using a checkbox and the user can multiselect the answer. The problem is, the values of the multiselected box does not patch the values in SP list. the result is blank.

For my checkbox control, i am using a gallery so i can have multiple checkbox (so i have a gallery inside a gallery). the Items property my gallery with checkbox control is:

Split(ThisItem.Multiselect, ";")

and here is the function for my button control onselect property to patch the data:

ForAll(
    gal_Template.AllItems,
    Patch(
        'Site Visit Form Results',
        Defaults('Site Visit Form Results'),
        {
            'Pharmacy Location': dd_Pharmacy.SelectedText.Value,
            'RDO/RGM': lbl_rdoRgm_Val.Text,
            PIC: lbl_PIC_Val.Text,
            SiteVisitDate: dp_SiteVisitDate.SelectedDate,
            Title: btn_section.Text,
            Questions: lbl_Questions.Text,
            Answers: radio_YN.SelectedText.Value & txtInpt_Note.Text & Checkbox1.Value,
            Comment: txtInpt_ComntforNO.Text
        }
    )
)

i have tried this function below but also giving me blank results

ForAll(
    gal_Template.AllItems,
    Patch(
        'Site Visit Form Results',
        Defaults('Site Visit Form Results'),
        {
            'Pharmacy Location': dd_Pharmacy.SelectedText.Value,
            'RDO/RGM': lbl_rdoRgm_Val.Text,
            PIC: lbl_PIC_Val.Text,
            SiteVisitDate: dp_SiteVisitDate.SelectedDate,
            Title: btn_section.Text,
            Questions: lbl_Questions.Text,
            Answers: radio_YN.SelectedText.Value & txtInpt_Note.Text & if(Checkbox1.Value = true,""),
            Comment: txtInpt_ComntforNO.Text
        }
    )
)
1

There are 1 answers

5
Sam Nseir On

You will need something close to:

Concat( Filter(YourCheckBoxGallery.AllItems, Checkbox1.Value), Checkbox1.Text, ";")