Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Auto populate Text Box based on a Dropdown Value

(0) ShareShare
ReportReport
Posted on by 53

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! 

  • shal2522 Profile Picture
    shal2522 76 on at
    Re: Auto populate Text Box based on a Dropdown Value

    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?

  • iAm_ManCat Profile Picture
    iAm_ManCat 18,112 on at
    Re: Auto populate Text Box based on a Dropdown Value

    My Pleasure, glad to help 🙂

  • rameshkc Profile Picture
    rameshkc 53 on at
    Re: Auto populate Text Box based on a Dropdown Value

    @iAm_ManCatThat works!! Thanks a lot!

  • Verified answer
    iAm_ManCat Profile Picture
    iAm_ManCat 18,112 on at
    Re: Auto populate Text Box based on a Dropdown Value

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard