You’re offline. This is a read only version of the page.
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!!
Hi @ImaKickUrAsh ,
A Label in the Gallery with this should show the value
Share
Report
All responses (
Answers (
LookUp(
Contacts,
ProjectTie = ThisItem.ID &&
PrimaryContact = "Yes"
).ContactNameIf 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
