Help referencing 2nd SPList

Copper Contributor



Cant get my head round this.


I have 3 lists. 

List 1: Course Catalogue

List 2: Trainer Skills

List 3: Skills List


Within the course catalogue, I have a column called “Required Skills” and Another “Authorised Trainer”


Within the Trainer Skills list I have columns for “Trainer (Person field)”, “TrainerID (Email from Trainer via Flow)” and “Skills” (Lookup from Skills List).


What I want is to show, in the “Authorised Trainers” column of List1, is all the trainers with the skills that match the required skills.


Any way to achieve this without power automate?



0 Replies