Hi @Anonymous ,
Could you please share a bit more about the TM field, Category field and Model field within your SP List? Are they all Choice type columns?
Could you please share more details about the formula you typed within the Items property of the TM Dropdown box, Category Dropdown box and Model Dropdown box?
1. If the TM field, Category field and Model field are all Choice type columns in your SP List, please consider take a try with the following workaround:
Set the Items property of the Category Dropdown box to following:
Filter(
Choices('YourSPList'.Category),
Value in ForAll(
Filter('YourSPList', TM.Value = TMDropdownBox.Selected.Value).Category,
Category.Value
)
)
Note: Same logic for Model Dropdown box.
2. If the TM field, Category field and Model field are all not Choices type column in your SP List, please consider take a try with the following workaround:
Set the Items property of the TM Dropdown box to following:
Distinct('YourSPList', TM)
Set the Items property of the Category Dropdown box to following:
Filter(
Distinct('YourSPList', Category),
Result in Filter('YourSPList', TM = TMDropdpownBox.Selected.Result).Category
)
or
Distinct(
Filter('YourSPList', TM = TMDropdownBox.Selected.Result),
Category
)
Note: Same logic for Model Dropdown box.
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
