Hello fellow-power app'ers
I am having trouble with a multi-level cascading drop down list.
I have the cascading options all connected to an Excel sheet.
The first drop down is to choose a state, i.e. Queensland, Victoria or NSW.
The code for this is under Items is: Distinct(Table_1,STATE)
The second drop down depends on the first and it is to choose a REGION within each state, i.e. if Queensland was chosen the regions 'Wetlands' 'Great Barrier Reef,' would appear.
The code for this under Items is: Filter(Table_1,STATE'Dropdown1.Selected.Result)
The next set of connections are a series of species that are connected to each region, i.e, if 'Wetlands' was chosen, several species of plants would appear giving the user the option to choose multiple species.
The code for this under Visible is: If(Or(Dropdown2.SelectedText.REGION="Wetlands"),true,false)
THE PROBLEM:: All the data is stored in the same Excel table. Most of the options are all working fine except two. For example, when I choose the region "Tablelands" under NSW, no species appear. This is the case even when the species appears under another region, i.e. 'tree' appears when "wetland" is chosen but does not appear when "Tablelands" is chosen.
Any insight or help from anybody would be greatly appreciated!
Thankyou.
