Answered

return value

(0) Share

Report

Posted on by HubSteel

I have a simple excel spreadsheet that has 2 columns- "vendor" and "price'. I would like to have a drop down that lets me pick a vendor and then want to have a field below that says "price" and the returns value based on that selection. how would i do that? E

Eventually i would like to return 3 or 4 values for each vendor. I don't really like the formatting that the gallery returns so i want to try to use display fields.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@HubSteel

Put this code in the Items property of the dropdown

your_excel_name.Vendor

Then put this code in the Text property of a label

LookUp(your_excel_name, Vendor=Dropdown1.Selected.Vendor, Price)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Doug_Apicella 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi HubSteel,

What you can do is reference datasource in the dropdown and then select your Vendor as the Value on the dropdown properties

You can then use labels and reference the dropdown to get the other columns in your datasource in your label

example: dropdown1.SelectedText.Price

You can add as many labels as you need and reference each column as necessary. Thanks.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@HubSteel,
Based on the needs you mentioned, you want to return the price value based on the dropdown selected from the vendor.
Could you please share more about “return 3 or 4 values for each vendor”, every vendor has only one price which can not return 3 or 4 values.
If you want to have a field below and says ”price” when picking from vendor dropdown, you can add a label and set Text property as below:

"price"

I have a test on my side, please take a try as below:
Add a dropdown, set the Items property as

Distinct(Table,vendor)

set the OnChange property as

UpdateContext({Temp:LookUp(Table1,vendor=dropdown1.Selected.Result)})

Add a TextInput, set the Default property as

Temp.price

Best Regards,
Qi

Was this reply helpful? Yes No