Unanswered

Save values from Select All checkbox to collection and patch it to db

(0) Share

Report

Posted on by CU10090150-0

I have a Select All option in a container along with check boxes where some locations are present. I have to choose all the checkboxes and save it in SQL using patch function. I was able to do save the single selection of check boxes and patch it to sql. But I have placed the Select All check box outside the gallery that has locations so Iam unable to use Thisitem.marketing_location.

For single select I use the following code

in Oncheck property to create collection colinput-

Collect(colinput,{region_c:Gallery5.Selected.Value,market_c:ThisItem.Marketing_Location})
Patch function used is -
ForAll(colinput,
Patch(data_source,Defaults(data_source),{region:region_c,market_location:market_c,submitted_by:User().Email,submitted_time:Now(),status:"New"}));Clear(colinput);

The left side region gallery is gallery5. and the right side gallery6.

How to save the values from all check boxes into a collection and patch it to sql?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Hi CU10090150-0,

You can do this using the following steps.

For the Default property of all your Location CheckBoxes:

If(SelectAllCheckBox.Value = true, true, false)

This will give you the following behavior in your app:

OnSelect property of each Item:

Reset(SelectAllCheckBox)

OnCheck Property of SelectAllCheckBox:

ClearCollect( colinput, { region_c: Gallery5.Selected.Value, market_c: Concat( Gallery6.AllItems, Value, ", " ) } )

This will create a collection like this:

OnCheck property of the Items remains the same:

Collect(colinput, {region_c:Gallery5.Selected.Value, market_c:ThisItem.Marketing_Location})

Your Patch function will remain the same.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Suggested answer

CA1105 545 Super User 2025 Season 2 on at

Like (0)

Report
User below to check all the checkboxes
If(SelectAllCheckBox.Value, true, false)

Was this reply helpful? Yes No