Combo box: Items property = Table with two columns. How to display the values from Column 2 but store the values from Column1?

(0) Share

Report

Posted on by Sam4

229

Hi, I'm having some issues to do the following. Any help is much appreciate.

I have a table with two columns. I want to display in a ComboBox the column "Description", and when the item is selected, display the value of the column ID in a Label Text. I have the following Elements:

- Table1: Where the data is

- ComboBox1: ComboBox displaying column Description

- Label1: Label displaying the ID of the selected Description in Table1

For example, giving the Table 1 below, my ComboBox1 should display ITEM_1, ITEM_2, ITEM_3, ITEM_4, ITEM_5,

If I select the ITEM_1, Label1 should display "1"

Table1

ID Description

1 ITEM_1

2 ITEM_2

3 ITEM_3

4 ITEM_4

5 ITEM_5

I've tried to add to Combobox the following

Items: Table1.Description. It display the items in the combobox but I can not get the ID in Label. (I am using in Label - TEXT: Combobox1.Selected.Text)
Items: Table1. It display the items in the combobox but 1) I can't search in the combobox and 2) I can not get the ID in Label.

Any suggestion?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community Power Pla... on at

Like (1)

Report
Try using Combobox1.Selected.ID as the Text property of the label. The Items property of the dropdown should just be Table1
If you have multiple selections, you can use this formula
Concat(ComboBox1.SelectedItems.ID,Text(ID),", ")
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

if all the structure is the same then try in the Leabel:
Substitute(ComboBox2.Selected.Value,"Term_"," ")

Was this reply helpful? Yes No
Sam4 229 on at

Like (0)

Report

Thanks both for your replies,

@Anonymous your solution works, I think I had some type of connectivity problems as I would say I tried that, anyway, thanks :). I don't have multiple selections so that is fine.

If I have in Items for the combobox Table1, how I can make sure it is displaying the column Description?

Was this reply helpful? Yes No