Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

How do I get a value from table based on dropdown result?

(0) ShareShare
ReportReport
Posted on by 158

Hello,

 

I have an excel file which has two tables. I just have a dropdown box in powerapps and next to it I want to see a label with value which is referenced in table to the chosen option in dropdown (it's a number). Does anyone can help how to do it, please? 

 

My table has two headers and dropdown is using values from one column and I want to see values from 2nd column in label.

 

Regards

Categories:
  • MP-13011217-0 Profile Picture
    MP-13011217-0 158 on at
    Re: How do I get a value from table based on dropdown result?

    Thanks!!! This gave me result I wanted 🙂

  • MP-13011217-0 Profile Picture
    MP-13011217-0 158 on at
    Re: How do I get a value from table based on dropdown result?

    Thank You for Your reply. I tried it now and it's still not working as showing error below: 

     

    marcy_pi_0-1664187127932.png

     

  • Verified answer
    VJR Profile Picture
    VJR 7,635 on at
    Re: How do I get a value from table based on dropdown result?

    Did you mean something like this?

     

    VJR_0-1664187035492.png

     

     

    This is written on the Text property of the Label

    LookUp(Table1,FirstName = Dropdown1.SelectedText.Value,Location)

     

  • Silvester. Akakpo Profile Picture
    Silvester. Akakpo 783 on at
    Re: How do I get a value from table based on dropdown result?

    Hello @marcy_pi ,
    Kindly try this on the label text property

    LookUp(Table2,DropDown.Selected.Value=ColumnNameTable2,ColumnToReturn)

     

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,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard