Dropdown dummy options tied to real values

[connor]

Hi there, 

Is it possible to have a Dropdown display "dummy" values which are tied to a real values? 

My goal is to have a Textbox display the selection of the Dropdown box; however, the real values are primary keys and don't mean anything to a user.  I want to display in the Dropdown a value like "Banana" and have the Textbox show B1 which is the primary key of "Banana".

My formulas are:
Textbox

Dropdown2.Selected.Value

DropDown

Distinct(Products1,ProductID)

Thanks for your help and advice. I am new to PowerApps and learning the basics still.

[timl · Accepted solution]

Hi Connor,

Yes, this is possible. The way to do this is to set the Items property of your dropdown to a data source that includes both your ID and Text values.  Let's say that you set the Items property of your dropdown to a 'Products' table that looks like this:

In your dropdown, you would set the Value property to the field that you want to display (ProductDesc in this example).

In your textbox, you can then retrieve the ProductID using the following syntax:

Dropdown2.Selected.ProductID