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
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks