web

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

News and Announcements icon

Power Platform CommunityForums Power Apps PowerApps gallery with...

Power Apps

Answered

PowerApps gallery with 2 Sharepoint Lists with lookups & filters

(0) Share

Report

Report

Posted on by ImaKickUrAsh

51

Hello! I'm stuck & would greatly appreciate some guidance please.

I have a PowerApps Canvas app with 2 Sharepoint Lists as the data sources: Projects & Contacts

Contacts has columns:

ContactName: Single select (People Picker)

ProjectTie: lookup column tied to the ID column in Projects

PrimaryContact: Yes/No

In the canvas app with gallery called galProjects

I have a bunch of other filters already that work great, but I need to be able to filter so the output looks like this:

Projects.Title

// Other Filtered Projects Columns here...

Contacts.ContactName (where Contacts.ProjectTie = Project.ID && Contacts.PrimaryContact = Yes)

***I can't use AddColumns because I store the selected record in a variable & use it in logic for other screens (unless there's no other way & I'd have to DropColumns on gallery item select??)

Thanks in advance!!

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,763 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ImaKickUrAsh ,

A Label in the Gallery with this should show the value

LookUp( Contacts, ProjectTie = ThisItem.ID && PrimaryContact = "Yes" ).ContactName

If however you need the value in the Gallery Items, then yes, you would need to use AddColumns.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Join the conversation