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)

3
votes
1answer
519 views

CAML Query on a Lookup Field that points to a Calculated Field throws Exception

I wrote some CAML Queries to get data from a List that has lookups on another List. All is working fine as long as I do not reference a Lookup Field which points to a Calculated Field. I tried ...
2
votes
1answer
82 views

Lookup field doesn't support some field types

Its looking more and more like you can't add additional fields that are anything other than string boxes (no person or yes/no etc) is there any work around for this?
0
votes
1answer
156 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
2
votes
1answer
676 views

In a DVWP my Multilookup column is not returning IDs, only column values

I've added a DVWP to a page. The DVWP shows data from a list with a multi value lookup column. The value returned for this column is in the form: value1;value2;value3. Now I want to render this ...
1
vote
1answer
593 views

Extending Content Types from Content Type Hub

I have defined a content type in content type hub. I would like to use this content type on a site (other than the hub) but also to extend it with an additional (lookup) column. Is it possible to do ...
0
votes
0answers
50 views

Load a SharePoint list into a workflow variable?

I am trying to use a workflow to lookup data in a column in a list and then compare that data in another library column then update another column in the library based on if it equals eachother. ...
1
vote
0answers
116 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
168 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, ...
0
votes
1answer
1k views

Bind lookup column with another subsite list

I have a site "ABC Company" in which I have two subsites. HR Inventory In HR subsite there is a list "Employee" which has a column "Full Name" In Inventory subsite there is a list "Issue ...
1
vote
1answer
224 views

InfoPath form referencing fields from another list

Environment: SP2013 Enterprise, InfoPath 2013 I'm building a course registration system for a SP client but am having a little difficulty with lookup fields. Basically there are two lists, a course ...
0
votes
0answers
42 views

Workflow to Update Library Column with Data from List

When creating a new item within the library I want a workflow to lookup a field in a list and if it equals a column in my library I want to update another column in my library. The field I need to ...
2
votes
0answers
87 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 ...
1
vote
1answer
551 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 ...
0
votes
2answers
313 views

Hide link in Listview on Lookupfield

In my customList there are several lookups. They link to the sourcelists. My question is: How can I hide these links?
14
votes
2answers
840 views

When deploying a site from custom site template, one lookup column in doclib has empty values for Office 2010 (docx, xlsx, pptx) files

I'm deploying sites using a custom site template (WSP) that is: Saved as WSP from customized Team Site Deployed as Farm Solution Has lists, libraries with content customized in Visual Studio ...
0
votes
1answer
174 views

What is use of LookupMulti in Sharepoint 2013

Can somebody tell me what is the use of LookupMulti in Sharepoint 2013 and how to implement this with visual studio 2012? Can we use this for chaining purpose ? For example, I have 2 lists country ...
0
votes
0answers
234 views

Concatenating values from multiple selection list box?

I am building a content type with a document template. Using InfoPath, I am customizing the template's Document Information Panel to automate the population of several fields in the resulting Word ...
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
1answer
286 views

SharePoint 2013, Lookup field cross-Web

It looks like I found pretty annoying bug in SharePoint 2013. Can anyone confirm this? Create site-column lookup to list placed on rootWeb (I will refer to it as WebA), the title should be used as ...
0
votes
0answers
96 views

Get Items Lookup Mult timeout

I have a list with many records , and when I'm doing a filter for a column that is Lookup Multiple runs smoothly : Example <Where> <Eq> <FieldRef Name='Column' ...
0
votes
1answer
98 views

Filtered Lookup Field for more then one element

How could I do filtered lookup field for more then one element? I make for one Element by this link: http://howididit-sharepoint.blogspot.com/2012/04/filtering-lookup-columns.html But how could I ...
1
vote
1answer
4k views

Using an Additional Lookup Column Value in a Calculated Column

I have a lookup column based on another list's description (a 'Category' list) and have ticked the other list's 'Category ID' column to be shown at the same time (I note that this is a manually ...
1
vote
1answer
990 views

Create lookup item with workflow

I have to create an item at the end of my workflow. The list that will contain the item has a lookup column... So I'm using the option : "Create item" and setting the values one by one. But how can I ...
0
votes
0answers
54 views

Use Lookup Col data as managed Metadata

Sharepoint 2013, We have a table of documents, about 20,000 items in it. The managed metadata searching works great. We can search specifically for "department:Sales" and get the documents ...
0
votes
2answers
41 views

Retrieve reference for list from Lookupfield

I have a sharepoint 2007 and in a document library eventhandler: in ItemUpdating, i would like to be able to retrieve the value by id's from lookupfield. So with other words i have to get the ...
0
votes
1answer
523 views

SharePoint 2013 Search - Return Results Based on Lookup Column Value

We have a page on a public website where we're surfacing a list of Staff which is stored in a "Catalog". The staff catalog has a lookup column pointing at a Department catalog. The Lookup is joining ...
0
votes
1answer
161 views

Lookup field with formatted text

I've created several lookup fields programmatically in existing lists, currently they render with just one field as the text value, however I'd like them to display the contents of two text fields ...
4
votes
2answers
997 views

SharePoint2010 Lookup Column Display issue

I have a simple list with three lookup columns in it. One LC has 5 items and displays as simple dropdown and there are no rendering issues (So ignore this column now). The other two columns has more ...
1
vote
0answers
98 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 ...
0
votes
1answer
211 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
1
vote
1answer
550 views

SP2010 Search: Managed Property on lookup column returns “ID” instead of “Title”

I've got a document library named "Documentation" and a user defined list named "Suppliers". "Documentation" has a lookup column linked to "Suppliers": WAWI(text) -> linked to "Suppliers:Title" ...
0
votes
0answers
137 views

Dynamic Lookup Field

What is the best way to create a dynamic lookup field in a list? Here's the best example I have found. I found this but does this actually work? Any opinions on that product?
0
votes
0answers
43 views

SharePoint 2013 lookups don't show all fields

I have two lists. 1st list: Contractor (people or group) phone (text) dept (text) etc... 2nd list: PO Number (text) Contractor (lookup) ---> this should get contractor from list 1. It ...
0
votes
1answer
31 views

Start and assign an approval task to all users in the given department(s)

I have a form containing a multi-select "Departments" column. I would like the user to be able to check off which departments the list pertains to, so that when the list is submitted for approval, all ...
0
votes
1answer
117 views

get an error while exporting access database to sharepoint 2007 lists: lookup contains values that do not exist in the related table

I try to export a table in a access database to sharepoint 2007. All related tables are automatic exported to SharePoint as lists. SharePoint creates lookup fields for each relation. Under the export ...
1
vote
0answers
528 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 ...
1
vote
2answers
322 views

How to link two lists using a multi-valued lookup column?

I have two lists, one contains files, each file has one or more ID(depending on its content). These IDs are lookups to another list. Now, I generate another list on fly, this list has the ID column as ...
3
votes
3answers
1k views

Dropdown options are displayed in the wrong place. (IE only)

I am using SP2010. In one of the lists I have several lookup fields as dropdowns in the forms, and I have a weird issue: 3 of 4 dropdowns, which are rendered as input (>20 items) are opened in a wrong ...
0
votes
1answer
52 views

Is there a way to get a set of 'child list' in sharepoint; i.e., lists that contains a lookup field to a given list?

This is what I have so far. It seems to work, but is very slow since its traversing all lists and fields in the site. Note: I am looking for the first list that shows up as a 'child list': private ...
0
votes
1answer
118 views

Why is edit item greyed out on lookup link

This is SharePoint 2010 Enterprise. This is all OOB stuff. I have one DocLib and two Lists. DocLib 1, List A, List B. DocLib 1 has two lookup columns. One to list A and one to list B. I have values ...
0
votes
0answers
153 views

SP 2010 add lookup column programmatically causes autoeventwireup not allowed in custom edit form

I'm struggeling a problem for days. I have a custom list definition to which I add lookup columns in a feature receveier. When I open the edit mask the error occurs: autoeventwireup-attribute is not ...
0
votes
1answer
50 views

Moving SharePoint 2007 Lists/Lookups between subsites within same site collection

We have a list 'Leaders' that we want to move from one subsite (A) to subsite (B) that is in the same site collection. I had gone into 'Site Actions' -> 'Site Settings'-> 'Modify All Site Settings' -> ...
0
votes
1answer
122 views

Set lookupfield value on document upload through event receiver

I have a custom list, where when I create a new item, I assign a custom id to that element through an event receiver. After the item is created, I create a file that I upload to a document library. ...
0
votes
1answer
69 views

Prefill the input boxes of a list based upon lookup

I had a list say company that contains columns like CompanyName. Then another list called as Addresses contains a lookup to conmpany and additional columns like Street, City What i need to do is to ...
0
votes
0answers
38 views

SharePoint 2010 List Lookup Filtering

If you have a SharePoint list that contains the following columns: ---- Name ------ Type of Column Tags (metadata column) Question (single line of text) Response (multi line of text) How ...
0
votes
1answer
577 views

Cross-site and SPFieldLookup

I've read a numbered time that SPFieldLookup is cross-site by its nature. But now I'm a little bit confused, here is my SharePoint structure: /SiteCollection /Site1 Projects /Site2 Customers ...
0
votes
1answer
8k views

Setting the value of a lookupfield(sharepoint dropdown formfield) in sharepoint 2010 list forms

How can i set the value of sharepoint form field dropdown box(lookupfield) in sharepoint list form when the form gets saved (using jquery) note: the lookupfield (dropdown formfield renders as input if ...
0
votes
0answers
67 views

How to send email to a user referenced in a top-level lookup table in SPD workflow?

SharePoint 2010: I got a SharePoint Designer workflow attached to a custom list [A]. [A] has a lookup field [L] to a top-level (site collection root) list [B] which has a column of type "Person or ...
0
votes
1answer
34 views

How to set value to fields of List item getting values from the folder that it is in?

I have some folders with some properties(Name of project, Project Number and etc.) When I create a item inside of this folder I need to fill out these information again for the item. I would like to ...
0
votes
0answers
69 views

Cusstom MultiLookup column

Im trying to create a custom field type of multilookup type to show lookup values of one particular content type, So I'm creating a customcontrol which extends the "MultipleLookupField" class. I ...