A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.

learn more… | top users | synonyms (1)

0
votes
1answer
50 views

How are additional fields stored in a lookup column?

When creating a lookup column it is possible to select additional fields. Does SharePoint store the values of these additional fields in the "child" list, or is a database join performed every time a ...
0
votes
1answer
40 views

List provision order on deployment

I have a generic list with just title fields. I'm trying to have another list use a lookup column to list each item. If I add the lookup to second list after deployment it works. But if I simply ...
1
vote
2answers
59 views

How to get LookupValue in ItemUpdating

I have a custom EventHandler for ItemUpdating on a list which has a Lookup column. If I look in the properties.AfterProperties for the column in the ItemUpdating event I get the LookupId value but ...
0
votes
1answer
78 views

More than one user not getting email alerts (SharePoint 2010)

I'm using SharePoint Designer 2010, and I'm creating an application which assigns tasks to other people. In the application, whenever a person is assigned a task, that particular person (or group of ...
0
votes
1answer
126 views

Send Email using Lookups from Workflows (SharePoint 2010)

I'm currently using SharePoint 2010 Designer, and the 2010 version of SharePoint. So I'm currently designing a SharePoint application which can assign tasks to other employees. Any tasks assigned ...
1
vote
0answers
36 views

Document Set lookup error

I have what seems like a minor bug when setting up a new document set. I've created a new content type based on a document set. One of the columns in the document set is a look up to a supplier list. ...
0
votes
1answer
520 views

Why is the associated lookup field not on the dispform.aspx?

I have three lists: Events (calendar) Customer1 (custom list from scratch) Customer2 (custom list from template) When I added the lookup of Customer1's ID and added the associated field "Title," ...
1
vote
1answer
80 views

SP 2013 REST API retrieve values from lookup library

I have a custom list 'MyList', containing a (single value) lookup field 'MyLookupField', which points to a library 'MyLibrary'. I now want to retrieve all items from 'MyList', including the Link to ...
2
votes
2answers
984 views

Invalid Look up Value . A look up field contains invalid data

I have a multi select Lookup column . I have to populate values to the lookup column from another column on a button click. I achieved it using below code but when i try to click ok/save it is ...
0
votes
0answers
22 views

Workflow Lookup Column in Site Workflow

I am using Sharepoint Designer 2013, and I am looking for a way to create a column lookup that looks up the current item and looks for the column Due Date. Can you do this and apply this workflow to ...
2
votes
2answers
1k views

Can text in a lookup column be displayed as text with no link?

SharePoint 2007 and have site curate access only. List-A has a column Name and that is a lookup to List-B, which only has names and no other information. Now when looking at lookup columns in views ...
2
votes
1answer
61 views

How does the look up function work?

I currently have two lists: List #1 have the fields country and colour (and several other fields that are irrelevant) List #2 have the field colour (and several other fields that are irrelevant) So ...
0
votes
2answers
965 views

Change the source on a lookup column?

Is it possible to change the data source on a lookup column? I have the source set to list A but I want to change it to List B.
0
votes
0answers
241 views

SPServices.SPCascadeDropdowns - Display Title rather than key

I'm using SPCascadeDropdowns to filter a child drop down which is working. However, I would like to display another column than the one in the relationship. I have created two lookup columns that ...
0
votes
1answer
70 views

SharePoint user group cannot access a certain field in a list

I want a certain group with contribute permission to be able to add and edit items into a list. One of these fields is a lookup value. This seems to cause trouble for the user, since the person cannot ...
1
vote
0answers
76 views

Creating a survey with a question being lookup column with filtering

So I need to create a survey on a monthly basis with just one question. Possible answers should be the values from a lookup column, but limited only to those from the previous (calendar) month. Is ...
0
votes
1answer
324 views

lookup external list

I have two tables: Documents Project task What I am looking for is the following: I have a page with project tasks in a hierarchy list (done) Clicking on a task will open an edit screen (done) ...
0
votes
1answer
55 views

How to show/Hide Data in dropDown field in a list depending on other list boolean field

I have two lists; Cars{brand,color,price} and Colors{designation,disponibility}. I made the field color as a lookup field to display colors from colors list. My problem is that i ONLY want just to ...
0
votes
2answers
45 views

How do I get a lookup column to filter in 2013?

I have data in page view that places the information for "project" in a lookup column. When I try to filter this column I get the error "this column cannot be filtered." How to I get this column to ...
0
votes
1answer
94 views

Value does not fall within the expected range during itemupdating

I've an event receiver and in itemupating i check if i've a value for a lookup field but get an exception. If i look in powershell, the column exist so the first if is ok but he can't test if it's ...
0
votes
1answer
787 views

“Value does not fall within the expected range” for Lookup field and its relation to Resource throttling of the web application

I was querying a list having many columns, some of them being look-ups. My query was to return a SPListItem based on one ID. Now, when I want to bind the value of look-up field from the SPListItem to ...
0
votes
1answer
35 views

Linking two lists to update when one or the other is changed

I am a bit of a SharePoint novice and I am having a few problems getting it to do what I would like it to do I want to link two separate lists: for example if I check a check box for one of the ...
0
votes
1answer
132 views

SharePoint 2013 - Reverse Lookup

I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are ...
3
votes
3answers
2k views

Deactivate the link of lookup-fields (2010)

On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen. Of ...
0
votes
1answer
82 views

Is it possible to populate a Lookup Field in a list with the List Content Types

What I'm trying to do is create a list-associated workflow that will start an Approval process with different Approvers, depending on Content Type. I cannot associate a workflow directly with each ...
2
votes
2answers
484 views

Autocomplete Lookup - Finding the Best Approach

In my past months learning the ins and outs of Sharepoint, I've had some difficulty finding a really good solution for creating an Autocomplete Lookup. I've explored a couple different options, each ...
0
votes
0answers
46 views

Look up field shows [object Object] on view

My list is custom code, which has a look up field to another list on same site. But when I create items, this field displayed as [object Object] on view (in display form, it still displays normally). ...
0
votes
0answers
42 views

Infopath lookup filtered fields from Sharepoint List working in InfoPath but not once form is Published

I have an InfoPath 2010 list form where "Current User" field has default value "Value[Name=PreferredName"] and refreshes value when formula is calculated. I then have a data connection to a SP list ...
2
votes
1answer
582 views

set or update multiple values cascading lookup field using client object model

I'm struggling since a couple of weeks with setting a multiple values cascading lookup field using a client object model, I could set the first value but then It show me an error of invalid lookup ...
0
votes
0answers
19 views

WP connection, lookup in children causes unexpected error when in view

I have the following scenario: MainList / ChildrenList {MainList:ID lookup column, ThirdList:ID lookup column} In the MainList display item form: WP#1: MainList with columns {ID, Title, ...
1
vote
1answer
284 views

Lookup column missing from document properties list

For the scope of this question I am working with SharePoint 2013. I have a Tasks list that was created with the OOTB (add an app) Task list. I have a Document Library that was created with the OOTB ...
2
votes
2answers
1k views

infopath form not updating fields

I have an infopath form that has three read-only fields referencing items in another list, but when someone opens the form the values never change, even if they have changed in the other list. It ...
1
vote
2answers
178 views

How to read lookup multi columns with the Sharepoint Listdata Client Object Model?

I have a list with a couple of multivalued lookupcolumns. When I try to do something with these fields the count is 0 even though I assigned it a couple of values. Below is a snippet of my code: (I ...
0
votes
0answers
58 views

Lookup column output includes strange characters in workflow

I am having problem displaying values from a cascade lookup to display the values in my email body. Example: I have a passenger column with this values already entered and save "Faith and John". Now, ...
0
votes
1answer
101 views

Add new button to a column with “single line of text data type” in SharePoint

I am trying to create a "Add new" button to a column called "other Passengers" which has a "Single line of text data type". Such that I can add up "0 to n" numbers of passengers not in our LDAP i.e ...
0
votes
1answer
81 views

How Do I Format A SharePoint 2010 Search Refiner Lookup

In SharePoint 2010 Search, I've added a new managed property that refers to a lookup column. I then added a custom refiner by modifying the Refinement Panel "Filter Category Definition". Basically, I ...
0
votes
2answers
185 views

Update a field after running standard approval workflow

I copied the approval workflow available. After completing the approval, I want one field related with the item that was approved to be updated. I tried different ways but nothing works. Should I ...
0
votes
1answer
173 views

Sharepoint 2010 site definition and Lookup column

I have created a custom list definition with a lookup field using Visual Studio. Everything is working perfect. After that I created a site definition using Visual Studio and added this custom list ...
2
votes
1answer
93 views

Lookup column with no duplicates

I have a library containing documents, each one regarding a project. I also have a custom list with tasks (for monitoring) which has a column PROJECT. There are more than one tasks per project so this ...
1
vote
3answers
1k views

Calculated Formula Insert From Another List

I have List A which has all information. List B has Col 1 that looks up one of the List A's columns. Col 2 is a Calculated column that want to use Col 1 but SharePoint is not able to see Col 1 ...
2
votes
0answers
66 views

Sharepoint 2013 not displaying lookup field as input

I have a lookup column whose datasource has many items (2 000+) and when creating an item that references the source list, a dropdown is not very suited for the task. In SP2010 when there were more ...
1
vote
2answers
119 views

Multi Level Lookup in SharePoint 2010?

I would like to achieve multi level lookup as below Cluster List structure Project List structure Project List Entries Phase List structure When I select the cluster, it should show only the ...
3
votes
1answer
917 views

How to create a lookup field that has a list column picker

How would I be able to create a list field in VS that would be a lookup to select columns from any list? I would preferably like to have something like the PickerTreeView.aspx, but instead of ...
0
votes
1answer
167 views

Lookup value not being copied

I am using following xml code (copy.asmx > method CopyIntoItems). Per Microsoft http://msdn.microsoft.com/en-us/library/websvccopy.copy.copyintoitems(v=office.14).aspx I should be able to update ...
0
votes
2answers
682 views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field throw PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl $myCustomList = ...
0
votes
0answers
47 views

How to select look up column in sharepoint workflow

I have a list "Tasks" which has "Assigned to" field. This "Assigned to" field is a lookup for another list column. (The list is "Team" and column is "firstnamelastname"). Now I am using a workflow. ...
1
vote
0answers
101 views

SPD 2010 workflow, update (add and delete) lookup column

I have a list (with a custom InfoPath form) in which I have items that have a Parent / Child relationship with two lookup column to the title column of same list. The two lookups are "Child of" single ...
1
vote
2answers
5k views

Is it possible to make a lookup column that looks up “Person or Group” type from another list?

I'd like to create a lookup column in my list (hopefully using OOTB functionality) that shows a column from another list. Sounds simple enough, but the available columns to choose to lookup from my ...
0
votes
1answer
49 views

Add dynamic link to InfoPath multi-selection field

I had to modify a form using InfoPath in order to achieve a feature that populates a multiple-selection field with data returned from a query (similar to what this tutorial outlines). Before making ...
0
votes
0answers
17 views

I need to pull the version data from 6 Libraries into a single list

I have an existing SharePoint2010 list. It contains information about document approvals (all manual data). I need to compare the manually approved version number to the current actual document ...