Hi
In a form i have three dropdowns
data has to populate from 2 tables actually
List1 columns(department,JobTitles)
List2 columns(Location)
Dropdown1
Formula is (Distinct(list1,Departments) Working as fine as expected
Dropdown2(when Dropdown1 selected value then only dropdown2 values are loding) Working as fine as expected
Formula is Filter(list1,Departments=dropdown1.Selected.Result)
Dropdown3
1. when dropdown2 is selected then only dropdown should be active to select values
2. how to load(farmula) from list2 columns
or
do i need to create lookupcolumn in list1 even tho i tryed with below formula but data is not populating
i tried with below formula
Distinct(Filter(kmkPowerAppsTest,Departments=drp_dept.Selected.Result), lookulocation)
waring : columns produced by this rule are all nested tables and or/recoreds however the properties expects atlest some columns of the simple values
how to fix this error can some one kindly help me how to load dropdown3 from list2
