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
308 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 ...
0
votes
0answers
71 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
132 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
195 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, ...
2
votes
2answers
1k views

infopath form not updating fields

I have an infopath form that has three read-only fields referencing items in another list, but when someone opens the form the values never change, even if they have changed in the other list. It ...
0
votes
0answers
59 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 ...
1
vote
1answer
352 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 ...
2
votes
0answers
185 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 ...
0
votes
1answer
263 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
141 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
166 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
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 ...
7
votes
3answers
243 views

Working around the “Lookup column threshhold”

To level-set, I'm working in a large enterprise with no Farm Admin access or access to SP Designer. I have out-of-the-box capabilities only as owner of a team site. I'm building a roster/schedule ...
0
votes
1answer
305 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 ...
1
vote
0answers
142 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
457 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 ...
2
votes
2answers
1k views

SP 2013 - Updating a multi-value lookup field via the REST API

When adding a new item to list via the Sharepoint 2013 REST API I want to populate one of its multi-value lookup columns. I've tried passing in an array of Ids or a string with separators but nothing ...
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
34 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
199 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 ...
0
votes
1answer
59 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
78 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
196 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
84 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
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
438 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
278 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
2answers
465 views

Help with SPCascadeDropdowns cascading lookup column

I have this jquery added to my editform.aspx in SharePoint. I want the childcolumn to also have unique values, although it may contain duplicates example below. Example. When I select mycountry, I ...
0
votes
1answer
145 views

Specify Lookup list for the 'Title' Column of a Gantt chart view

I was hoping to use a lookup list as the title column for a Gantt chart view. The problem is when I go to the Gantt columns in the settings for the view it doesn't display any of the lookup list ...
0
votes
1answer
657 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
0answers
380 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
3answers
454 views

XSLT Listview webpart not showing site column lookup values

The Problem: We have a top level site that contains various lists of data. The information in these lists are exposed to subsites using site lookup columns. In our subsites we have various lists that ...
0
votes
1answer
81 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 ...
0
votes
2answers
105 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) { ...
3
votes
3answers
563 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 ...
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
1answer
240 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 ...
1
vote
1answer
667 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
470 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, ...
0
votes
2answers
696 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 ...
2
votes
5answers
4k views

How to Force Alphabetical Order in Lookup Dropdown with Multiple Choices

In my portal (Sharepoint Server 2010 Enterprise) I have a simple list with only the title field. I've created about 50 entries in the list. In another list, I have a lookup column that pulls from ...
3
votes
3answers
3k 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 ...
2
votes
3answers
2k views

Can a SharePoint 2010 lookup column point to a multi-line rich text field from same list

Can a SharePoint 2010 lookup column point to a multi-line rich text field in same list? i dont find multiline column while creating a lookup column. Is there any way to achieve this. Because my ...
1
vote
1answer
354 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
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
3k 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 ...
0
votes
1answer
304 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 ...
1
vote
1answer
375 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 ...