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

How to access User Information Columns in a Workflow

I need to access a custom column of User Information List in a work flow. I've create a new column named MyCol in User Information List and now in a workflow I want to access to in when I lookup ...
2
votes
1answer
316 views

Use count-related column value as int in a SP Designer-workflow

I have another problem concerning the count-related column-value of SP2010 in a workflow(see also: How to get count related Lookup value programmatically? ). my use-case: I have a column "actual ...
3
votes
2answers
999 views

Deactivate the link of lookup-fields! (2010)

On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen. Of ...
1
vote
2answers
1k views

What columns count as lookup column concerning the “List View Lookup threshold”

I got the following entry in my SharePoint 2010 log file: "Some lookup fields were omitted from the query results because the list exceeds the lookup column threshold." I checked the setting (Central ...
1
vote
0answers
227 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 ...
5
votes
3answers
807 views

Replace semicolon delimiter in a Lookup column on the list view

When selecting multiple values, the data is separated with semicolons. When many values are selected it starts looking cluttered. Is there any way to have each value on a new line? For example, ...
0
votes
1answer
99 views

Is Multiple Lookup API's supported JavaScript

Is Multiple Lookup API's supported JavaScript language? I need to create a new column, retrieve data from multi-lookup using JavaScript API's not sure if it's supported.
2
votes
3answers
748 views

Sharepoint2010 Lists Lookup

I'm creating 3 lists using Sharepoint 2010 UI. The lists and relationship are as follows: Training (parent) -> Training Instance (child, look up Training ) -> Training Session (grandchild,lookup ...
2
votes
1answer
749 views

REST: unable to retrieve lookup data from top level

At the top level of my site collection, I have created a list called "Markets", and a site column called "Market", defined as a lookup to the Markets list. In a subsite of this same site collection, ...
0
votes
2answers
468 views

Accessing LookupFieldValue throws error

I have a lookup field on a list (header) that looks up values on the same list. I am trying to read the value out of that lookup with this code: using (SPSite site = new SPSite (mySite.ID)) { ...
0
votes
1answer
615 views

How to get count related Lookup value programmatically?

Another day, another question ;) So, I have two custom Lists, "Attendees" and "Events". In the Events-List there's a Lookupfield "Registrations" which I want to fill programmatically on page_load. In ...
1
vote
2answers
68 views

Calculated Column Question - maybe

I am pretty new to this, so apologies if it is a stupid question. Basically, I want to know if it is possible to create a column that references another column at the level below. Specifically, I ...
0
votes
1answer
203 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
1answer
282 views

How do I Filter a Lookup field based on a 2nd columns value

I have List_A = { Title, Type} & List_B = { Title, myLookUpField } I want myLookUpField = Title, IF(Type=="Red") I know.... List_B.Fields.AddLookUp("myLookUpField", List_A.ID, false); ...
1
vote
2answers
62 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
217 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
515 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 ...
0
votes
2answers
544 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
191 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
108 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
93 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
150 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
143 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
904 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 ...
1
vote
1answer
123 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
2answers
152 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
1k views

Set value in a lookup column during “Create List Item” workflow action

Here's the scenario, using SharePoint Designer 2007 and two simple lists in MOSS SP2: I create items in a list called "Code Snippets" with columns Title, Code and Author's CustID I track how many ...
0
votes
1answer
96 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%]. ...
3
votes
1answer
369 views

Set a date/lookup in ListInstance elements.xml

I have two lists. The first one has customers and the second one has Orders. Now i want to add some (test) data in the elements.xml of the listinstances. For customers this works without a problem ...
0
votes
1answer
414 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 ...
3
votes
1answer
544 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 ...
2
votes
1answer
615 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 ...
6
votes
1answer
346 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> ...
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 ...
1
vote
0answers
290 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
37 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 ...
1
vote
2answers
1k views

Lists with lookup columns aren't saving - read only?

I've got several list which have lookup fields, and I can't add new items to any of them. Every time I've clicked save, I get this error: "Invalid data has been used to update the list item. The ...
1
vote
1answer
721 views

Lookup column of type “User” showing #ERR

I've defined two list definitions and instances in a feature in VS2010. One list only contains a required field "Employee" which is of type User. The second list has two fields, a simple text field ...
0
votes
1answer
67 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
253 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
88 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
469 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 ...
2
votes
2answers
327 views

Chart Web Part and lookup fields

How can I make my Chart Web Part look good when I use it with lookup fields? The issue I have is that the chart displays the field id along with its value. For example, it displays "2;#Bing" when I'd ...
1
vote
2answers
762 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
920 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" ...
2
votes
2answers
246 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
953 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 ...
1
vote
1answer
86 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
271 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, ...