Hi,
I have the following Lists:
Trainers
Course Catalogue
Skills Matrix
Course Catalogue contains a Lookup column called ‘Course Skills’.
‘Trainers’ has a Lookup column called ‘Trainer Skills’.
’Trainers’ also has a Lookup Column called ‘Course Delivery’ relating to the Course Catalogue ‘Title’ field.
What I want is that when a Trainers skill set is updated a flow runs which updated the Course Delivery column with all the courses they can deliver based on skills.
for example.
Is the course catalogue lists a course called:
Printing
Course Skills
A1
A2
A3
if I go to the trainer list and add a new trainer who has:
Trainer Skills
A1
A2
A3
The course delivery column is updated with ‘Printing’.
if the trainer only had A1 and A2 the field should be blank…
any ideas. Tried creating an array of Trainer Trainer Skills and an Array of Course skills but couldn’t get anywhere.
thanks.