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
62 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
67 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
323 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
44 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
90 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
642 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
33 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
118 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 ...
2
votes
0answers
55 views

Create a lookup field that is text instead of a drop-down (or similar)?

In SharePoint, I have a list (staff) and a document library and have successfully made a custom lookup column/field from the document library pointing to the staff list (staff id column). This ...
0
votes
1answer
77 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
404 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
45 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
40 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
572 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
249 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
171 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
56 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
68 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
149 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
164 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
83 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
63 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
109 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
910 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
162 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
591 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
97 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 ...
0
votes
2answers
4k 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
47 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 ...
0
votes
1answer
87 views

Lookup items says “Count Related”

I am not very skilled with SharePoint, but I have been tasked with using it on a daily basis, and am always at least "trying" to make improvements to it. The issue I am having today is that I have 2 ...
1
vote
2answers
1k views

Cascading Dropdown for Lookup with more than 20 items

I have implemented cascading dropdown using SPCascadingDropdown (SPServices) it was working for lookup with 19 items . When the items count became more than 20 , the lookup column is displayed as ...
1
vote
2answers
288 views

SharePoint Best practice for multiple images per list item

I have to create a simple Classifieds system in SharePoint. One classified item can have multiple images. Does anyone have suggestions on design for this initiative? For example, should I have a ...
0
votes
1answer
61 views

Is it possible to create an automatic connection between the look up field and another column?

Im struggling with a problem in SharePoint 2013. I have one list with procedure codes, which includes the “procedure code” plus some other fields In another table, i have volume data related to ...
1
vote
2answers
201 views

Save Document library lookup field using Rest API

How can I save document library lookup field using REST API Post in a SharePoint list? I tried like 'docItem':'1;#test' But, it is throwing an error : {"error":{"code":"-1, ...
0
votes
0answers
39 views

Weird lookup column issue

I have process that I setup to summarize a list in a lookup column in another list and to automatically generate emails based on the lookup column. I noticed that things weren't behaving quite as ...
0
votes
1answer
362 views

Using additional fields from Lookup in Word Document Information Panel

I have a Document Library in which I have a lookup columns to a Contact list, the contact list also includes linked values as email, phone numbers and so on. When creating a new word document in ...
0
votes
0answers
164 views

How to create a filtered list on Lookup columns

I have created a couple of custom lists, one called Partners, the other named Countries. The Countries list is populated with a list of the world's countries. The Partners list is a list of our ...
1
vote
1answer
77 views

Client API lookup field: LookupId has a value but LookupValue is null

I'm doing something very similar to this question; trying to get the value of a lookup field using the Sharepoint .NET client API. I can get the Id, but not the value. For some reason, the value is ...
1
vote
2answers
470 views

add a new value to a lookup field

I have a custom list in SharePoint 2013. This list contains text and lookup fields. While I do not have an issue populating the text fields, the lookups are giving me trouble. I found and tried ...
7
votes
3answers
228 views

Working around the “Lookup column threshhold”

To level-set, I'm working in a large enterprise with no Farm Admin access or access to SP Designer. I have out-of-the-box capabilities only as owner of a team site. I'm building a roster/schedule ...
2
votes
3answers
826 views

Binding lookup fields to document library template

I have features that define site content types and a document library template that uses these content types. Now, when I create a document library from the template, all the content types appear ...
0
votes
2answers
4k views

How can I combine multiple Lists into one view for editing

I had a list with 18 lookups which exceeded the SharePoint 2010 threshold. So I broke it up into 3 lists all having the same "ProjectID" column as a lookup to the first column so that there is only ...