cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TS5
Regular Visitor

Look Up combined with Sharepoint and ComboBox

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

2 REPLIES 2
PG_WorXz10
Community Champion
Community Champion

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.

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

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. 😕

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,738)