Hi All,
so i wanted to created a cascading drop down field for a location list but when i use the filter function it only give me the first result.
Country | location |
UK | buckingham palace |
UK | victoria station |
Germany | Bremen |
Italy | Rome |
Italy | Venice |
Italy | Turin |
Filter(Listname, Country = DDCountry.selected.value)
so for example.
if i look for Italy i only get Rome as my only result.
thank you in advance for the help.
Solved! Go to Solution.
Hi @Ash2,
Do you want to filter the location dropdown based on the country dropdown selected?
Could you please tell me that:
There are many contradictions in your description, if you set the country drop down Items as below, you should refer to DDCountry.Selected.Name rather than DDCountry.Selected.Value.
Table({Name:"UK"},{Name:"Germany"},{Name:"Italy"})
I assume that this is a Choice type which allows multi select in your SP list.
I have a test on my side, please take a try as below.
Set the Items property of the Dropdown control as below:
Ungroup(Filter(Listname, Country in Dropdown1.Selected.Value).location,"location")
Please check if it helps.
Regards,
Qi
If you want to filter on multiple selections then you will need to do this in your Formula:
Filter(Listname, Country in DDCountry.SelectedItems.Value)
I hope this is helpful for you.
thank you for the help, i tried what you suggested but its not working 😞
country drop down values.
Table({Name:"UK"},{Name:"Germany"},{Name:"Italy"})
locations comes up empty and with a error
Your formula is not as I suggested. You have equal sign where in should be:
Filter(Location_1, Country in DDCountry.SelectedItems.Value)
Hi @RandyHayes
sorry, i changed it but i am getting the below.
i changed the formula but again im only getting one result when it should be 3.
Never use SelectedText - it is a deprecated property and at any rate, it will not give you what you want.
What is the Items property of Dropdown6?
Hi @Ash2,
Do you want to filter the location dropdown based on the country dropdown selected?
Could you please tell me that:
There are many contradictions in your description, if you set the country drop down Items as below, you should refer to DDCountry.Selected.Name rather than DDCountry.Selected.Value.
Table({Name:"UK"},{Name:"Germany"},{Name:"Italy"})
I assume that this is a Choice type which allows multi select in your SP list.
I have a test on my side, please take a try as below.
Set the Items property of the Dropdown control as below:
Ungroup(Filter(Listname, Country in Dropdown1.Selected.Value).location,"location")
Please check if it helps.
Regards,
Qi
Also, looking back at your prior posts, you seem to indicate that the dropdown items were:
Table({Name:"UK"},{Name:"Germany"},{Name:"Italy"})
So then the formula I mentioned should be:
Filter(Location_1, Country in DDCountry.SelectedItems.Name)
User | Count |
---|---|
172 | |
95 | |
74 | |
72 | |
58 |
User | Count |
---|---|
215 | |
165 | |
95 | |
93 | |
74 |