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)

2
votes
0answers
46 views

Join SPQuery in list

List 1 "Posts", fields Title body #comments modified in this list #comments fields is look up from another list Comments: List 2 "Comments", fields title body comments post ...
2
votes
0answers
40 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 ...
2
votes
0answers
52 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 ...
2
votes
0answers
76 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
0answers
91 views

Getting distinct/unical values from External List

I have got an External List. I want to get distinct values from this External list to the dropdownlist getting from lookup Field. The values are often repeated. How can I get distinct values from ...
2
votes
0answers
310 views

Multivalue and single value lookup issue

Let's assume that we have two lists - Foo which has some kind of information - no matter what, and second - Cities - which holds city names. Now, we set up on Foo list lookup field to City list and ...
1
vote
0answers
13 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
0answers
14 views

Document Set lookup error

I have what seems like a minor bug when setting up a new document set. I've created a new content type based on a document set. One of the columns in the document set is a look up to a supplier list. ...
1
vote
0answers
28 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 ...
1
vote
0answers
75 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 ...
1
vote
0answers
16 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
0answers
113 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 --> ...
1
vote
0answers
118 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
1
vote
0answers
173 views

Sharepoint 2013 - Add lookup column to key filters

I've got a document library of invoices. It has various columns (mainly choices) such as, Year, Status, Location, etc. and I've been able to add them to metadata navigation as key filters. However, ...
1
vote
0answers
104 views

Count number of references in a multi-value lookup column

I'm using SharePoint Online, and I have one list of meetings, and one list of people. Meeting has a multi-value lookup column of people, so that several people can be added to a meeting. How would I ...
1
vote
0answers
134 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
1
vote
0answers
61 views

Find all lists that look up a Contacts list

I have a Contacts list in my site collection, and it is used in lookup columns by multiple other lists. Is there an easy way to get all the lists that have a lookup column pointing to the Contacts ...
1
vote
0answers
101 views

Lookup column automatic selection in list form upon adding new item

I have a site page with two related lists, this relation being established via the webpart option "insert related list", and I'm using ID column in my child list as the lookup column. The child list ...
1
vote
0answers
227 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
1
vote
0answers
285 views

Calculated columns supporting all column types

I would like to develop a column which will allow the end user to do the calculations based on values of other columns of the same item (SharePoint 2010). I need it to work also with people, look up ...
1
vote
0answers
146 views

user lookup field for external lists

Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
0answers
199 views

Filtering LookupMulti by FilterMultiValue SP2010

I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment FilterName=Tags&FilterMultiValue=Flower;Sword Three is nothing, apart correlation ID. I found in ...
1
vote
0answers
267 views

FilterMultiValue on additional lookup column Skill:ID

I try to filter my sharepoint list based on some filters. Because the checkbox option "Allow Multiple Selections" does not work I am trying to build some own implementation using the QueryFilter ...
1
vote
0answers
253 views

How to copy Assigned to field from list A to List B on creation of item in List B?

Trying to solve a problem with moving data from one list to another. I have 2 lists. 1) a project list that contains Project info (project ID which is text, name, lots of details, and an "Assigned ...
1
vote
0answers
219 views

How to get Dependant LookUp Column Values in Sharepoint 2010

I am trying to get the Dependant Lookup column values in sharepoint 2010 but unable to get the value so how can we read the values from Dependant LookUp Column. thanks in advance
1
vote
0answers
116 views

Related Item View - refered from child list

I'm working on a 2010 site at the moment and is asked to display all images to a news item (custom list). The problem is that the news don't have any reference to the Picture library, instead the ...
1
vote
0answers
111 views

Getting Error Access Denied when creating Filtered Lookup in SP2007 List

Using WSS SP2007 as a site curator. List A is a new list. List B is a resource list with a view showing active Project Managers. When I go to create a filtered lookup column in List A I immediately ...
1
vote
0answers
160 views

Displaying text in a Look-up column

Apologies for not being clear. I'm try to display a "multiple lines of text" column as a look-up field in a new view of the parent list. I have tried SP Designer and most of the standard webparts. ...
1
vote
0answers
171 views

Change column type from “Lookup (information already on this site)” to Person or Group

I have an issue after migration SharePoint 2007 to 2010. We had “Person or Group” which now somehow has transformed to “Lookup (information already on this site)”. This creates lots of troubles for ...
1
vote
0answers
323 views

Get value automatically similar to Excel's vlookup function

I want to get data from another list automatically based on a column from this list. Let's say the source list shows the ID A, B, C and the related values 1, 2, 3. In my list I show in a column one of ...
1
vote
0answers
90 views

Getting user's AD groups as lookup

I'm trying to make a simple reservation site, containing two lists: resources and reservations. Users are making reservations by creating a new item on Reservations list, specifying which resource ...
1
vote
0answers
112 views

Best way to create a list with hidden columns with Data pulling from InfoPath form

So I have been working on this for a little bit here is what I am trying to accomplish: Using OOTB SharePoint 2010 Functionality I want to create an HR Referral System. Basically an InfoPath Form ...
1
vote
0answers
579 views

How do I create a lookup field for a hyperlink field and display the URL?

Ok, so there are a zillion posts related to and circling around this question, but that do not actually answer it to my satisfaction. I have a regular, out of the box, list of type "Links". I have ...
1
vote
0answers
256 views

How to get lookup field text column to display as an image in a view?

Wonder if anyone can help. I want to add a category choice field to a SP2010 Announcements list. The category choice is a lookup field to another list. The other list contains the categories and a ...
1
vote
0answers
338 views

CAML Contains on a lookup field of a calculated column

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column. It basically does not work, the Equal works though. here is the query, nothing ...
1
vote
0answers
84 views

Lookup columns into document template

I've a DocLib with the lookup field Field01 and I want to display the associated lookup columns as Field01:FieldA, Field01:FieldB... I already have them on the view, now I want the exact same ...
1
vote
0answers
120 views

How do I create a linked keyword index?

We have a 2000-document library that we use as a knowledge base. We're trying to create a hyperlinked index of keywords. In this simplified example, consider the following metadata for a document ...
1
vote
0answers
280 views

Content Organizer rule based on a Lookup Column with more than 20 selectable values

Does anybody have any experience making content organizer rule based on a Lookup column with more than 20 values in the list? (When you have more than 20 values, the view of the Lookup field changes. ...
1
vote
0answers
418 views

How to take a value from a single line of text field in one list and set it as a lookup field in another list?

I have SP 2010 and SPD 2010. I have list A that has a single line of text column named Res ID #. This provides the source for List B as a lookup column. I want to create a WF that will put the info ...
1
vote
0answers
195 views

My custom form isn't saving lookup fields

I have a list with two content types. I've created two custom forms for creating new items (because one field I don't want until the 'edit' form). One works great. The other one doesn't. What's ...
1
vote
0answers
1k views

Inserting new item in list with EntityRef field to User Information List using Linq to SharePoint

I have a list with SPFieldUser field type in it. I try to insert new item in this list using Linq 2 SP. So, I generated data context class using the following configuration file: <List Name="User ...
1
vote
0answers
529 views

Why does SPMetal ignore lookup columns in Farm Solution

I have content types and related lists (via lookup columns) in a Sandbox solution(.wsp). All my lookup column relationships come up fine in the SPMetal generated entity classes. I now have a ...
0
votes
0answers
21 views

SP2013: How to find invalid lookup targets

I have a lookup column on a large library (1000+ files) and I'm trying to turn on the 'Cascade Delete' relationship behavior. When I do that, it gives me the following error: This lookup column ...
0
votes
0answers
29 views

Filtered Lookup Column from other Lookup Column

Why is this so difficult! SharePoint Online Office 365 List 1 : Group - Title, Desc List 2 : Category - Title, Group-Title(Lookup) List 3 : Document - Title, Category-Title(Lookup), ...
0
votes
0answers
31 views

Get Lookup field ID from DataTable

I have this code : SPListItemCollection CatList = LinkList.GetItems(query); SPListItem test = CatList .GetItemById(1); SPFieldLookupValue tmp = new SPFieldLookupValue(test["Category"].ToString()); ...
0
votes
0answers
25 views

Cross site lookup columns

If I have site structure as per the below: Site Collection -Main Site -Site 1 -SS 1.1 -SS 1.2 -Site 2 -SS 2.1 -SS 2.2 If I have a list in SS 1.1 is there any way in which I can create a ...
0
votes
0answers
21 views

Import specific row column values into sharepoint list fileds based on a field value in the sharepoint list

I have a SharePoint list (Service List) and an excel document (all registered customers) in the same SharePoint 2010. The Customer list excel document has customer no, location, address, phone number ...
0
votes
0answers
17 views

Workflow Lookup Column in Site Workflow

I am using Sharepoint Designer 2013, and I am looking for a way to create a column lookup that looks up the current item and looks for the column Due Date. Can you do this and apply this workflow to ...
0
votes
0answers
44 views

SPServices.SPCascadeDropdowns - Display Title rather than key

I'm using SPCascadeDropdowns to filter a child drop down which is working. However, I would like to display another column than the one in the relationship. I have created two lookup columns that ...
0
votes
0answers
19 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 ...