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
Highlighted
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
Highlighted

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