Answered

Using the Combobox selectedItems as text for other lists

(0) Share

Report

Posted on by doironjp

Hello,

This is quite the beginner's question, but I would just like to use the SelectedItem in my ComboBox (maybe extract it?) so that I can use it to power "Distinct" searches in other DropDown lists.

Specifically, I am trying to reference the SelectedItem in this formula :

Sort(Distinct(Filter("List1", Name2=COMBO.SELECTED.FIELD),Name1),Result)

Thank you and I will be glad to offer more details if need be!

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@doironjp

SelectedItems is just a property that contains a table of records that match the Items property of the control and have been selected.

What is it that you want to use the in regard to Distinct?
rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

hi @doironjp the combobox has a field that's mapped to it. a label can refer to that field such as yourComboBox.Selected.Field such as yourComboBox.Selected.Value this will display the selected items field/column Value.

It becomes a bit more tricky with multiple selected items

Hope it helps

R
doironjp 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello! Thanks a lot for the fast answers.

I am trying to reference the SelectedItem in this formula :

Sort(Distinct(Filter("List1", Name2=COMBO.SELECTED.FIELD),Name1),Result)
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@doironjp

Your syntax is wrong. Are you using a language that needs your parameters to be separated by a comma or a semicolon?

Should be either:

Sort(Distinct(Filter(List1, Name2=COMBO.Selected.FIELD), Name1), Result)

Or

Sort(Distinct(Filter(List1; Name2=COMBO.Selected.FIELD); Name1); Result)

Note, the above formulas will only provide filtering on ONE item. If you want to filter on multiple selections, then:

Sort(Distinct(Filter(List1, Name2 in COMBO.SelectedItems.FIELD), Name1), Result)
doironjp 15 on at

Like
a
(0)

Report
Copy link

Link copied!

You are right my syntax was all messed up since I'm using the French version and was trying to "translate" it sorry.

I have tryed the following but it doesn't seem to yield any result :

Sort(Distinct(Filter(List1; Name2=COMBO.Selected.FIELD); Name1); Result)
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@doironjp

Okay...semicolons it is then.

What is the Items property of your combobox?
Verified answer

doironjp 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks to all your answers I found out how to make it work :

Sort(Distinct(Filter('List1'; Nom2=COMBO.Selected.Name2); Name1); Result)