Share
Report
28I'm currently building a canvas app and I have two combo box dropdowns (sub_group and type_work). I'm wanting the sub_group combo box dropdown to control the available options when I click the type_work combo box dropdown.
Below is the formula I entered in the "Items" field for the type_work. When I play the app, nothings appears under I click the drop down for type_work. Do I need to create an if statement so the options can be associated with each other. I have 4 sub_group options and 12 type_work options
Filter(
AddColumns(
Choices('Type_Work (SCADA Activity Logs)'),
_textChoice1,
Text(Value)
),
_textChoice1 in Distinct(
Filter(
AddColumns(
'SCADA Activity Logs',
_textChoice2,
Text(Type_Work)
),
Sub_Group = DataCardValue25.Selected.Value
),
_textChoice2
)
)
Categories:
I have the same question (0)
All responses (
Answers (
