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

learn more… | top users | synonyms (1)

3
votes
2answers
2k 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
143 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 ...
1
vote
1answer
49 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 ...
1
vote
2answers
523 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
226 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
258 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
52 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
1k 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
50 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
2k 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
37 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
286 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
1answer
1k 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
711 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
1k 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
131 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
580 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
115 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
1answer
101 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
450 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
1answer
25 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
3answers
365 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 ...
3
votes
1answer
833 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
2answers
4k 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
128 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
217 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
34 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
2answers
213 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
2answers
55 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 ...
1
vote
0answers
44 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 ...
1
vote
1answer
57 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
36 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
1answer
379 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 ...
1
vote
1answer
472 views

Add items to the lists having lookup relation using powershell?

I am trying to add items to the comments list based on the Post list having lookup relation ship between these two lists,can any one give me an example how to update the lookup column values using ...
0
votes
1answer
602 views

Export and Import the lookup relationship data in SharePoint 2013

In SharePoint 2013 having a blog site with Posts and Comments list, these 2 lists having the lookup relation ship, I export and import from one site to another site but in comments list PostTitle ...
0
votes
1answer
112 views

Can a Lookup list field point to web property bag?

In my subwebs I have a 1 row list called "Details" that contains various bits of data that are meant to be web-level metadata. Image field, AssignedTo field, couple of string columns, etc. On top of ...
1
vote
3answers
2k views

Sharepoint 2010 - Workflow, return field as Lookup Values, Comma Delimited getting both lookup id and lookup value

I'm working on a simple workflow in SPD 2010 which is going to send an email to multiple recipients based on lookup values and even though I set the "Return Field As: Lookup Values, Comma Delimited" ...
0
votes
1answer
170 views

Trying to get lookup (Title) value, but returns null only in Client Object Model

I have this query: <View> <ViewFields> <FieldRef Name='Title' /> <FieldRef Name='itlgCategoria'/> ...
0
votes
2answers
977 views

Problem copying lookup column data from one list to another via PowerShell

I have the below script that works for moving list data between two lists on sites next to each other that have the same schema. Everything works perfectly bar a column of type LOOKUP named "Name of ...
0
votes
1answer
128 views

How do I lookup string value from another list?

I'm having trouble using a "Lookup" type field to lookup values from another list. I have two lists. 'Invoices' list shows all the invoices' being entered by colleagues with all the general ...
0
votes
1answer
193 views

How to submit multi-checkbox items in a formatted string to SharePoint lookup column

I'm new to InfoPath and SharePoint and i also use the trial version of qRules, i have 2 sharepoint lists, with one (let's call it "list1") having a lookup column to the second ("list2"), and this ...
0
votes
1answer
78 views

New list column is not displaying in dropdown list when creating a lookup column

I have an existing list called Employees and I have added a new column "Company". I would like to create a lookup column using Company but Company is not displaying as an option in the dropdown list ...
0
votes
1answer
63 views

Lookup list filter only future events

I have a task list that assigns tasks to specific future events. The custom task has a lookup column that is based on an events calendar. Is there any way I can cleanup this lookup list to only show ...
0
votes
2answers
32 views

Lookup on a list with permissions

Is it possible to keep a list security trimmed to a small group, while allowing a list item column to be used as a lookup? The purpose would be for the larger audience to be able to create a task ...
0
votes
1answer
178 views

SP2013: List with columns “Lookup (information already on this site)” display as URL's

I have several lists on a site that have dropdown columns that refer to other lists on the same site to keep things consistent (e.g. a department dropdown that should show the same values everywhere). ...
1
vote
1answer
156 views

How to update content type to include additional lookup fields for all instances of content type?

I have created a lookup field as a site column in my root site. The field also brings several additional columns showing information from the list. It is used in a root site content type. I have ...
1
vote
0answers
76 views

How to auto generate parent MMD columns based on child MMD columns?

This is the structure of one of my Term Sets. I have a Site Column called Record Type (Deeds, Agreements, Permits) I have a Site Column called Deed Type (D1, D2, D3) I have a Site Column called ...
1
vote
1answer
779 views

Lookup column to Picture Library

I've created a picture library called "Reusable icons" with all my icons. Then I created a new Custom List with a lookup column to the "Reusable icons"-library. Problem is that I don't get the url ...
2
votes
1answer
359 views

Lookup field is empty after List Item is added

Here is My Problem: I have a New Form in a list and I have added some custom JS code to it. In the form is a "Registration number" lookup field with more than 20 items in it. I need to populate it ...
1
vote
1answer
342 views

Lookup Column - SharePoint 2010

Is there any way to link parent site and sub sites? Problem: I have one list on Parent site and I have a few other lists on sub sites. I am trying to create lookup columns in the parent site list to ...