Lookup based on dropdown selection

[djmini]

Hey guys, 

New to PowerApps and struggling a little with lookups (normally an Excel user).

I'm trying to essentially do what would be a Vlookup in excel, to return a value from a second column after looking up the value in a drop-down box that contains all the values in the first column of the table. 

If I take out the reference to the drop-down and replace it with the text that is one of the dropdown options, it works perfectly. 

I'm sure it's something simple, but a couple of hours of googling hasn't helped......

[eka24]

Use any of these formulas to try:

LookUp(CustList,Customer=CustomerSelection.Selected.Value,'Resale Markup')

LookUp(CustList,Customer=CustomerSelection.Selected.Result,'Resale Markup')

LookUp(CustList,Customer=CustomerSelection.Selected.ColumnName,'Resale Markup')

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[djmini]

Thanks Eka24 - No luck with any of those....  They all show an error of "Name isn't valid. This identifier isn't recognised"

The equals sign in the argument also shows an error of "Invalid argument type"

Selected or SelectedText appear to be the only options (assuming that all the options are shown as suggestions) and SelectedText gives me another row, but there is still an error under the equals in the argument? 

[eka24]

Please give a screen shot on the Items of the Dropdown, that is the formula on the dropdown

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[djmini]

This bit? 

[eka24]

With the dropdown shown, Where did you try the 3 formulas, in a TextBox.

One of them should work. How ,any rows do you have in the table, more than 2000?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[djmini]

Still no luck.

Yes, it is just in a text label.  I've tried creating a new one and pasting your formulas in, but I just get the same errors. 

There are <20 rows in the table. 

[v-yutliu-msft · Accepted solution]

Hi @djmini ,

Could you tell me the data type of Customer field?
Since the drop down's Items is CustList, so you need to use dropdown.selected.fieldname.

The fieldname should be one field that includes in the drop down's Items.

In your issue, drop down's Items includes two fields: Customer and 'Resale Markup'.

So using CustomerSelection.Selected.Customer and CustomerSelection.Selected.'Resale Markup' is both ok.

Using which column is decided by which column you want to compare with.

In your issue, you want to compare with Customer field, so you should use CustomerSelection.Selected.Customer.

Then the key point is Customer field's data type.

If it is text type, then try this formula:

LookUp(CustList,Customer=CustomerSelection.Selected.Customer,'Resale Markup')

If it is other data type, then formula will be different.

Best regards,

[djmini]

Thanks @v-yutliu-msft ,

That has solved the issue with the formula not working, and the explanation also makes sense.  Thanks again!

[NoobPowerUser]

This helped me out a lot but I'm trying to do dropdown 1 lookup from location and dropdown 2 the to location and get the mileage between the two. 

I'm using this LookUp(BranchChart,Title=Dropdown1.Selected.Result,Dropdown3.Selected.Result) but it's only returning the Row Name. 

I'm new to this so if I need to open a new discussion I can do that.