News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps vlookup problem

Power Apps - Building Power Apps

Unanswered

vlookup problem

(0) Share

Report

Report

Posted on by Community Power Pla...

Hello to all,

I have 2 galleries:

The first shows the products (SP Product data source) contains descriptions

The second show the Order (data source request) contains quantity and product code

But I want to show other details such as description and pictures but they are part of another data source (IMG_little)

I thought about using Vlookup but it doesn't work well

But my formula doesn't work:

LookUp ('listPrd', ThisItem.CodeProd = Title, 'Long Description')

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: vlookup problem

ciao sfortunatamente sono nuovo la sintassi è davvero difficile. Ho provato a replicare la tua formula ma non funziona
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Re: vlookup problem

Hi @Anonymous

All SharePoint lists have a unique ID column and you can use that for Lookups.

Lookup(list1,ID=ThisItem.list1ID,description)

The foreign key in the second list (in the example, list1ID) points to the primary key in the first list.