Answered

PowerApps Gallery add another column from the list

(0) Share

Report

Posted on by Santosh_143

Hi ,

I have a parent and child sharepoint list with lookup field as mapping. I have placed a gallery and loading all the items in a gallery with the below filter condition which works perfect.
Filter('Products',(Location.Value=DrpLocation.Selected.Value||If(DrpLocation.Selected.Value="-Select-", true , false ))&&('Category Name'.Value=DrpCatType.Selected.Value||If(DrpCatType.Selected.Value="-Select-", true , false ))&&(StartsWith('SERVICE TAG',SearchProductstextBox.Text)||StartsWith(MODEL,SearchProductstextBox.Text)))

Now i want to display a column of child list "AssignedTO" in this gallaery. where i have placed a label and on text property

LookUp(BIASITASSETS,ID=Value(GetpidfromAssignInfoId)),Last(AssetColl)).AllocatedTo

I read from ShangeYoung video that it is not good practice to use Lookup to display the data for a single column in a gallery.

How can we achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Santosh_143 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney can you help me in this regard

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Santosh_143 ,

Do you want to display data from another list in the gallery?

Could you tell me:
1)which is the parent list? which is the child list?

2)where is the lookup field? in which list? the lookup field name? looks up to which field in another list?

3)AssignedTO field data type?

I assume that:
1)'Products' is the parent list, BIASITASSETS is the child list

2)look up field is in BIASITASSETS list, lookup field named GetpidfromAssignInfoId, looks up to ID field in 'Products' list

3)AssignedTO field data type is single person type

4)the gallery is used to display 'Products' list, you want to display related AssignedTO field in this gallery

If so, you should set like this:
1)the gallery's Items:

Filter('Products',(Location.Value=DrpLocation.Selected.Value||If(DrpLocation.Selected.Value="-Select-", true , false ))&&('Category Name'.Value=DrpCatType.Selected.Value||If(DrpCatType.Selected.Value="-Select-", true , false ))&&(StartsWith('SERVICE TAG',SearchProductstextBox.Text)||StartsWith(MODEL,SearchProductstextBox.Text)))

2)insert a label inside the gallery

set the label's Text:

LookUp(BIASITASSETS,GetpidfromAssignInfoId.Value=ThisItem.ID).AssignedTO.DisplayName

Best regards,

Was this reply helpful? Yes No