Unanswered

Cascading Dropdown menu

(0) Share

Report

Posted on by Edymac11

Hello everyone,

I have 13 dropdown menus which get their items from a single sarepoint list called CrewNames, I would like to hide items in the dropdown menus if they have already been selected in any of the other dropdown menus, so I cant have duplicte menu items.

I've been googling it and I cant find a solution that matches my senario.

Any help would be much appreciated

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

NSBI 20 on at

Like (0)

Report
This will be quite complicated because of the number of dropdowns you have but there is a pretty structured way to do the filtering. Assuming the column being used of the CrewNames list is called "CrewMember" and is a person type field.

In the items property of each of your dropdowns:
For the first dropdown:

Filter( CrewNames, IsBlank(Dropdown2) Or IsEmpty(Dropdown2) Or Not(CrewMember.DisplayName = Dropdown2.Selected.CrewMember.DisplayName), IsBlank(Dropdown3) Or IsEmpty(Dropdown3) Or Not(CrewMember.DisplayName = Dropdown3.Selected.CrewMember.DisplayName), IsBlank(Dropdown4) Or IsEmpty(Dropdown4) Or Not(CrewMember.DisplayName = Dropdown4.Selected.CrewMember.DisplayName), IsBlank(Dropdown5) Or IsEmpty(Dropdown5) Or Not(CrewMember.DisplayName = Dropdown5.Selected.CrewMember.DisplayName), IsBlank(Dropdown6) Or IsEmpty(Dropdown6) Or Not(CrewMember.DisplayName = Dropdown6.Selected.CrewMember.DisplayName), ...//And so on till you get all 12 of the others covered

Then for dropdown 2:

Filter( CrewNames, IsBlank(Dropdown1) Or IsEmpty(Dropdown1) Or Not(CrewMember.DisplayName = Dropdown1.Selected.CrewMember.DisplayName), IsBlank(Dropdown3) Or IsEmpty(Dropdown3) Or Not(CrewMember.DisplayName = Dropdown3.Selected.CrewMember.DisplayName), IsBlank(Dropdown4) Or IsEmpty(Dropdown4) Or Not(CrewMember.DisplayName = Dropdown4.Selected.CrewMember.DisplayName), IsBlank(Dropdown5) Or IsEmpty(Dropdown5) Or Not(CrewMember.DisplayName = Dropdown5.Selected.CrewMember.DisplayName), IsBlank(Dropdown6) Or IsEmpty(Dropdown6) Or Not(CrewMember.DisplayName = Dropdown6.Selected.CrewMember.DisplayName), ...//And so on till you get all 12 of the others covered

And so on for each dropdown box.

A couple of other notes. Doing it this way means that it won't matter the order in which users fill in the dropdowns, each time they open a dropdown, they will only see the crew that are left. Bonus tip- you can use the same filtering logic to use dropdowns as filters for galleries.

Was this reply helpful? Yes No
Edymac11 4 on at

Like (0)

Report

Thank you @NSBI

I'll get on it now and let you know how it goes

Regards

Ed

Was this reply helpful? Yes No
Edymac11 4 on at

Like (0)

Report

Hi @NSBI

I can't get this to work, I think i've left out some important information, so i'll start again,
My edit Form is from my main data source (Area 4 Works programme - concept) that I will save to, the dropdown boxes are combo boxes because the columns on my main data source are choice columns (I can change these).

I want the combo boxes menu to get the list from my sp list called CrewNames as well as filter so i cant select the same name more than once.
the error messages i am getting with your formula is;

IsEmpty -Invalid argument (Control), expecting table value instead
Or - Delegation warning
Not - The "Not" operation is not supported by this connector
= - Incompatible types for comparison. these types can't be compared: Text, Error.
Name isn't valid. 'CrewMember' isn't recognised.

its not in a gallery its in an edit form.

sorry for the confusion.

Regards

Ed

Was this reply helpful? Yes No
NSBI 20 on at

Like (0)

Report
@Edymac11

Ahh I see.

First off you'll need to do some adjusting to what I provided to make it match the actual names of things in your app.
Dropdown1,2,3,4,5...etc replace with whatever the combobox controls are called. As it is in a form they will almost certainly be in the format of "DataCardValueX" (where X is some number). Look in the tree view to find these or click on each combobox and see what they are called.
Change 'CrewNames' to whatever the column of people's names are from the SharePoint List. It might be the title column but I can't tell without being hands on with the list.
What data type is the column where the names are stored? I assumed it was a person type lookup column. if it is just text then you can drop the '.DisplayName' from everywhere
Secondly I did make a small mistake.
In each of the IsBlank and IsEmpty funtions it should be DropdownX.Selected
So as an example, taking into account the points above each line in the filter should be something like
IsBlank(DataCardValue1.Selected) OR IsEmpty(DataCardValue1.Selected) OR Not(ColumnName.DisplayName = DataCardValue1.Selected.ColumnName.DisplayName),

Good Luck

Was this reply helpful? Yes No