Look up value from SP List using dropdown choice as reference

[Aaron7]

Hello All 

I am currently building an app that will be able to generate quotations for our sales reps. we need to be able to configure the product to a customer spec.

I currently have all the price list data on a SharePoint list. which is connected to the app its self. I have a drop down list with all of the "Option" Codes  as below "DropDown" jpg attached

What I need is to be able to use this as a reference to look up the price from my list and return that value in the Label or Text input box to the right, I then will sum all of the values at the bottom of the Canvas. 

I have tried LookUp and filter but had no success

Does anybody have any suggestions?

TIA

[eka24 · Accepted solution]

For the LookUp on the price try in the text property of the label:
LookUp(SharepointList,ColumnName=Dropdown1.Selected.Result,PriceColumn)

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

[Aaron7]

That's great thanks

all working

been struggling for a few days on that.  👍