Using "Connected Lookup Field" column

%3CLINGO-SUB%20id%3D%22lingo-sub-854611%22%20slang%3D%22fr-FR%22%3EUsing%20%22Connected%20Lookup%20Field%22%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854611%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20using%20SharePoint%202016%2C%20I%20want%20to%20fill%20a%20column%20inside%20a%20list%20with%20information%20depending%20on%20an%20other%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20use%20%22Connected%20Lookup%20Field%22%20column%2C%20but%20the%20result%20column%20is%20blank.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20to%20give%20more%20context%3A%3C%2FP%3E%3CP%3EI%20have%20my%20first%20list%20with%20multiple%20columns%20and%20a%20column%20%22number%22%20which%20is%20unique%20and%20a%20second%20list%20with%20the%20same%20column%20%22number%22%20but%20with%20more%20records.%3C%2FP%3E%3CP%3EIn%20my%20first%20list%2C%20I%20have%20a%20column%20%22short%20description%22%20and%20I%20want%20to%20retrieve%20this%20column%20%22short%20description%22%20in%20my%20second%20list.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131712i45F319BC268BD694%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22clipboard-image-0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EDo%20you%20know%20how%20to%20manage%20it%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-854611%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-854735%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20%22Connected%20Lookup%20Field%22%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408557%22%20target%3D%22_blank%22%3E%40RobinD2400%3C%2FA%3E%26nbsp%3Bhey%2C%26nbsp%3B%3C%2FP%3E%3CP%3Etry%20this%20-%26gt%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Fsharepoint-lookup-fields%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Fsharepoint-lookup-fields%3C%2FA%3E%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1624585126%22%20id%3D%22toc-hId-1624585126%22%20id%3D%22toc-hId-1624585126%22%20id%3D%22toc-hId-1624585126%22%20id%3D%22toc-hId-1624585126%22%20id%3D%22toc-hId-1624585118%22%3EDefine%20the%20RepairShop%20list%20and%20add%20data%3C%2FH3%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-856698%22%20slang%3D%22fr-FR%22%3ERe%3A%20Using%20%22Connected%20Lookup%20Field%22%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856698%22%20slang%3D%22fr-FR%22%3EThanks%20for%20this%20link.%20%3CBR%20%2F%3EWhat%20I%20find%20is%20that%20there%20is%20no%20way%20to%20use%20%22Lookup%22%20column%20in%20a%20table%2C%20so%20that%20is%20why%20I%20tried%20to%20use%20%22Connected%20Lookup%20Field%22%20column.%20%3CBR%20%2F%3EAm%20I%20right%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857061%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20%22Connected%20Lookup%20Field%22%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408557%22%20target%3D%22_blank%22%3E%40RobinD2400%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssuming%20both%20lists%20are%20on%20the%20same%20site%2C%20I'm%20not%20sure%20why%20you%20aren't%20using%20a%20regular%20lookup%20column.%20From%20there%2C%20it's%20pretty%20basic.%20But%20understand%20that%20only%20simple%20text%20fields%20(single%20line%20of%20text%2C%20date%2C%20etc.)%20are%20available%20in%20a%20lookup%20column.%20So%20you%20can't%20look%20up%20to%20a%20people%20field%20or%20calculated%20column.%20I've%20gotten%20tripped%20up%20by%20field%20type%20many%20times.%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDepending%20on%20what%20you're%20looking%20up%20to%2C%20another%20option%20might%20be%20to%20use%20managed%20metadata.%20That%20would%20give%20you%20the%20option%20to%20lookup%20against%20the%20same%20list%20of%20values%20across%20multiple%20sites.%20So%20if%20you%20have%20a%20list%20of%20business%20units%2C%20create%20it%20as%20a%20managed%20metadata%20column%20and%20then%20reuse%20that%20column%20across%20your%20site%20collection%20or%20even%20at%20the%20enterprise%20level.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857273%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20%22Connected%20Lookup%20Field%22%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F57004%22%20target%3D%22_blank%22%3E%40Rachel%20Davis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20use%20%22Lookup%20column%22%20because%20I%20do%20not%20manage%20to%20use%20it.%20When%20I%20create%20a%20%22Lookup%22%20column%2C%20I%20select%20the%20reference%20list%20I%20want%20and%20then%20the%20column%20which%20is%20the%20same%20as%20the%20one%20in%20my%20second%20list%3B%20I%20also%20try%20to%20add%20others%20fields%20to%20see%20if%20it%20can%20be%20filled.%3CBR%20%2F%3EBut%20finally%2C%20the%20columns%20are%20empty.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20564px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131962i791AA72FBE39E82A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture.png%22%20title%3D%22capture.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858780%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20%22Connected%20Lookup%20Field%22%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858780%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408557%22%20target%3D%22_blank%22%3E%40RobinD2400%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20how%20a%20standard%20lookup%20column%20works%20for%20me%3A%3C%2FP%3E%3COL%3E%3CLI%3ECreate%20source%20list%20and%20add%20values%20that%20should%20appear%20in%20the%20dropdown%3C%2FLI%3E%3CLI%3EIn%20master%20list%2C%20create%20column%20%26gt%3B%20type%20%3D%20Lookup%20%26gt%3B%20select%20source%20list%20%26gt%3B%20select%20field%20for%20values%3C%2FLI%3E%3CLI%3EAdd%2FEdit%20items%20and%20select%20values%20from%20dropdown%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%20can't%20tell%20why%20you%20have%20no%20values%20in%20your%20screenshot.%20Do%20you%20have%20values%20in%20your%20source%20list%3F%20Have%20you%20edited%20the%20existing%20list%20items%20to%20select%20the%20value%20in%20the%20dropdown%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20322px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132129i941DCB775F2561AE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Lookup1.png%22%20title%3D%22Lookup1.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ECreate%20lookup%20column%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132128i17B9E86A46A97AF8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Lookup2.png%22%20title%3D%22Lookup2.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Eedit%20existing%20item%20to%20select%20from%20dropdown%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20611px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132127i8BE669799DF1522F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Lookup3.png%22%20title%3D%22Lookup3.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EValue%20displayed%20in%20list%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

While using SharePoint 2016, I want to fill a column inside a list with information depending on an other list.

 

I tried to use "Connected Lookup Field" column, but the result column is blank.

 

In order to give more context:

I have my first list with multiple columns and a column "number" which is unique and a second list with the same column "number" but with more records.

In my first list, I have a column "short description" and I want to retrieve this column "short description" in my second list.

clipboard_image_0.png

Do you know how to manage it?

Thanks

 

5 Replies
Thanks for this link.
What I find is that there is no way to use "Lookup" column in a table, so that is why I tried to use "Connected Lookup Field" column.
Am I right?

@RobinD2400 

Assuming both lists are on the same site, I'm not sure why you aren't using a regular lookup column. From there, it's pretty basic. But understand that only simple text fields (single line of text, date, etc.) are available in a lookup column. So you can't look up to a people field or calculated column. I've gotten tripped up by field type many times. :(

 

Depending on what you're looking up to, another option might be to use managed metadata. That would give you the option to lookup against the same list of values across multiple sites. So if you have a list of business units, create it as a managed metadata column and then reuse that column across your site collection or even at the enterprise level.

@Rachel Davis 

I do not use "Lookup column" because I do not manage to use it. When I create a "Lookup" column, I select the reference list I want and then the column which is the same as the one in my second list; I also try to add others fields to see if it can be filled.
But finally, the columns are empty.capture.png

@RobinD2400 

This is how a standard lookup column works for me:

  1. Create source list and add values that should appear in the dropdown
  2. In master list, create column > type = Lookup > select source list > select field for values
  3. Add/Edit items and select values from dropdown

I can't tell why you have no values in your screenshot. Do you have values in your source list? Have you edited the existing list items to select the value in the dropdown?

Create lookup columnCreate lookup columnedit existing item to select from dropdownedit existing item to select from dropdownValue displayed in listValue displayed in list