Power Platform Community Forum Thread Details

Hello,

I have 2 tables: mac_familia and mac_tipo with the following structure:

I'm trying to construct a dropdown list that:

Shows the mac_tipo_desc field based on the mac_familia_desc choosen
However, my tables are connected by mac_familia_id and my first dropdown is showing mac_famia_desc
How can I construct this indirect relationship?

The most used example I found online is this:

Distinct(Filter(mac_tipo;mac_familia_id=Dropdown1.Selected.Value);mac_tipo_desc)

but I have to find the way to brind the value of other column (mac_familia_id) based on the selected.value.

Categories:

Could you please share a bit more about the formula within the Items property of your first Drop down?

I have made a test on my side, please take a try with the following workaround:

I created two Excel tables as below:

App's configuration as below:

Set the Items property of the first Drop down control (Dropdown1) to following:

mac_familia /* <-- My Excel table */

The Value proeprty of the first Drop down box within right panel set to mac_familia_desc.

Set the Items property of the second Drop down box to following:

Distinct(
 Filter(mac_tipo, mac_familia_id = Dropdown1.Selected.mac_familia_id),
 mac_tipo_desc
)

If the Items property of your first Drop down box set to following:

mac_familia.mac_familia_desc

Please set the Items property of the second Drop down to following:

Distinct(
 Filter(
 mac_tipo, 
 mac_familia_id = LookUp(mac_familia, mac_familia_desc= Dropdown1.Selected.Value,mac_familia_id)
 ),
 mac_tipo_desc
)

Best regards,

Kris

Cascading Dropdown List - Based on an indirect value