web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Displaying a value fro...

Power Apps

Answered

Displaying a value from one list in another lists browse gallery

(0) Share

Report

Report

Posted on by Elliottd

11

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

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

Was this reply helpful? Yes No

Join the conversation