cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Filter 2nd gallery by data within 1st gallery

Goal:  Using sharepoint online, I have created Site Level Columns to house master lookup values for 3 different list (submission, project SME's, project approvers).  Ideally, list 1 will be used as a submission list - meaning the user will submit a form that consists of only lookup values from the Site Level Columns....this list becomes Gallery1. 

 

I would like the app to go to a new screen when a button is clicked (i know how to do that) from the defaulted DetailScreen when editing an app from within the sharepoint list.  On this new screen would like to have Gallery2 (Project SME's list).  Based on the lookup values from List 1 (Submission), I would like Gallery2 to pull in the appropriate data fields related to the same lookup values from List 1 (Submission).  Example, project submission details include: Business line, Inventory, Distribution Channel.  Gallery2 would provide a list of names with experience in related business lines, inventory managers, and distribution channel reps....as determined by the values submitted in List 1.  

 

The 3rd list will do the same thing as described above, just having different values to represent budget approvers for the applicable List 1 submission values.  

 

I really wish I could share screen shots but this is am submitting on a work issued laptop and IT will block attachments.  I hope this makes sense.  Can anyone point me in a direction to address this?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Follow this post which filter one Gallery based on the other. Two list involved ar e incident and update
https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-2nd-Gallery-By-Parent-ID/m-p/53506

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

View solution in original post

3 REPLIES 3
Super User III
Super User III

Follow this post which filter one Gallery based on the other. Two list involved ar e incident and update
https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-2nd-Gallery-By-Parent-ID/m-p/53506

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

View solution in original post

Thanks @eka24, hadn't come across that post yet.  I think I was spending too much time on my issue and explained it incorrectly...after apply that solution i discovered  I actually need to filter the 2nd gallery by a DetailForm which contains DataCardValues of those Site Level Lookup Column values.  Another wrench to throw in, the submission list is multi-select.

 

Your solution was utilized successfully for another component within the app, so greatly appreciate it.  

if your issue is resolved, them mark as a solution. Else you can explain the current issue

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (74,200)