cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Cascading filtered drop down

Hi,

 

i've tried to cascad the thired drop down from the second byt i got error.

 

my cas is: i've one list (single text) as

Capture.PNG

 

what i did, i filtered the Floor based on  selected Location as "Filter('Checklist MD',Title=Dropdown1.Selected.Value).Floor" and it's working fine.

 

when i tried to filter the Item Name based on selected Floor using "Filter('Checklist MD',Title=Dropdown1.Selected.Value && Floor=Dropdown2.Selected.Value).Item_x0020_Name" i got this eroor Untitled.png

 my case need to do this within one list and i cannot split them.

 

is there any way  to fix that ?

thanks in advance

4 REPLIES 4
Community Support Team
Community Support Team

Re: Cascading filtered drop down

Hi ahramadan,

 

According to your description, I create a similar app with three Drop down controls.


The data source is SharePoint list.


For Dropdown1, set its Items property as: ProjectEmail.Title


For Dropdown2, set its Items property as: Filter(ProjectEmail,Title=Dropdown1.Selected.Value).ID


For Dropdown3, set its Items property as: Filter(ProjectEmail,Title=Dropdown1.Selected.Value&&ID=Dropdown2.Selected.Value).Single


I don’t get the error message you mentioned.

3.PNG

 

Could you please try again with it?

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Cascading filtered drop down

Thank you Mabel Mao,

 

i tried but the same. in your example you are using ID feild is this might be releted to the cascading?

 

my three formulas are :

 

1- Distinct('Checklist MD', Title)

2- Filter('Checklist MD',Title=Dropdown1.Selected.Value).Floor

3- Filter('Checklist MD',Title=Dropdown1.Selected.Value && Floor=Dropdown2.Selected.Value).Item_x0020_Name

 

when i run 1 & 2 its working but when add the thired dropdown filter i getting the error on dropdown 2 and dropdown three.

 Capture.PNG

thank you

Anonymous
Not applicable

Re: Cascading filtered drop down

Any Help here??

QSS
Level: Power Up

Re: Cascading filtered drop down

Try this: 

1- Distinct('Checklist MD', Title)

2- Filter('Checklist MD',Title=Dropdown1.Selected.Value).Floor

3- Filter('Checklist MD',Title=Dropdown1.Selected.Value).Item_x0020_Name

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,856)