Unanswered

Combo box selected items limit

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I've been struggling quite a lot to find a solution for this and I'm not sure wether it's possible. I have a combo box with N options and I'd like to set the maximum amount of how much choices the user can make in 10. I've tried to use this on the Disabled property: "If(CountRows(ComboBox3.SelectedItems) > 10,DisplayMode.Disabled,DisplayMode.Edit)" but this wouldn't allow the users to change their previous selection so it doesn't really fit my needs.

I appreciate any help, thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

v-monli-msft on at

Like (1)

Report

Hi @Anonymous,

Sorry but I cannot think of other ways to achieve your requirement. There is no such property that you could set for combobox control according to https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box. You might want to add an idea in the PowerApps Ideas forum, to ask for adding a property to limit the max selectable numbers of options in combobox control.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards,

Mona Li

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (4)

Report

Hi @Anonymous,

You can't hardcode it currently as there's no option for limiting, but you can lead the user to do it:

I would have the following triggered via the OnChange of your combo box:
If(
CountRows(ComboBox3.SelectedItems) > 10,
notify("Please choose no more than 10 items", notificationtype.error)
)

..then I would have the Displaymode for any Submit button have your
If(CountRows(ComboBox3.SelectedItems) > 10,DisplayMode.Disabled,DisplayMode.Edit)
That way they can't submit until they've fixed their error.

Let me know if that would be an acceptable workaround!

Cheers,
@iAm_ManCat

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Thanks for your help with this post and all the knowledge you've provided the PowerApps Community @iAm_ManCat

@Anonymous

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

You're welcome, always glad to help 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

I know this is an old post, but in case anyone runs into a similar issue, I thought of another possible solution. Set the OnChange property of the combobox to:
If(CountRows(Combobox.SelectedItems)>10, Reset(Combobox)
This will cause all 10 items to clear when the user attempts to select an 11th item. Not ideal, but it will enforce the desired limit. I tried creating a Gallery and setting its 'items' property to (FirstN,Combobox.SelectedItems,10) - Then setting the Combobox's DefaultSelectedItems to Gallery.AllItems. If it worked, that would result in perfect behavior -the Combobox would reset to the first 10 values when the user tried to select an 11th, but to the user it would simply appear they couldn't select an 11th option. Unfortunately, that creates a circular reference, which isn't allowed.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Ok - totally solved!

Set OnChange property of Dropdown to:
If(CountRows(Selections)=3,UpdateContext({Selections: Blank()}));If(CountRows(Dropdown.SelectedItems)>10,Reset(Dropdown));UpdateContext({Selections: Dropdown.SelectedItems.Value})

Set DefaultSelectedItems property of Dropdown to:
If(Not(IsEmpty(Selections)),FirstN(Selections,10)))

The effect is that attempting to select an 11th item makes the drop-down list close, and the 11th item is not added. The first 10 selections are still there. I'd suggest either using a Concat() to string together all of the selections and displaying with a label, or triggering an error message - so your user realizes they can only select 10 items.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

I've added this option as a new idea, as I think it should be added to the settings of a Combo box:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Add-a-maximum-selectable-items-option-to-Combo-box/idi-p/317677
It would make our life a bit easier

Was this reply helpful? Yes No
Murderbot 132 on at

Like (0)

Report

This worked great for me, just one question: why is selections set to 3?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello,

May be this will help to restrict number of selections in a ComboBox.
Step 1: In Screen OnVisible property,
OnVisible
ClearCollect(DropdownData, {.......});
If(IsEmpty(Items), ClearCollect(Items, First(DropdownData)));

Step 2: Insert a ComboBox. Assign it's properties as follows,
Items DropdownData

OnChange ClearCollect(Items, ComboBox.SelectedItems);
If(CountRows(ComboBox.SelectedItems)>10,Reset(ComboBox));

DefaultSelectedItems FirstN(Items,10);

In this approach, It won't allows the 11th Selection.🙂

Was this reply helpful? Yes No
CharlesPP 187 on at

Like (2)

Report
I've just come across this topic, so I'll take the liberty of giving you my solution, which is close to those proposed previously, but which I find simpler and easier to read.

In the "OnChange" property :

With( { _nbMaxItems: 15 }, If(CountRows(Self.SelectedItems)>_nbMaxItems, Notify($"It is only possible to filter on a maximum of {_nbMaxItems} items simultaneously.", NotificationType.Error); UpdateContext({locComboSelected: FirstN(Self.SelectedItems, _nbMaxItems)}); Reset(Self); ); )

In the "DefaultSelectedItems " property :

locComboSelected

Have a nice day !
Charles

Was this reply helpful? Yes No