Lookup Field with Picker allows you to select list items from a lookup list via a searchable and configurable picker dialog.

Features

  • Single- and multi-Selection Mode
  • Cross site picking
  • Search in picker dialog
  • Search Operators: equals, not equal, contains, begins with, greater than, greater or equal than, less than, less or equal than.
  • Select fields you would like to search for.
  • Relationship behaviors
  • Supports default values (constants, current user id and default values by url param, useful for 1-n scenarios) must be configured via PowerShell
  • Languages: English, German
  • Delivered as SharePoint Solution Package (WSP)

Not supported

  • Document Information Panel
  • Data Sheet Views

Requirements

  • SharePoint Foundation 2010

Installation

Install Lookup Field with Picker with the following commands within the SharePoint Management Shell:

  • Add-SPSolution "C:\Install\iLoveSharePoint.Fields.LookupFieldWithPicker.wsp"
  • Install-SPSolution ilovesharepoint.fields.lookupfieldwithpicker.wsp -WebApplication http://myserver –GACDeployment

Usage

Add Lookup Field with Picker

You can add a Lookup Field with Picker column either to a list or a content type.

image

Configure Lookup Field with Picker

Select the source site, list and column of the lookup.

image

Select the columns that you want to use for search in picker dialog.

image

Select the additional columns that you want to show in the target list.

image

Choose whether multiple values are allowed or not and what should be happen when the picked item is being deleted. The relationship behaviors “restrict delete” and “cascade delete” are only supported for the single lookup mode (Known Issue: When you choose multiple values and select any other relationship behavior than “none” an exception will be thrown).

image

Pick Items

Open the picker dialog (or enter a value and resolve the entity with the first button)

image

Find a and select item(s) within the picker dialog.

image

Done.

image

Last edited Jun 1, 2011 at 10:13 PM by cglessner, version 4

Comments

RBan Jan 15, 2013 at 10:59 PM 
This lookup field works great. The one problem is certain field types (yes/no and choice so far) are not available to display.

sureshpydi Aug 30, 2012 at 12:23 PM 
Great Tool...But it looks like working same as lookup field, that when ever we update the field that to search, We are losing previous things. Is there any Update for that ?

NeerajAgarwal Jun 2, 2012 at 10:42 AM 
It's awesome to use lookup field with picker but the problem is that when we try to access the list items on the basis of 'lookup field with picker' fields value using CAML query than it requires to define the the field type in CAML query.
so can anyone please tell me what type we will use in CAML query for this field,
Thanks in advance.

earthink Jun 2, 2012 at 12:52 AM 
This is a great feautre I look for very long.
But it can not lookup a "folder" content type item.
Can you add this feature?
Thank you!

giustis5 Apr 11, 2012 at 1:45 PM 
are there any updates planned for this to work with DIP or datasheet view? it would be very useful for these features. thanks

addrockride Oct 20, 2011 at 3:17 PM 
This was working great until last week when we got an injection of hotfixes on our system. We redeployed the picker and oddly now, the picker only works if you do not set "ID" as the "In this column:" property. Any suggestions?