Additional attribute/field on list lookup relationship

%3CLINGO-SUB%20id%3D%22lingo-sub-548855%22%20slang%3D%22en-US%22%3EAdditional%20attribute%2Ffield%20on%20list%20lookup%20relationship%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-548855%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWe%20have%20created%202%20lists%3A%3C%2FP%3E%3CP%3E-%20Employee%3C%2FP%3E%3CP%3E-%20Skillset%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Employee%20list%20we%20can%20add%20an%20employ%20and%20specify%20which%20skillset%20he%20has%20(can%20be%20multiple).%3C%2FP%3E%3CP%3EWhen%20doing%20so%2C%20we%20want%20to%20be%20able%20to%20specify%20the%20proficiency%20level%20for%20each%20selected%20skillset...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20we%20add%20a%20value%20for%20each%20selected%20skillset%20lookup%20value%20of%20the%20employee%20row%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-548855%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-549603%22%20slang%3D%22en-US%22%3ERe%3A%20Additional%20attribute%2Ffield%20on%20list%20lookup%20relationship%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-549603%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EOn%20Lookup%20column%20settings%20you%20can%20define%20which%20additional%20columns%20are%20added%20to%20list%20view.%3CBR%20%2F%3EAre%20you%20trying%20to%20achieve%20something%20like%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20650px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112627i765DB5A977D979E6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22employee.png%22%20title%3D%22employee.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIs%20it%20on%20modern%20or%20classic%20list%20experience%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-549624%22%20slang%3D%22en-US%22%3ERe%3A%20Additional%20attribute%2Ffield%20on%20list%20lookup%20relationship%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-549624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5628%22%20target%3D%22_blank%22%3E%40Matti%20Paukkonen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20exactly.%20What%20we%20are%20trying%20to%20achieve%20is%20to%20allow%20to%20specify%20the%20seniority%2Fproficiency%20level%20of%20an%20employee%20on%20specific%20skillset.%26nbsp%3B%20Multiple%20employees%20might%20be%20linked%20to%20a%20same%20skillset%20but%20have%20different%20seniority%2Fproficiency%20level%20on%20it.%20So%20we%20want%20to%20be%20able%20to%20add%20an%20attribute%20on%20the%20relationship%20Employee-Skillset.%26nbsp%3B%20its%20not%20an%20attribute%20on%20the%20Skillset%20but%20on%20the%20relationship%20between%20employee%20and%20skillset.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

We have created 2 lists:

- Employee

- Skillset

 

In the Employee list we can add an employ and specify which skillset he has (can be multiple).

When doing so, we want to be able to specify the proficiency level for each selected skillset...

 

How can we add a value for each selected skillset lookup value of the employee row?

 

Tks!

2 Replies
Highlighted

Hi,

On Lookup column settings you can define which additional columns are added to list view.
Are you trying to achieve something like this?

 

employee.png

Is it on modern or classic list experience?

Highlighted

@Matti Paukkonen 

 

Not exactly. What we are trying to achieve is to allow to specify the seniority/proficiency level of an employee on specific skillset.  Multiple employees might be linked to a same skillset but have different seniority/proficiency level on it. So we want to be able to add an attribute on the relationship Employee-Skillset.  its not an attribute on the Skillset but on the relationship between employee and skillset.