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
149 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
5k 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
2k 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
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
643 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
279 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
1k 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
137 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
1answer
1k 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
1answer
33 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 ...
1
vote
0answers
539 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 ...
3
votes
3answers
2k 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
58 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
225 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
1answer
75 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
180 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
80 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
1answer
1k 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
9k 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
1answer
36 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
1answer
418 views

linq query for lookup list column error - query uses unsupported elements

I'm trying to return the list item ID (s.ID), and the ID of a lookup column (s.VendorID). I get the following error: The query uses unsupported elements, such as references to more than one list, ...
0
votes
3answers
262 views

How to design look up list for 20 sub-sites?

Say, I have 20 sub-sites under corporate sales. There are 3 lists that drives the look up columns. Country (USA, Mexico, Norway, Morocco, etc.) Regions (SW, NW, S, W, N, MW, etc) SalesArea (Service; ...
1
vote
1answer
344 views

Site Column as lookupfield creates false URL-Strings

I have a created a custom site column, which is a lookup field, on my rootsite. However, I use this colum now on a subsite in another list. The idea is, to have a central list with lets say Divisions, ...
0
votes
0answers
370 views

Values missing for dependent lookup column from parent list when using linq

Situation I have 2 site content types defined that are deployed as a site feature: Customer Name Address Order Value There is a second web feature that deploys a list to the root site for ...
0
votes
1answer
48 views

Menu control in sharepoint

Is it possible to have a top menu in sharepoint like when i click on the tab it should provide me a mega menu.Is it possible through OOB of sharepoint..please share your ideas..
0
votes
1answer
38 views

Is there any programmatic way to determine if a list has any relationships to other lists?

If list A has a SPFieldLookup to list B is there any thing in list B's SPList object to show the relationship with list A? While I can flip through list A's fields and find the relationship to List B ...
0
votes
1answer
593 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 ...
3
votes
3answers
543 views

SPSiteDataQuery and Look-up column

I have a requirement to iterate through multiple task lists under SharePoint sites and sub-sites. I am using SPSiteDataQuery to achieve this. I have an issue with fetching the data when the column is ...
0
votes
2answers
104 views

Updating List XML on Office 365

I'm trying to create a lookup column on an Office 365 SharePoint dev site through an app using SPServices but I'm not having any luck. function createLookupColumn(listGuid) { ...
0
votes
1answer
80 views

Filter Lookup from another lookup

I have a list of projects. Inside the project list you can select a Client. I have a list of Clients. I have another list, a list of Contacts, they have a lookup column called Client to specify from ...
2
votes
2answers
91 views

Am I doing something wrong, or are these common pitfalls or limitations of using lookup lists?

I'm using (and limited to) OOTB Foundation 2010, and have been exploring lookup lists. I am discovering a few things that aren't working the way I'd like, seem to be working inconsistently, and are ...
0
votes
2answers
437 views

SP2010: How to display a lookup column in a .aspx displayform

I have the two Lists Articles(A) and Serial Inspections(S). The Article-List has columns: Article-#, Name, DescriptionDE, DescriptionEN, somemore... The Serial Inspections: Inspection-#, Inspector, ...
3
votes
1answer
2k views

How to sort SharePoint 2010 lookup combobox?

I have a lookup combobox whose source is another SharePoint list. By default, this combobox items are sorted by word order but I want to sort this items with another/custom order. How can I do this? ...
1
vote
1answer
645 views

Fetch Username from Lookup-Column using Powershell

In my powershell script, I have a method that fetches a username from a sharepoint list. This works fine - my problem is that field is from a lookup column. The user chooses the username from a ...
0
votes
2answers
668 views

Choose Username column in Content-Type

In my portal I have two lists. One (we'll call it the people-list) is a list of people's first and last names and their username (person column) if they have one. I have created a content type that ...
6
votes
2answers
5k views

How to display lookup additional field in display form?

I have two lists: Projects and Tasks In the Tasks list, I have created a lookup field titled ProjectID which targets ID filed from the Projects list. Also, I have set for this field to display an ...
3
votes
2answers
4k views

Problem with Sharepoint ContentTypeBinding and Lookup field

I have a problem with ContentTypeBinding when creating a new site. I have custom site template definition where I have referenced Publishing Server Feature, so list Pages is automatically created on ...
0
votes
1answer
120 views

How do i declare array for the lookup column using jquery

How do i declare array for the lookup column using jquery. I have a column whose values should be declared as array. so that my requirements get it complete. I need that ID for every values to get ...
0
votes
1answer
279 views

Access Lookup to Linked List

I am trying to create a lookup from one Access table to a linked list from SharePoint. I need to have a lookup between the two because in order to create the type of subform that I need, there has to ...
13
votes
1answer
13k views

How to get a SPFieldLookupValue from an SPListItem?

When you get an SPListItemCollection from a SPList.GetItems(SPQuery) request, and the items have SPFieldUser or SPFieldLookup fields, what is the sexy way to get typed values, not the ...
0
votes
1answer
131 views

Lookup fields blank after dialogue

I have a problem on a SharePoint 2010 site. I have lists which contain Lookup fields. When I perform any action on the site that causes a custom dialogue to be displayed, the lookup fields become ...
0
votes
2answers
100 views

How in Setting List call from one list to another by fields in list

I know how call elements in the same list. It can be done by: And then i take a copy from another list. Now a question how to colect a copy of field value, but from another list?
3
votes
3answers
1k views

How to create web-related lookup field to 'pages' list?

I have SharePoint site collection 'http://microsoft.com/' with few child webs ex: http://microsoft.com/news/ I want to create lookup field to 'Pages' list. On each child web lookup field should ...
2
votes
2answers
6k views

Add additional field to lookup field inside schema.xml

I'm following the steps in this article to setup a joined data view webpart joined on a lookup field: ...
0
votes
1answer
1k views

Populate MultiLookupList : Remove Item

On http://weblogs.asp.net/bsimser/archive/2013/02/20/defaulting-values-in-a-multi-lookup-form-in-sharepoint.aspx I found some nice code to pre-populate a multilookuplist (and remove the selected ...
1
vote
0answers
192 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 ...
0
votes
1answer
576 views

Change size of Multilookup field

I have a multi lookup just like this image, with 2 listboxes and Add and Remove buttons: ...
0
votes
1answer
162 views

Numeric field in SP displaying 10 as 10.000000 how do i remove that?

I have a list look up column which fetches values from another list which is number(int), but on loading it takes it as a flaoting number. for example the value in list firld in 10 but it is taken as ...
0
votes
1answer
796 views

Editing rendering of Lookup Field - XLST

Let's say I have a simple text column named MyCustomName with four fields in it: REMOVE one REMOVE two three REMOVE four ...and I want them to display like one two three four in my list View. In ...
2
votes
1answer
242 views

Self Referencing Related Documents Library Through Lookup Column

I am trying to create a single document library that links to documents in the same library in SharePoint 2010 Server. I've created a multi-value lookup column that references the same library to ...