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
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
my case need to do this within one list and i cannot split them.
is there any way to fix that ?
thanks in advance
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.
Could you please try again with it?
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.
Check it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand