Add a column to gallery from different list

(0) Share

Report

Posted on by Tango

1,168

Hi,

Trying to get the formula right for adding a field to a gallery that is from a different source than the "primary source" of the gallery. This would also involve a query I guess for each record in the gallery.

Basically I have a gallery of Accounts and I want to put the primary contact in to each record in the gallery under the Account Name.

To get that I need to take the name of the account in the current gallery then query a different list and say give me the name of the person who has the same account as above and also has Yes or Tick (Yes No Box) next to the column that says Primary Contact.

My attempt so far is but it contains no queries 'Contact Accounts'[@Contact].Value

For the record the name value in the different list is a lookup from another list.

Thanks in advance for any assistance

Todd

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

EddieE 4,641 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Tango
What data source are you using? If Dataverse, try asking in this forum as you'll typically find users with more Dataverse experience than in this forum:

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/bd-p/CDS_Apps

Was this reply helpful? Yes No
Tango 1,168 on at

Like
a
(0)

Report
Copy link

Link copied!

Datasource is SharePoint lists

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Tango
Try this in the Items property of your gallery

AddColumns( Accounts, "ContactName", LookUp( Filter(List2, Account = Account && 'Primary Contact'.Value = "Yes"), Contact ) )

EDIT: Then add a label to your gallery with the Text property

ThisItem.ContactName

Was this reply helpful? Yes No