Look Up combined with Sharepoint and ComboBox

[TS5]

Hi Guys,

So what I want to do, should be quiet simple, but is to me more difficult, than it should be.

I've got in my Power App a Formular, which shows a sharepoint list. I want to creat a live Vlookup like in Excel.

This is my current try but it does not work....

Datasource is the datasource.

DataCardValue19_3 is a Combofield - I guess? - related to a sharepoint list

With DataCardValue19_3 you can select an Item Number from Datasource1

'Item Number' & 'Unit Cost' are located in Datasource2

LookUp(Datasource2; DataCardValue19_3.SelectedItems.Value = 'Item Number').'Unit Cost'

Best Regards,

Torben

[PG_WorXz10]

Hi @TS5 ,

Try below code. 

LookUp(Datasource2; 'Item Number' =DataCardValue19_3.SelectedItems.Value).'Unit Cost'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[TS5]

Hey, there is a Problem with this. When I'm inserting that code it is not possible to select 'Item Number' which is a column from datasource 2. 😕