Create Lookup Field Powershell

Question

I am using SharePoint 2013, I need to create a lookup field through PowerShell.

I tried this code but is not working:

$SiteUrl = "http://mySite" 
$WebObj = Get-SPWeb -identity $SiteUrl 
$myCustomList = $WebObj.Lists["newList"]
$ParentList=$WebObj.Lists.item("listTarget")
$myCustomList.Fields.AddLookup("NewLookupField",$ParentList.id,$false)  
$SPChildListLookupField = $myCustomList.Fields[$_.NameField]
$SPChildListLookupField.LookupField = $ParentList.Fields["fieldTarget"]

I want to lookup to a list on a custom field (not the default Title)

Nk SP · Accepted Answer · 2014-04-29 18:55:23Z

2

I solved updating the field.

$SiteUrl = "http://mySite" 
$WebObj = Get-SPWeb -identity $SiteUrl 
$myCustomList = $WebObj.Lists["newList"]
$ParentList=$WebObj.Lists.item("listTarget")
$myCustomList.Fields.AddLookup("NewLookupField",$ParentList.id,$false)  
$SPChildListLookupField = $myCustomList.Fields[$_.NameField]
$SPChildListLookupField.LookupField = $ParentList.Fields["fieldTarget"]

//Added this line
$SPChildListLookupField.Update()

answered Apr 29, 2014 at 18:55

Nk SP

2,8736 gold badges40 silver badges64 bronze badges

Add a comment |

Michael Colbs · Accepted Answer · 2014-04-29 15:25:29Z

0

Try to change this line.

$myCustomList = $WebObj.Lists.item("newList")

answered Apr 29, 2014 at 15:25

Michael Colbs

3,9314 gold badges52 silver badges99 bronze badges

Thanks, I tried but it is not working :/

Nk SP
– Nk SP

2014-04-29 15:43:33 +00:00
Commented Apr 29, 2014 at 15:43
Does it throw an error? Is the field created at all?

Michael Colbs
– Michael Colbs

2014-04-29 16:11:26 +00:00
Commented Apr 29, 2014 at 16:11

Add a comment |

Sandeep Nandey · Accepted Answer · 2017-07-26 11:00:28Z

Resolved:

Use below script to add Lookup field:

Provide the List Id for the field xml property 'List'

$Field_LookupList = $RootWeb.Lists.GetByTitle('DemoListForLookup')
$clientContext.Load($Field_LookupList)
$clientContext.ExecuteQuery()

$Field_LookupList_Id = $Field_LookupList.Id


$fieldXml="<Field Type='Lookup'  DisplayName='"+ $Field_DisplayName +"' Required='"+$Field_Required+"'  StaticName='"+$Field_InternalName+"' Name='"+$Field_InternalName+"' List='"+$Field_LookupList_Id+"' ShowField='"+$Field_LookupListFields+"'/>" 
$spoList.Fields.AddFieldAsXml($fieldXml,$true,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldInternalNameHint)
$spoList.Update()
$clientContext.ExecuteQuery()

Stack Exchange Network

Create Lookup Field Powershell

3 Answers 3

Your Answer

Linked

Hot Network Questions

Create Lookup Field Powershell

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions