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?
Solved! Go to Solution.
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.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!