Displaying a value from one list in another lists browse gallery

[Elliottd]

Hi Community!

I am stuck trying to implement this feature in PowerApps. Let me explain the issue,

I have two SharePoint Lists that are added as sources in PowerApps, the lists are as follows -

List 1

Defect Type and Sub Type

List 2 

LATENT DEFECT TRACKER

I have a gallery view displaying some of the items from list 2.

I would like to display an item (Scheme Name) from list 1

All my other items display fine from list 2 (ThisItem.Title) or ThisItem.'Case Closed'.Value

I have tried LookUp('Defect Type and Sub Type'.'Scheme Name'=ThisItem.Scheme Name) but it's not selecting ThisItem.Scheme Name 

It keeps on referring to list 2

The first part of the query quantifies LookUp('Defect Type and Sub Type'.'Scheme Name' as soon as I input =Thisitem is cant select Scheme Name

Thanks in advance.

[v-qiaqi-msft · Accepted solution]

Hi @Elliottd,

Could you please give a sample to describe the relationship between the list1 and list2?

Do you want to display the Scheme Name from list1 corresponding to each record in the list2?

Modify your formula as below:

LookUp('Defect Type and Sub Type','Scheme Name'=ThisItem.'Scheme Name') 

I think the formula you provided makes no sense, if the scheme name from list1 equals to schema name from this item, then there is no need to display schema name since they are totally same.

You should refer to the primary key between the list1 and list2, so that you could retrieve the schema name based on the same primary key from list1.

For example, TypeID is the primary key that both list1 and list2 shares, you could use the following formula:

LookUp('Defect Type and Sub Type',TypeID=ThisItem.TypeID).'Schema Name'