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
Copy link

Link copied!
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 Moderator on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No