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
133 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
75 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
61 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
94 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
871 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
137 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
383 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
46 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
94 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
41 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
69 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
216 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
54 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
190 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
317 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
155 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
68 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
454 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
217 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
803 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 ...
2
votes
2answers
2k views

Is it possible to have a lookup field with multiple source lists?

I have two lists: list A and list B. List A should have a new multiple choice lookup column that allows the user to choose items from both list A and list B. Is this even possible? I have a kind of ...
2
votes
1answer
117 views

Filtered lookup column with 'WHERE' clause

I have 2 lists: List 1 and List 2. List 1 has 2 columns 'supplier' and 'broker'. List 2 has 2 columns 'nature' and 'supplier name'. My requirement is 'supplier' is a lookup from 'supplier name' ...
2
votes
2answers
931 views

SP 2013 - Updating a multi-value lookup field via the REST API

When adding a new item to list via the Sharepoint 2013 REST API I want to populate one of its multi-value lookup columns. I've tried passing in an array of Ids or a string with separators but nothing ...
0
votes
1answer
61 views

Calculated Lookup from another Lookup

I'm sure this has probably come up before but I'm getting nowhere fast so I thought I'd ask the question! I have a list called Areas, which has an Area column (text). I have a second list called ...
1
vote
1answer
221 views

During ItemAdding of parent list, assign lookup field of a child list

I'm attempting to create a projects/tasks lists. When a user creates "ProjectA", I want to create a list of tasks based on the template that was selected for that project. In general, everything is ...
1
vote
1answer
74 views

Example of a workflow pulling lookup column data for use in a calculated value column

I'm looking for an example of a workflow using SharePoint Designer 2010 that pulls information from a lookup list or via a lookup column and places it within a hidden field for use in a calculated ...
3
votes
1answer
1k views

Help with getting the value of a look up field

Currently, I am using an ajax request to access the list items. The fields that are not lookups come as expected but the lookup fields come across as an ID of the object that corresponds to its ...
2
votes
0answers
89 views

Sorting a Lookup Column from Survey that pulls from Calculated Field SP 2010

I'm looking for a way to sort a Lookup question in a survey that pulls from a calculated field. Specifically, I have it lookup a calculated field that combines the date and name from a list. I want ...
2
votes
3answers
2k views

Can a SharePoint 2010 lookup column point to a multi-line rich text field from same list

Can a SharePoint 2010 lookup column point to a multi-line rich text field in same list? i dont find multiline column while creating a lookup column. Is there any way to achieve this. Because my ...
5
votes
3answers
5k views

Deploying List Instance - LookupMulti Type Column in XML

So I have been able to populate rows with Lookup type fields as such: <ListInstance ... > <Data> <Rows> <Row> <Field ...
1
vote
1answer
1k views

How to Find Lookup field list using Programmatically

How to find the list that a particular lookup column in a list is bound to, programatically?
1
vote
2answers
6k views

How to get multivalue lookup column items from sharepoint list to infopath?

I am on a project. I have a list that have 2 columns. One is the title, other is a multiple value look up column from another list. Everything is ok, working well. And call it ListA. BUT, i am ...
2
votes
1answer
162 views

Uploading a file to a library with curl - how do you also update the column values

I'm able to upload files from linux to sharepoint using something like this curl -u "Domain\Account":'Password' --ntlm -k -T report.xls https://portal.company.com/test_site/test_doc/ I would ...
1
vote
0answers
18 views

Display deactivated items in lookup column

We have a list of projects. One column is named Status (a choise Active or Finished) One column is Active Projects (a calculated column which shows only the actieve projects) One column is named ...
1
vote
3answers
750 views

Get value of lookup field

I have a cascading lookup using two lists on my SharePoint 2010 site. I want to get the value of first selection made in the lookup and show/hide other fields on my custom form based on that first ...
2
votes
2answers
1k views

Copy lookup value from one list to another with SPD workflow

I have two lists and a workflow that copies items from list A, if they get approved, to list B. Problem is that a field in list A uses a lookup list, if I select Dog in the Field Animal and save the ...
1
vote
0answers
161 views

Site Lookup Column As Managed Property

Please let me know if my logic here is incorrect or suggest better alternative. This is hosted on Office 365. I have a Site Lookup column (EventLookup) that is linked to a list on my Root Site --> ...
0
votes
2answers
235 views

Lookup field not updating when the document uploading

I am uploading document programically and passing lookup field value but its not get updated, how to handle this?
2
votes
1answer
250 views

Calculated field shows seemingly random number when set to be empty

I'm trying to set up this solution for creating a filtered lookup: How to make a filtered lookup field I have set up an ItemAvailable column like this: The column "Availability" is a choice ...
0
votes
0answers
50 views

I can't change the “Return Field As” in SPD for a “lookup” type column

I recently used this topic to help me create a WF that creates a new discussion item every time a new issue item is added to the issue tracker, however I ran into a small issue when changing the ...
3
votes
1answer
610 views

CAML Query on a Lookup Field that points to a Calculated Field throws Exception

I wrote some CAML Queries to get data from a List that has lookups on another List. All is working fine as long as I do not reference a Lookup Field which points to a Calculated Field. I tried ...
2
votes
1answer
136 views

Lookup field doesn't support some field types

Its looking more and more like you can't add additional fields that are anything other than string boxes (no person or yes/no etc) is there any work around for this?
0
votes
1answer
222 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
1
vote
1answer
671 views

Extending Content Types from Content Type Hub

I have defined a content type in content type hub. I would like to use this content type on a site (other than the hub) but also to extend it with an additional (lookup) column. Is it possible to do ...