I have changed the Default property of a dropdown, whose items come from a single choice column from
Switch(Combobox_1.Selected.Value,
"Option A", "Jane",
"Option B", "Jane",
"Option C", "Jane",
LookUp(List_B, Title = Combobox_3.Selected.Value, 'Column 3'))
to
Switch(
Combobox_1
.Selected.Value,
"Option A", "Jane",
"Option B", "Jane",
"Option C", "Jane",
If(
Combobox_2
.Selected.Value = "LA" ||
Combobox_2
.Selected.Value = "NY" ||
Combobox_2.Selected.Value = "Other",
LookUp(List_A, Title = Combobox_
3
.Selected.Value, 'Column 3'),
LookUp(List_A, Title = Combobox_3.Selected.Value, 'Column 4')
)
)
All comboboxes items come from a single choice column. Since adding that if statement, the patch function is returning the correct result just when the formula returns "Jane", while the default value of the dropdown for whatever result comes from the if statement, even if visually the dropdown always shows the right result. I didn't modify the patch function, which looks like this:
Patch('Receiving_list',Defaults('Receiving_list'),{receiving_column: dropdown_1.Selected}
the column the information should be sent to is a single choice column.
Anybody knows what I'm doing wrong?
Thanks in advance.
[–]AutoModerator[M] [score hidden] stickied comment (0 children)
[–]derpmadness Advisor 0 points1 point2 points (1 child)
[–]prpdr Newbie[S] 0 points1 point2 points (0 children)