Fix SharePoint Lookup Column Values Blank Issue using PowerShell
Problem: SharePoint lookup columns are broken in below scenarios:
Solution:
If you come across any of the above scenario and your lookup column is broken, you have to re-link the lookup column with its parent list. Use this PowerShell script to fix the lookup columns in SharePoint.
PowerShell Script to fix SharePoint 2013 Lookup Column Blank Values:
This fixes SharePoint 2013 lookup column blank values issue.
- If the parent lookup list is deleted and recreated - Then the connection between lookup list and the lookup column will be broken and you'll get empty values!
- When you export-import a subsite or lists, lookup fields become orphaned from its parent list!
- When you save a lists as list templates and use it in another site, the lookup column no longer works - even though you created the parent lookup list in the target site!
Solution:
If you come across any of the above scenario and your lookup column is broken, you have to re-link the lookup column with its parent list. Use this PowerShell script to fix the lookup columns in SharePoint.
PowerShell Script to fix SharePoint 2013 Lookup Column Blank Values:
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Parameters $SiteURL="http://intranet.crescent.com/" $ListName="Project Milestones" $LookupColumnName="Parent Project" $LookUpListName="Projects" #Parent List #Get the Objects $Site = Get-SPWeb $SiteURL $List = $web.Lists[$ListName] $LookupList = $web.Lists[$LookUpListName] $Column = $List.Fields[$LookupColumnName] #Update column schema $Column.SchemaXml = $Column.SchemaXml.Replace($Column.LookupWebId.ToString(), $Web.ID.ToString()) $Column.SchemaXml = $Column.SchemaXml.Replace($Column.LookupList.ToString(), $LookupList.ID.ToString()) $Column.Update() Write-host "Lookup column fixed!" -f Green
This fixes SharePoint 2013 lookup column blank values issue.
No comments:
Please Login and comment to get your questions answered!