Destination Column
If you want to;
- Set a value in a lookup column.
- Import to a list that contains a lookup column
- Import to a document library that contains a lookup column
You can use an import mapping of lookup;
Configuration
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
<ImportMapping xsi:type="ImportMapping_Lookup"> <!-- This is the field of type lookup.--> <DestinationField>Job</DestinationField> <SourceColumn>Job Title</SourceColumn> <!-- This is the list that contains the lookup values --> <LookupListTitle>Items</LookupListTitle> <!-- This is the field in the lookup list the value of which matches the value in the source column--> <LookupFieldInternalName>Title</LookupFieldInternalName> <!-- This is the CAML value type Text,Number,DateTime,Guid,MultiChoice,Lookup for the field on in the lookup list that matches the value specified in the source column --> <LookupFieldCAMLType>Text</LookupFieldCAMLType> </ImportMapping> |
Source
The source could be;
Further thoughts
If you want to;
- Set a value in an external lookup column.
- Import to a list that contains an external lookup column
- Import to a document library that contains an external lookup column
Then do get in touch.