web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps vlookup problem

Power Apps

Unanswered

vlookup problem

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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')

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

ciao sfortunatamente sono nuovo la sintassi è davvero difficile. Ho provato a replicare la tua formula ma non funziona

Was this reply helpful? Yes No

Join the conversation