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
10 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
18 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
14 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 ...
1
vote
1answer
40 views

Sharepoint 2013 - How to lookup custom string in workflow task

I'm creating a workflow that assigns a task to a person. After that person completes the task, they are required to input a string of text (a server URL) before they can press "Approve." Once this is ...
0
votes
1answer
33 views

lookup column in calculated column formula

I have a Lookup column(Discountfirst) which has Number. I also have another Calculated column(Finaldate) with Resulttype DateTime. One more column(DateofReceipt) in Date. My Calculated column formula ...
0
votes
1answer
20 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
9 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
13 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
30 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
46 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
27 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
47 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
32 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 ...
0
votes
3answers
86 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
38 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
100 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 ...
0
votes
1answer
30 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
54 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
0answers
57 views

SharePoint 2013 - Remove the hyperlink from a lookup column in a list view

I've searched the web and found a solution.... IF I WAS USING 2010 or 2007. I have cascading selections referencing two different lists that hold the dependencies as lookup columns. My cascading ...
1
vote
2answers
38 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 ...
2
votes
4answers
67 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 ...
0
votes
1answer
40 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
47 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
30 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
12 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
26 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
1answer
76 views

SharePoint 2013 lookups with more than 20 items as select or input?

So I was reading about doing some JavaScript to manipulate the default forms for our lists and came across this: ...
0
votes
0answers
46 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
0answers
11 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
1answer
13 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
16 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
3answers
49 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
3answers
98 views

How to change the color of each column in a SharePoint chart?

How does one change the color of each column in a SharePoint Chart Web part? For example the "passed" column would be green, the "stopped" would be red. I am pulling data from this list: It ...
0
votes
1answer
110 views

How to return field from specific workflow task as Data source in Lookup tool?

In short . . . How do I do this: ? In Step 1 of my workflow, the first action is to create/assign a task with Task ID of TaskID1. For the next action, how do I assign a field the value of a ...
0
votes
1answer
21 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
54 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
14 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
29 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
0answers
60 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
62 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 ...
0
votes
0answers
30 views

Accessing individual elements of a field that has multiple values in a workflow

So I have a Class and the class has a field Students. Students is a lookup to the Students List that accepts multiple values. I want to build a workflow that, on item creation, will make a row in ...
0
votes
2answers
45 views

Lookup in SharePoint

I'm using Sharepoint 2010. I have a List "Discipline" with 3 columns Discipline Code Discipline Des.-Site 1 Discipline Des.-Site 2 A A1 ...
0
votes
0answers
27 views

Can't use additional fields from lookup column in workflow

I have a list with name, department, email and summary column (which is a calculated column from name/email/department). Then i have a document library. Here i have a lookup column called Guarantor ...
1
vote
0answers
38 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
0
votes
0answers
30 views

Rootfolder=* in lookup-link causing troubles

I've got 2 lists, a User- and an Issue-list. On the Issue-list I've got a single-lookup to the User-list, so 1 Issue can have 1 User assigned for it. The column in the User-list that's being looked ...
1
vote
1answer
30 views

Update list item once library item is created

We have a list that is used to notify people that they need to create an item in a library. We want to update a field in the list once the item in the library is created. We tried to use the method ...
1
vote
0answers
29 views

How to develop an event receiver on selecting item from dropdownlist

In my SharePoint list,I have a lookup column. When I select one item from the lookup,I need to show the information from the selected one(like title,ID...). I think that developing an event receiver ...
0
votes
0answers
65 views

copy one column value to another column in a list

I have a list named ABC in MOSS 2007 List has 2 Views (All Details and Multi Location) 2 columns (BA-tech and BA for both views) BA- tech field is "Single line of text" type and BA field is "Look ...
0
votes
0answers
63 views

Using multiple value lookup column for an email “To:” line

I'm having an issue using a multiple value lookup column in SharePoint 2010. I have two lists. One is a task list and will be the main list that users use for this site. The second list is just a ...
0
votes
0answers
59 views

Copy lookup field

I have two lists: Task List Project A" (Title, Project, Parent Task) and Task List all Projects" (Title, Project, Parent Task) In both lists "parent task" has to be a lookup field. I want to ...