web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

PowerApps gallery with 2 Sharepoint Lists with lookups & filters

(0) ShareShare
ReportReport
Posted on by 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!!

I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    152,811 Most Valuable Professional on at
    Re: PowerApps gallery with 2 Sharepoint Lists with lookups & filters

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard