Power Apps

Dependent Multi Select Parent Drop Down Filteration

(0) Share

Report

Posted on by NS-10041416-0

184

Hi,

In the Form, I have three data cards

In one of the data card, I have parent drop down with multi selection.

I have a sharepoint list with lookup where respective items are being saved.

Now after selecting item1 and item2 in the multi selection drop down.

The dropdown1 inside a data card should populate w.r.t item1 items and

The dropdown2 inside a data card should populate w.r.t item2 items

For this I have applied the filteration in items of dropdown1

Filter('listname','lookupcolumnname'.Value in Parentdropdowndatacardvalue.SelectedItems.Value)
 
But all the values of the list are being populated

So please let me know if I am missing anything in the filteration.

Regards,

Sudheer

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

narayan225 2,547 Super User 2025 Season 2 on at

Like (0)

Report
@NS-10041416-0

I am using modern dropdown and combobox controls.

Combobox that allows multiple selection formula:

Items = 'listName'

Dropdown 1 formula that shows items based on first selection:

Items = Filter('list2Name',First(ComboboxCanvas1.SelectedItems).'User Email' = Employee.Email) //User Email field is from the first list and Employee.Email is from the second list.

Dropdown 2 formula that shows items based on last (2nd) selection:
Items = Filter('list2Name',Employee.Email = Last(ComboboxCanvas1.SelectedItems).'User Email') //Employee.Email is a person column in list 2 and User Email is from list 1.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
Hi @NS-10041416-0,

You can try this
Filter( 'listname', 'lookupcolumnname'.Value in Concat( Parentdropdowndatacardvalue.SelectedItems, Value, "," ) )

or if you want some degree of Delegation management
Ungroup( ForAll( Parentdropdowndatacardvalue.SelectedItems As _Data, Filter( 'listname', 'lookupcolumnname'.Value = _Data.Value ) ), Value )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
NS-10041416-0 184 on at

Like (0)

Report

Sorry @narayan225,

I cannot use combox box as form control as data doesn't get inserted.

So please guide me through the changes to be done for drop down which is in custom data card.

Regards,

Sudheer

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

@NS-10041416-0,

You cannot have multiple selections in a drop-down control - you need to use a Combo Box.

Was this reply helpful? Yes No
NS-10041416-0 184 on at

Like (0)

Report

Hi @WarrenBelz,

I tried the work around as suggested but didn't work out.

Filter('listname','lookupcolumnname'.Value in Concat(DropdownDataCardValue.SelectedItems,Value,","))

But I am able to notice 'We didn't find any data'.

Regards,

Sudheer

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

@NS-10041416-0,
As I mentioned, you need a Combo Box if you want multiple selections - the code I posted is valid if you use one of these and set it to Multiple Selection.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

Hi @NS-10041416-0,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No