Auto populate Text Box based on a Dropdown Value

(0) Share

Report

Posted on by rameshkc

Hello i have a table that has two columns in sql, ID and Description

ID Description

1 Hello

2 Test

On my App, When user selects ID from dropdown , i would like my Textbox to display Hello and same thing with rest of the other column.

I tried doing dropdown1.selected.value in ID but this did not help.

I also tried doing On select property of dropdown to UpdateContext({itemsselected:Dropdown.Selected.Value}) and default of text to itemsselected. This only brings ID not the description.

Any help would be appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @rameshkc

So, you have your dropdown1 with it's items equal to NameOfDataSource.ID which will then automatically update and not require manual entry if the list expands yeah?

Then, you will need to have the label's Text=

LookUp(NameOfDataSource,ID=dropdown1.Selected.ID).Description

Let me know if that works for you, and if not could you provide a bit more detail regarding the situation and names of items,

Cheers,
@iAm_ManCat

Was this reply helpful? Yes No
rameshkc 53 on at

Like (1)

Report
Copy link

Link copied!

@iAm_ManCatThat works!! Thanks a lot!

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

My Pleasure, glad to help 🙂

Was this reply helpful? Yes No
shal2522 76 on at

Like (0)

Report
Copy link

Link copied!

I have a combo box list with users that come from office365.When I select a user name I want that populating a text field.
How do I go about this?

Was this reply helpful? Yes No