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)

1
vote
4answers
7k views

How do you connect a Calendar List to a Project Tasks list using Web Part Connections?

I created a Calendar List and a Project Tasks list. Then I added a lookup from the Tasks list to the Calendar list. However, when I try to connect the two with the related field visible on both list ...
1
vote
2answers
71 views

Add a lookup field for a list in Sharepoint Client Model

This is what I've achieved do far: var listCreationInfo = new ListCreationInformation(); listCreationInfo.Title = "New List"; listCreationInfo.TemplateType = (int)ListTemplateType.CustomGrid; List ...
0
votes
1answer
57 views

Making imported column to a Lookup Value

I did a Excel import to a SharePoint list, there are 3-4 columns that are lookup values. Is there a way to make those columns lookup values again? I tried to edit the column but only options seem to ...
0
votes
1answer
48 views

Sharepoint 2010 - Make assigning users easier

we are using Sharepoint 2010 and maintaining an Action Item/Issue tracker list (for a limited number of people, <10). To make assigning Action Items to users easier I want to implement to option to ...
0
votes
1answer
43 views

Why using Decimal in this CAML Query is not returning correct records?

I have the following table: DoubleNumber ------------- 10.50 44.77 88.90 I am using the following CAML Query: query.Query = "<Where><Contains><FieldRef ...
4
votes
2answers
789 views

REST API Filter by multilookup property

Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer ...
0
votes
1answer
18 views

How to recognize which button was pressed in workflow task outcome

I am creating a workflow, and I have a modified task outcome with custom buttons. It looks like this: When the user presses "Extension Approved" I want the loop in my workflow to continue running, ...
3
votes
3answers
3k views

GridView lookups displaying as “id;#value”

I am using an ASP.net gridview. The datasource is SPList.Items.GetDataTable(). The gridview is working fine; however, lookup and multilookup columns display as "id;#value". Is there any way to just ...
0
votes
1answer
54 views

Auto-completing Lookup Columns for Datasheet View and Allowing Multiple Values

I have a user that fills out their list most of the time in Datasheet view for quick data entry. They have a lookup column for single values only where they can just start typing in the name they're ...
0
votes
0answers
578 views

Workflow Error: Coercion Failed: Input cannot be null for this coercion

I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here's how the data looks: Look Up Title ...
2
votes
5answers
5k views

How to Force Alphabetical Order in Lookup Dropdown with Multiple Choices

In my portal (Sharepoint Server 2010 Enterprise) I have a simple list with only the title field. I've created about 50 entries in the list. In another list, I have a lookup column that pulls from ...
0
votes
1answer
27 views

SP 2010 - Lookup Column not working with Conditional Formatting

I have a lookup column for Tabs: Major Sub-1 Sub-2 Sub-3 Technical Pricing I need to setup conditional formatting so the row color changes with the level of tab selected. I can do this with drop ...
0
votes
1answer
39 views

Display Lookup ID into list view

How can I display the lookup Id (of a lookup field) instead of title into a list view? I am using SharePoint 2013 on-premise.
0
votes
1answer
46 views

How do I send data to a lookup field with ReST? SP2013

I've been working with a jQuery AJAX call to post data to one of my SharePoint lists. One of the fields in this list is a look-up field. In forming my JSON data to push to the list I was able to ...
0
votes
3answers
578 views

Filtering Look up Columns with Javascript

I'm trying to find a way to dynamically filter a look up column on the new and edit forms in SharePoint 2013. I want to be able to get a value from the URL and use that to filter the look up ...
0
votes
1answer
82 views

SharePoint Copy Blog to new site collection in c#

I am trying to make a code that copies Posts and Comments to a site. It is working, except setting the lookup field to connect Comment with Post. using Microsoft.SharePoint; using System; namespace ...
0
votes
0answers
36 views

Item moved copy associated lookup column in new library

How to explain this correctly :D I have two document librairies in one SharePoint site: - Source. - Dest. Both librairies have no Content Types. Both librairies have a column created within the ...
0
votes
0answers
22 views

Column Lookup only will not return numerical values

I am attempting to link two lists within a Sharepoint site. On the list being referenced, I have values stored a numbers. However, when I do lookup from the second list, it only returns the values as ...
1
vote
1answer
42 views

Searching between two separate lists for matches

I have two SharePoint Lists each with a column called Unique Key, what I need to do is search list B for matches in List A. List B is the larger of the two and each List contains only unique entries ...
0
votes
1answer
198 views

Extracting text from a lookup field in a SharePoint 2013

I switched from InfoPath to the Designer forms. In the list i have a Lookupfield that Points to another list. In the Control modes Edit and New the select boxes are created automatically using the ...
0
votes
1answer
84 views

More than one showFields in lookup column

When we create lookup column OOTB, there is option "Add a column to show each of this additional fields", so that we can have more than one show fields in list for that lookup. But how to do same ...
0
votes
1answer
116 views

Different sets of options in a lookup or choice column depending on the content type

I have a list content type and other content types that derive from it. I need to add a lookup or choice column to the content type (or the list itself) just so that each child content type or list ...
0
votes
1answer
39 views

Creating a lookup field that contains calculation?

So I created a lookup table, how would go about truncating via a lookup? For example, Choices 56, 56SW, 56FR are using the same calculation Choices DDS IDSL, ISDN TR, ISDN are using the same ...
3
votes
1answer
512 views

How to update metadata?

I have following code (didn't list the whole code) behind a button on a InfoPath Managed Form. and it works meaning I can submit data to a list. Now I have 2 controls on the form that is ...
0
votes
1answer
43 views

Using Additional fields of lookup in a worflow

For some reason, SharePoint saw fit that we would not be able to use a lookup in a lookup, so I have been doing the workaround where you use a workflow to copy the contents of the first lookup into a ...
1
vote
2answers
734 views

Filter lookup column based on another field value

Scenario: I have Tasks list with a (lookup) column Project. I have also a multivalue lookup column Predecessors pointing to the Tasks list itself. Question: Is it possible to filter available Tasks ...
3
votes
1answer
81 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
34 views

Is it possible to craete a lookup field to your own list?

sp 2010: Is it possible to craete a lookup field to your own list? I try it now, but the lookup field is empty. My target is to have list items which refer to other list items. Like main and sub ...
0
votes
1answer
142 views

Pull multiple values through a lookup

I am rather new with SP so I apologise if I cant express myself too well. Problem at hand: Two lists - Shops and Managers with a many-to-many relationship between them. I.E. in Shops there can be ...
1
vote
2answers
95 views

Limit to the amount of values you can have in a lookup field?

Is there a limit to the amount of values I can lookup? When I search for the topic I only get hits on the number of lookup fields you can have in a list. I have tested this a bit and it was ...
3
votes
3answers
1k views

Migration tool for specific lists

I am looking for a migration tool that works at the list level, not for a full site or server. One specific requirement is to be able to migrate lists that are connected via lookups. For example, if ...
2
votes
4answers
257 views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
1
vote
3answers
425 views

How to link two lists using a multi-valued lookup column?

I have two lists, one contains files, each file has one or more ID(depending on its content). These IDs are lookups to another list. Now, I generate another list on fly, this list has the ID column as ...
0
votes
1answer
62 views

Get List Items from list linked by lookup

I'm making a JavaScript extension for form elements. The goal is to bind it to a lookup and react on change. Since I'm weak at webservices, I'm using SPServices. var lookupFieldInternalName = ...
0
votes
1answer
248 views

Drop down lookup field search

I've got the following scenario: List A contains several thousand items, List B has a lookup field to List A. When a user is creating item in List B she has to select the List A item via the mentioned ...
0
votes
1answer
85 views

Insert list items contains lookup fields to each other from 2 different list

Currently I have two Share Point lists (supposed to A & B), each list contains look up fields to each other. I want to insert records to these lists, the problem is how can I reference the look ...
0
votes
0answers
43 views

Set item property depending on count of related child items

So I have classes (parent) with enrollments as the children (Enrollment is StudentID lookup, ClassID lookup, and Registered/Waitlisted choice box). Right now, I've successfully setup the forms for ...
0
votes
1answer
48 views

Assigning a lookup value field, passes through as a blank string

I've currently got a new task list item for a certain content type (DMR) which fails to take through the lookup to the associated list. The statement prints the correct record number in the immediates ...
0
votes
0answers
123 views

How to get lookup field value in document template while editing in word application?

I have a document library whose content type has a document template. I am setting the field values while creating new document in word application where the fields are available to set. Among the ...
0
votes
3answers
161 views

Get value of lookup

In js, i retrieve some items and inside there are lookup column and people column. When i print them, it's [object Object] Are there a way to determine if it's a lookup column? This one doesn't work ...
0
votes
1answer
16 views

Content Types Template problem with lookup column in template

I have a content type. When I want to create a new document from that content type the properties (Columns) for that content type also open in my document. The problem is that there is one lookup ...
0
votes
0answers
12 views

When I am using a look-up column, once I have used one value from another list, can this value be hidden for any subsequent entries?

I'm in the testing phase of setting up a database and a log on SharePoint. The log requires information from the database so I have set up a look-up column in the log and database to link the ...
0
votes
0answers
24 views

How get current user login name and populate his records in a lookup field

I have a library 'Download Asset' in which different user will upload files. In this library there is a column 'AssetName' . Now I am creating another list 'feedback'. In the feedback list there is ...
0
votes
1answer
56 views

Columns not displaying value

I've added some columns (name, ID etc ) to the document library after the documents have been uploaded, and got no value displayed. Is there any way to fix this or I'll have to recreate the library?
0
votes
2answers
105 views

SharePoint 2013: How to find orphaned lookup values

I've got a projects list in SharePoint 2013 that connects to two document libraries by way of a lookup column. Each document set in the libraries should ideally have its lookup column pointing to a ...
0
votes
0answers
18 views

MultiValue Send an Email Lookup

Is there a way for the Lookup that is in the body of the email to send multiple values. I have a repeating section in my form and it currently will send a seperate email for email repeating for I want ...
0
votes
0answers
32 views

Display error - web parts with look up columns

as seen below I have a display error with my dropdown arrow from the look-up columns. I have basically put two appparts on a webpart page on Sharepoint 2013. Appart 1 contains of two lookup columns A ...
0
votes
1answer
243 views

get an error while exporting access database to sharepoint 2007 lists: lookup contains values that do not exist in the related table

I try to export a table in a access database to sharepoint 2007. All related tables are automatic exported to SharePoint as lists. SharePoint creates lookup fields for each relation. Under the export ...
0
votes
0answers
225 views

Lookup Columns and Web Part Connections

I'm working on creating a Page Template which will display various content from different lists together based on a common lookup field which is in each list. I've created a new Content Type based ...
0
votes
2answers
116 views

Cascading Lookup columns

I have a project where I need to create a form. In that form I have several columns. The columns that I have questions about are assignment category Assignment type I have questions because the ...