I've been trying a few methods of creating a Cascading Drop-Down List from my SharePoint Lists.
Basically, I have created 3 SharePoint Lists:
1 - Province
2- Province & District
3 - Province , District & Ward
I have succesfully use the method from this link :https://www.youtube.com/watch?v=EJQZ0sv7zV8&t=827s
However, ONLY THE FIRST 2 WORKS.
And I have done reasearches but have not been able to find a solution to the 3rd one - always getting the error with nothing populate. (I want to show the Ward corresponding to the District and Province)
PLease anyone help me with this one. Many thanks to your help,
Solved! Go to Solution.
Thanks for posting.
I have some questions:
1. Has the Title field from WARD_LIST been renamed to PROVINCE (under Classic View)?
If Title column has been renamed after loading in PowerApps, please take a try to remove this list and then add it again,
2. Could you please share the corresponding error messages by pointing mouse at the yellow reminder of the Dropdown control?
If Title field has been renamed, then the formula should be changed as below:
Filter(WARD_LIST_1, PROVINCE = ddProvince.Selected.Value, DISTRICT =ddDistrict.Selected.Value)
There is no need to add && within Filter function, see if doing this would help.
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.