Hi Vipul When im trying to apply drop down cascading to power apps .i dont why Most of the online videos are considering two list from the share point ?. is it possible consider only one list and is there any limitation in power apps or sharepoint. please, can you help me
You can have two columns (e.g. - Country and City) in same SharePoint List also (I have used a SharePoint List named Locations). In first dropdown Items property, you can write: Distinct(Locations, Country) In second dropdown Items property, you can write: Filter(Locations, Country = Dropdown1.Selected.Value)
Thank you, Vipul! May I ask how to fix if the dropdown property is only showing as Value, Result is not available and I cant even type it in the Items. Thank you in advance
Hello Rob. 4 levels of cascading is also possible. I added 4-levels for Region, Country, State, City fields. Please make sure you are using Distinct function correctly, as it asks for 2 parameters - Source & Expression in Power Apps.
Hi! Im trying the code and everything works fine until i have to enter the text boxes. The .Text appears as an error and leaving the box name alone does not work. Do you have a workaround this? Thanks!
Hi Victoria. The issue is not clear, can you please share more details. In this video, I have shown how cascading can be performed between different drop-downs.
Hi Vipul just want to ask you one thing here. Suppose I have three boxes states , county and city . In that I have all the states of USA. But as there are more than 2000 records I cannot see all the states. Can you help me out?
This is because of the hard limit wherein PowerApps can only retrieve 2000 records from a datasource in a single query. You could consider using the Collect() function to store all the items in a collection. Then display the collection within the Drop-Down.
Wonderful- Thanks alot for detail video
Hi Vipul
When im trying to apply drop down cascading to power apps .i dont why Most of the online videos are considering two list from the share point ?.
is it possible consider only one list and is there any limitation in power apps or sharepoint. please, can you help me
You can have two columns (e.g. - Country and City) in same SharePoint List also (I have used a SharePoint List named Locations).
In first dropdown Items property, you can write: Distinct(Locations, Country)
In second dropdown Items property, you can write: Filter(Locations, Country = Dropdown1.Selected.Value)
Thank you, Vipul! May I ask how to fix if the dropdown property is only showing as Value, Result is not available and I cant even type it in the Items. Thank you in advance
It might be possible that drop down is not added correctly in the Canvas App. Please follow the steps given in video and issue might be resolved.
Hi Vipul, i would like to add an extra column so i get 4 levels of cascading, is that even possible? Every filter of distinct i tried, i get error's.
Hello Rob. 4 levels of cascading is also possible. I added 4-levels for Region, Country, State, City fields. Please make sure you are using Distinct function correctly, as it asks for 2 parameters - Source & Expression in Power Apps.
Hi! Im trying the code and everything works fine until i have to enter the text boxes. The .Text appears as an error and leaving the box name alone does not work. Do you have a workaround this? Thanks!
Hi Victoria. The issue is not clear, can you please share more details. In this video, I have shown how cascading can be performed between different drop-downs.
Hi Vipul just want to ask you one thing here. Suppose I have three boxes states , county and city . In that I have all the states of USA. But as there are more than 2000 records I cannot see all the states. Can you help me out?
This is because of the hard limit wherein PowerApps can only retrieve 2000 records from a datasource in a single query. You could consider using the Collect() function to store all the items in a collection. Then display the collection within the Drop-Down.