Power Platform Community Forum Thread Details

Hi,

I am trying to filter a dropdown list dependent on another dropdown list but it still shows all the list options.

I am creating a vehicle defect app, when a user selects a depot from the 1st dropdown list i want the second dropdown list to only show vehicle types at that depot not all vehicle types on the list.

the second dropdown list should only show

Gritter

8 Wheeler

van

IPV

but it still shows all vehicles in the list.

this is the code in items of the second dropdown.

If(
dd_Depot.SelectedText.Value = "",
Ungroup(
Table(
{Value: Blank()},
{
Value: ForAll(
Distinct(
Filter(
'All Registrations',
dd_Depot.SelectedText.Value = Depot.Value And dd_VehicleType.SelectedText.Value = 'Vehicle Type'
),
VehicleType
),
{Result: ThisRecord.Value}
)
}
),
"Value"
),
CollectVehicleType
)