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

(0) Share

Report

Posted on by MP-13011217-0

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Silvester. Akakpo 783 on at

Like (0)

Report
Copy link

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

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

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (1)

Report
Copy link

Link copied!

Did you mean something like this?

This is written on the Text property of the Label

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

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (1)

Report
Copy link

Link copied!

Thanks!!! This gave me result I wanted 🙂

Was this reply helpful? Yes No