Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Help updating multi lookup column

(0) ShareShare
ReportReport
Posted on by 87

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.

 

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard