Hi @maruthi216 ,
Could you please share a bit more about the formula you typed within the Items property of the Dropdown1_1?
Could you please share a bit more about the data type of the "Manufacturer" column in your PADEVICES, PAMODEL and PA_ACCESS lists? Is it a Choice type column or a Single text type column?
Based on the issue that you mentioned, I think there is something wrong with it. I have made a test on my side, please consider take a try with the following workaround:
Set the Items property of the Dropdown1 to following:
Distinct(PAMFR, Manufacturer)
set the Items property of the Dropdown2 to following:
Filter(PADEVICES, Manufacturer = Dropdpown1.Selected.Result)
if the "Manufacturer" column in your PADEVICES list is a Choice type column, please modify above formula as below:
Filter(PADEVICES, Manufacturer.Value= Dropdpown1.Selected.Result)
If you changed the Title column in your PADEVICES list into "Manufacturer", please modify above formula as below:
Filter(PADEVICES, Title = Dropdpown1.Selected.Result)
then set the Device column as Display column value within the Dropdown2.
set the Items property of the Dropdown3 to following:
Filter(PAMODEL, Manufacturer = Dropdpown1.Selected.Result)
if the "Manufacturer" column in your PAMODEL list is a Choice type column, please modify above formula as below:
Filter(PAMODEL, Manufacturer.Value= Dropdpown1.Selected.Result)
If you changed the Title column in your PAMODEL list into "Manufacturer", please modify above formula as below:
Filter(PAMODEL, Title = Dropdpown1.Selected.Result)
then set the Model column as Display column value within the Dropdown3.
set the Items property of the Dropdown4 to following:
Filter(PA_ACCESS, Manufacturer = Dropdpown1.Selected.Result)
if the "Manufacturer" column in your PA_ACCESS list is a Choice type column, please modify above formula as below:
Filter(PA_ACCESS, Manufacturer.Value= Dropdpown1.Selected.Result)
If you changed the Title column in your PA_ACCESS list into "Manufacturer", please modify above formula as below:
Filter(PA_ACCESS, Title = Dropdpown1.Selected.Result)
then set the Access column as Display column value within the Dropdown4.
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
