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
225 views

Setting a Lookupfield for current Item in List

my use-case: I'm trying to implement an event-management system to sharepoint using visual web part(s). I have two custom lists, one is called "events". Let's say it has a column "Title" which shows ...
1
vote
0answers
246 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
1answer
541 views

send email from workflow based on loopkup column

I have a workflow in visual studio and I need to send an email to a domain user whose name is entered into a sharepoint Person or Group lookup. The value will not be in a sharepoint group, it is from ...
1
vote
0answers
213 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
115 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 ...
0
votes
2answers
680 views

How to add a from lookup field value to the text

I think about how to add a from lookup value to the text ? How can I write it to another colum ? In the same list.
1
vote
0answers
106 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
2answers
64 views

Library item “referencing” other content

Sorry for the nondescript title, it's a little hard to explain concisely. We are setting up SharePoint 2010 to act as a simple document management system, to store documents such as forms, ...
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
162 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
1answer
1k views

Format List look-up column as text-only in data-view web part

I have a list that contains a lookup column. Next, I created an empty .aspx page and added a dataview web part. Next, I linked the dataview web part to the previously mentioned list, which gave me ...
0
votes
1answer
253 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
2answers
184 views

Lookup between lists with additional data

I have two entities, Toolbox and Tool, where Toolbox contains a set of tools (hammer, saw, screwdriver). The trick is that there can be several hammers in the same toolbox, so I need an amount, or ...
1
vote
1answer
130 views

How do I add a user column to a custom list?

I have created a custom list programatically. I want to add a field to it call User, this should be a lookup to the system Users. This will be like the default CreatedBy field. How would I do this?
0
votes
1answer
108 views

Using a lookup to set the To: address on a sharepoint designer 2010 workflow email action

I have a sharepoint designer 2010 workflow with a email action. I want to set the value for the To: address to a field of the Current Item using a lookup ( [%Current Item:Vendor Contact%]. ...
0
votes
1answer
517 views

How can I create column in list which it able to change data (lookup column) in next column?

How can I create column in list which it able to change data (lookup column) in next column? For example: I have three lists with datas(names, numbers and adress) and I have other list with two ...
6
votes
1answer
404 views

How to Combine IN-Opeator with LookupIds in a caml-query?

I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine: <Where> ...
2
votes
1answer
733 views

Managed metadata vs lookup for column

I have a property content type. I'm wanting to add a property code column which will look up the codes from somewhere else on a SharePoint Online site, where it can easily be managed by end users. I ...
1
vote
0answers
314 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 ...
0
votes
2answers
41 views

Find a field by its name in a Library

So I'm having an error: The field "Document_x0020_Type" contains a lookup to list "{D2589081-9361-4393-996B-7C156C7B8F5A}" that cannot be resolved. The target list may not be part of this ...
3
votes
1answer
1k views

Client Object Model - Update Document Library Metadata - Lookup Field with no required value

I am attempting to update metadata for documents in a document library (or List) using the client object model. I have whittled down a number of the error messages I was getting and now I am hitting ...
0
votes
1answer
68 views

Pro grammatically adding choice field with another field relation

sorry about the title am not sure how i should name it. I want to be able to create two columns for a list that have a division - subdivision relation. If in the first field if i choose People the ...
0
votes
1answer
271 views

How can I make a filtered lookup view that doesn't remove the value in it as I delete items from the lookup list

I have a list of Projects. As they are completed I want to delete the item (or tag it as completed). The Project Library looks up "Project Name" from the list of Projects (so that it is easy to find ...
1
vote
0answers
89 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 ...
0
votes
1answer
575 views

Add multiple items a SharePoint list

I am creating a suggestion list using SharePoint 2010 custom list. My issue is I want to give the login user the ability to add others users to the form. I am thinking of doing a parent Child ...
0
votes
1answer
542 views

List as a look up value from another site

I would like to use a list from one site as a look up for another site. Can I do this with out using code. Only use OOTB or Designer? Or is there a better way?
0
votes
1answer
106 views

Multiple LookupField?

I have a couple of problems that i would need help with. I need to create a list that has a lookup to multiple lists. Is there a way to do this without including third party. I have a site, with a ...
1
vote
2answers
823 views

lookup between two lists programmatically

i have two lists. the first list name is "cases" and the second list name is "issues". in the cases list i have a text column that holds a case number. in the issues list i have lookup column name ...
0
votes
2answers
998 views

Defining Lookup Fields in CAML that pulls multiple fields

We have defined a number of lookup fields like so: <Field ID="{81A578F2-8022-4083-8683-7F9BF039C82A}" Name="NameLookup" DisplayName="Navn" ...
1
vote
1answer
740 views

content query web part with multi value lookup column

I am trying to work out how I can query a content type with a multi value lookup field using the content query web part. I know that natively this is not possible with ootb sharepoint 2010 however I ...
1
vote
1answer
1k views

Conditional Sum of Data in Another List

I have two lists 'Projects' and 'Tasks' where 'Tasks' are associated with 'Projects' with a lookup column. On the Projects list I would like to display the sum of all of the 'Actual Time' values (a ...
2
votes
2answers
258 views

Lookup List and return data from within a Form

OK, I'm beginning to despair at SharePoint...please help restore some faith :) Seems some very basic things are very hard to achieve? 1: I have data in an SQL database table. 78,000 rows, but I want ...
1
vote
1answer
547 views

Modifying XSL for multi lookup field

I'm trying to create custom XSLT for a multi lookup field, based on this article. When changing disable-output-escaping to yes I can see the html I want to modyify: <a ...
1
vote
1answer
89 views

Create a lookup column in a list to reference a column in a list on another site (SharePoint 2007)

Is this possible with an OOB solution: I have list A on Site A and List B on Site B (site B is NOT a subsite of site A). There is a column in list A on Site A that I need to use in list B on site B. ...
0
votes
0answers
282 views

“Linked Item” Lookup available in browser by not SPD2010?

When I create a Lookup site column in the Browser, this enables me to choose "linked to item"...which then means it pulls back all the related information. However, if I do the same in SPD 2010, ...
1
vote
1answer
414 views

Clear Multiselect Lookup

I am trying to add a button for my users to clear a multiselect lookup value using JQuery or Javascript. I have found some information about setting a default value on a single select lookup, but ...
0
votes
2answers
609 views

Change the source on a lookup column?

Is it possible to change the data source on a lookup column? I have the source set to list A but I want to change it to List B.
1
vote
0answers
110 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
549 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 ...
0
votes
1answer
74 views

Is a list being used as a lookup for some web part in the site collection?

We're cleaning up our MOSS site collection in preparation for the migration to SP2010. As we work on the top root site of our site collection, we realize that some of these lists (often with invalid ...
1
vote
2answers
2k views

Retrieving a lookup Value from a List using jquery and REST

I would like to get the lookup Value from a List item depending on it's Title. My List is set up similar to the following example: ColumnA : a | b | c lookupB : 1 | 1 | 2 The jquery: function ...
1
vote
1answer
212 views

Document library forces check-in upon adding custom lookup column

SharePoint 2007 Team Site Add a Document Library with the Word 2003 template Add a new item, save, close document, no problems Add a (required) custom lookup field to the document library Add a new ...
2
votes
1answer
448 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 ...
1
vote
1answer
87 views

I need to have the data from a list in another site at the same level to be available as a lookup in sharepoint 2010

I have a parent team site (Services) that contains multiple sub sites. One of the sub Teamsites is Call Inventory Containing our Stock List. Another Teamsite is called Purchasing containing a purchase ...
0
votes
2answers
222 views

How Can I create simple database in list Sharepoint Fundation?

How I can create simple database for example vacation request in SP list? It will looks like that: I create probably two list. In first list is vacation days people and on the second list is vacation ...
1
vote
1answer
527 views

Is it possible in LINQ to SharePoint

I have a task to make a WSP, which should provide definitions of custom list and library, but not instances. List definition has a lookup column to library item <Field ...
1
vote
0answers
25 views

Is that possible to filter and display the lookup values? [duplicate]

Possible Duplicate: How to make a filtered lookup field I am using project list lookup field in task list, so my project have # of items, but i need to restrict some of the project like if ...
0
votes
2answers
1k views

SharePoint list to lookup contact or account from CRM 2011

I have a SharePoint site and I would like to be able to create a list of which one column will be linked to a customer account. I have seen products that sync data between CRM 2011 and SharePoint ...
1
vote
2answers
654 views

Simple SPQuery throws error

I am trying to pull populate a lookup field using a lookup value without the lookup ID. I am getting the error: "One or more field types are not installed properly. Go to the list settings page to ...
0
votes
1answer
288 views

Customize LookUp Field

Someone knows how to customize a LookUp field to make it look like it: http://www.codeproject.com/Articles/18929/An-OwnerDraw-ComboBox-with-CheckBoxes-in-the-Drop (Dropdown + Checkbox).