Add a lookup field for a list in Sharepoint Client Model

Question

This is what I've achieved do far:

                        Field parent = list.Fields.AddFieldAsXml(
                       @"<Field Type='Lookup' DisplayName='ParentContentType' 
                                Required='FALSE' EnforceUniqueValues='FALSE'
                                List= 'ContentTypes'
                                ShowField='Title' UnlimitedLengthInDocumentLibrary='FALSE' 
                                RelationshipDeleteBehavior='None' 
                                StaticName='ParentContentType' Name='ParentContentType'/>",
                   true, AddFieldOptions.DefaultValue);

But I am not able to set the Get information from: value for this lookup field.

Can anyone please suggest how to achieve it?

Code added:

var listCreationInfo = new ListCreationInformation();
listCreationInfo.Title = "New List";
listCreationInfo.TemplateType = (int)ListTemplateType.CustomGrid;
List list = web.Lists.Add(listCreationInfo);
list.Update();
ctxt.ExecuteQuery();
Field parent = list.Fields.AddFieldAsXml(
    @"<Field Type='Lookup' DisplayName='ParentContentType' 
    Required='FALSE' EnforceUniqueValues='FALSE'
    List= 'ContentTypes'
    ShowField='Title' UnlimitedLengthInDocumentLibrary='FALSE' 
    RelationshipDeleteBehavior='None' 
    StaticName='ParentContentType' Name='ParentContentType'/>",
    true, AddFieldOptions.DefaultValue);

Please check my answer & let me know if it helps [http://stackoverflow.com/questions/28542452/add-a-lookup-field-for-a-list-in-sharepoint-client-model/28547853#28547853] — Sharique Ansari, Feb 16 '15 at 18:22

Sharique Ansari · Answer 1 · 2015-02-16T18:27:32.627

Please try this.

public static void AddLookupField()
{
            string lookupSchema = @"<Field Type='Lookup' DisplayName='mylookup2' 
                                    Required='FALSE' EnforceUniqueValues='FALSE'
                                    List='{70d6098c-6ba0-4e9e-b101-a60b88fc226a}' 
                                    ShowField='Title' UnlimitedLengthInDocumentLibrary='FALSE' 
                                    RelationshipDeleteBehavior='None' 
                                    StaticName='mylookup' Name='mylookup2'/>";

            ClientContext clientContext = new ClientContext("http://sharepoint10");
            List list = clientContext.Web.Lists.GetByTitle("listtitle");
            FieldCollection fields = list.Fields;

            clientContext.Load(list);
            clientContext.Load(fields);

            clientContext.ExecuteQuery();

            Field lookupField = fields.AddFieldAsXml(lookupSchema, true, AddFieldOptions.AddToDefaultContentType);
            lookupField.Update();

            clientContext.Load(lookupField);
            clientContext.ExecuteQuery();


}

Add a lookup field for a list in Sharepoint Client Model

1 Answers1