Linking data between lists

%3CLINGO-SUB%20id%3D%22lingo-sub-881352%22%20slang%3D%22en-US%22%3ELinking%20data%20between%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881352%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20(A)%20that%20I%20want%20to%20copy%20data%20from%20several%20columns%20onto%20list%20(B).%20However%2C%20when%20I%20use%20the%20Lookup%20as%20the%20column%20type%2C%20not%20all%20columns%20are%20available%20from%20list%20(A).%20I've%20never%20had%20this%20issue%20in%20the%20past%20when%20linking%20multiple%20lists.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-881352%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-882186%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20data%20between%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-882186%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415766%22%20target%3D%22_blank%22%3E%40colewiler%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELookup%20columns%20can%20only%20only%20be%20%22%3CSPAN%3ESingle%20line%20of%20text%22%2C%20%22Number%22%20and%20%22Date%20and%20Time%22.%20If%20your%20missing%20columns%20are%20unsupported%20then%20that%20would%20explain%20the%20issue%20you%20are%20experiencing.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMore%20information%20located%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FCreate-list-relationships-by-using-unique-and-lookup-columns-80A3E0A6-8016-41FB-AD09-8BF16D490632%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FCreate-list-relationships-by-using-unique-and-lookup-columns-80A3E0A6-8016-41FB-AD09-8BF16D490632%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20hope%20this%20helps.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENorm%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a list (A) that I want to copy data from several columns onto list (B). However, when I use the Lookup as the column type, not all columns are available from list (A). I've never had this issue in the past when linking multiple lists.

1 Reply

Hi @colewiler,

 

Lookup columns can only only be "Single line of text", "Number" and "Date and Time". If your missing columns are unsupported then that would explain the issue you are experiencing.

 

More information located here: https://support.office.com/en-us/article/Create-list-relationships-by-using-unique-and-lookup-column...

 

I hope this helps.

 

Norm