Unanswered

Add a checkbox in a form for multiple selections where the items are based off a Distinct Result.

(0) Share

Report

Posted on by SenoirB

I am attempting to create a CheckBox gallery in a form where the Checkboxes are generated from a Distinct result. I am having issues with the collections.

This is what I have currently, which is a sad alternative.

This is the Gallery (in the Commodity card) Items:

Sort(Distinct(Filter(ServiceRequestTypes, Title = drpContainerType.Selected.Result),Commodity),Result)

This is the checkbox in the gallery located in the Commodity card On Select:

Collect(colDockServices, ThisItem.Result)

This is the checkbox in the Commodity gallery OnUncheck:

Remove(colDockServices,{Value:chkboxCommodity.Text})

The Update field on the Commodity card is based off a hidden Text lablel that Concats the choices.

Default on Commodity card is ThisItem.Commodity.

It's a mess I know, please HELP😄

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @SenoirB ,

The first two look fine - for the last

Remove( colDockServices, ThisItem )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
SenoirB 72 on at

Like (0)

Report
Copy link

Link copied!
Hello WarrenBelz,

When I change the OnUncheck to
Remove( colDockServices, ThisItem )
I get two errors.
1. Incompatible type. The collection can't contain values of this type.
2. The function 'Remove' has some invalid arguments.

Was this reply helpful? Yes No
WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@SenoirB

Is your checkbox inside the gallery? If so, that should work if not

RemoveIf( YourCollectionName, Result = YourGalleryName.Selected.Result )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @SenoirB ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
SenoirB 72 on at

Like (0)

Report
Copy link

Link copied!

Hello. After enough frustration, and before your last suggestion, I had reverted to a combo box with multiple selection on. I may revisit this again if the combo box does not turn out to be as user friendly. Thank you for your suggestions.

Was this reply helpful? Yes No