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.
Solved! Go to 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
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
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
71 | |
49 | |
41 | |
30 |
User | Count |
---|---|
266 | |
121 | |
95 | |
90 | |
81 |