Fix SharePoint Lookup Column Values Blank Issue using PowerShell

Problem: SharePoint lookup columns are broken in the below scenarios: 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…

Read more

Add Lookup Field to SharePoint List using PowerShell

Requirement: PowerShell script to add lookup field to SharePoint list: Scenario: You have a parent list called “Parent Projects” and a child list “Project Milestones”. The “Parent Project Name” field in the child list is being looked up from the parent list’s “Project Name” field. PowerShell to Add Lookup Field to SharePoint…

Read more

How to Add a Column to SharePoint List using PowerShell?

Requirement: Add columns to SharePoint list using PowerShell. PowerShell Script to Add Columns to SharePoint List: You can also add fields to SharePoint list from their field schema. Here is how: While the above script is fairly simple, to add other type of fields such as choice fields, lookups, etc.  refer below…

Read more

How to Create a Cross-Site Lookup Site Column in SharePoint 2013?

Lookup columns are used to get its value from a field in another list in SharePoint sites. Lookup fields also provide a relationship between lists/libraries. Is it possible to create a lookup column from the list on another site? Sure, use site columns, so that you can utilize SharePoint 2013 lookup column…

Read more

Find All Lists which Exceeds List View Lookup threshold in SharePoint

Requirement: Resource throttling feature in SharePoint controls resource usage on SharePoint Farm for optimum usage. My requirement was to find all lists which are exceeding configured list view lookup threshold limit in SharePoint. PowerShell script to find All Lists which are Exceeding List View Lookup threshold: This script produces a CSV file…

Read more

Remove Hyperlink from Lookup Columns in SharePoint

Problem:When we add a lookup column to any SharePoint list, it appears with the link to the parent item in SharePoint list views. Quite often, the end-user clicks on the lookup link and edits the parent lookup item by mistake – People get confused about which link to click. So we wanted…

Read more

Increase SharePoint 2013 Lookup Column Width

Requirement: Increase SharePoint 2013 multi-lookup field width Solution: Use CSS styles to set lookup field width in SharePoint! Here is how: Navigate to: http://your-sharepoint-site.com/Lists/Your-List/editform.aspx Click on “Site Settings” gear >> Edit Page Click on the “Add Web Part” link and then choose “Script Editor “from the “Media and Content” group Click on…

Read more

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

Problem: “This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.” Root Cause: Usually, You’ll get this error message when your List view has many Lookup fields. The threshold feature is introduced in SharePoint 2010 to avoid performance…

Read more

Get / Set Lookup Field Values in SharePoint List using PowerShell

Here is my PowerShell code snippets to read/write lookup field values in SharePoint lists. Scenario: Consider you have a parent list called “Parent Projects” and child list “Project Milestones”. The “Parent Project Name” field from child list is being looked up from the parent list’s “Project Name” field. Get lookup field value…

Read more