Share
Report
35Hi I am building a Skill Matrix where I am using Sharepoint lists. My lists are as follows, Adv User List (List 1) (Users were imported into this list from Azure AD using Power automate) and a Skills Network (List 2) that has records of each users can be cross referenced with 'Employee:UserID' and has Skill, Skill Category and Skill Rating.
The Column I would want to use for crossreferencing is UserID which is a Text Column in list 1, and it is a Lookup Column in list 2.
What I am trying to accomplish is to make a Filtered Search screen where I am looking at the gallery and can use filters to narrow my search for a specific criteria I am searching for. I want to be able to use dropdowns to filter out user record in a gallery, 2 dropdowns work fine since the information is on List 1 but 3 of my dropdowns are checking records in list 2 and I can't make them work.
What I have managed to do, is group together Employee's on list 2 and display each employee on list 2 once and make a nested Gallery where I show each record connected to User where I display Skills Informations.
So what happens when I pick a category is this:
What I would like to do is either let the parent record/item disappear from the Gallery when Child gallery shows no records
or
Use the list 1 gallery and crossreference UserID with records from list 2, and if I don't find any records on list 2 then records from Gallery would disappear.
With method one there is a problem I have further down the line, where if I select record I get last visited record on details list about User/Employee. So I would think that method 2 would be the best option.
What would be your advice on addressing this issue, how could I crossreference UserID between two lists and display records that are crossreferenced when I pick a value in dropdowns? Is it possible to use a DataTable or an extra Gallery that is not visible in the backrground to reference records?
All responses (
Answers (
