Make Combo box visible if multiple selections are made in another combo box

(0) Share

Report

Posted on by LS579

134

Hello,

I am having trouble getting a combo box to show if "Other" is selected as well as "Other" and other selections in another combo box.

The functionality of this form is to select an office location that you would like the employee to work from. There are 11 main locations that should be considered first and then an "Other" option if you would like to get approval for any of the other office locations. Right now, I have "comboboxOther" showing if just "Other" is selected from "comboboxLocations", but I need "comboboxOther" to show if "Other" and any of the other locations are selected.

Please see photos. Screenshot 2024-02-26 120829.png Screenshot 2024-02-26 121015.png Screenshot 2024-02-26 121120.png

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LS579,

I assume that your current Visible property is most likely similar to:

//Change .Value if needed "Other" in comboboxLocations.SelectedItems.Value

In addition to this logic, we will have to check whether at least 2 selections have been made and Other is one of those:

//Change .Value if needed "Other" in comboboxLocations.SelectedItems.Value && CountRows(comboboxLocations.SelectedItems) > 1

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!
LS579 134 on at

Like
a
(0)

Report
Copy link

Link copied!
Actually, my Visible property is set to:
If(cboLocations.Selected.Value = "Other", true, false)
Would your code above work the same with this? Or should I change it to what you have exactly?
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@LS579,

Thanks for the info! 😊

Your current code will not work as expected when allowing multiple selections. '.Selected.Value' is used to access the selection of a single-select combobox. Using this approach with a multi-select combobox will result in only the last selected value being evaluated.

Could you try the following code:

//Returns true of Other is selected & at least 1 additional selection has been made "Other" in cboLocations.SelectedItems.Value && CountRows(cboLocations.SelectedItems) > 1

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!
LS579 134 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked! I did have to change the "> 1" to ">= 1" because it wasn't showing when just "Other" was selected, but now it works perfectly! Thank you so much for your help!