Questions tagged [lookup-column]

A lookup column is a SharePoint list column that retrieves its available values from another column within another list in the SharePoint site.

358 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
26 views

Lookup column that auto filters bases on site pages.

I'm building a form that surveys user's opinion of the page the page viewed by the user. I have a list with a lookup-column that gets the ID from site pages. I'm looking for the ID to be ...
1
vote
0answers
28 views

Lookupfields in SharePoint hosted add-in

Is it possible to use Lookup fields in SharePoint Hosted Add-ins ? I can add them via GUI in VS, (similar to this http://www.enjoysharepoint.com/Articles/Details/add-lookup-field-type-column-in-list-...
1
vote
2answers
173 views

How do I include a blank in a datasheet dropdown?

Using the datasheet view, I have a list setup and one of the columns has a dropdown. I want to include a blank space as one of my choice options.
1
vote
0answers
274 views

Using a lookup column to filter library web part

I want my users to select ID's in a list - those ID's have been contacted that day. The problem is: for future reference, the managers want to go back to that day and easily access all library items ...
1
vote
1answer
42 views

Need help in adding new lookup column in SharePoint List

I have a list for Person in which there is a lookup column for StateID of States list. In States list there is a lookup column for CountryID of Countries. I want to add CountryID to Person list by ...
1
vote
1answer
327 views

How can I create a [Me] filtered view using a Lookup column with names in it?

Any help will be hugely appreciated as really struggling with this. I am limited by company regulation saying I can't use code so any answer will need to be code free and not require the use of Design ...
1
vote
1answer
453 views

Need CAML query LookupMulti column help, Is it possible?

I am trying to create a CAML query for querying list, here is my problem. There are a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
1
vote
0answers
80 views

Lookup doesn't work on field that has taxonomy field

Is there any reason why lookup field in one list would stop working when taxonomy field is added to other list that lookup is referenced to? Before adding the taxonomy field lookup was working just ...
1
vote
0answers
607 views

Lookup to a column in a library having multiple hierarchical folder structure

I have a library A that has multiple folders and documents. I want to create a list B with a lookup column pointing to a column in Library A. The problem I face is that the lookup column fetches ...
1
vote
1answer
264 views

Create Lookup + Calculated column

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
1
vote
0answers
61 views

Auto generate sequence column + a look up info column from another list and calculate in Sharepoint 2013

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
1
vote
1answer
751 views

Create a LookUp Column using SPServices “UpdateList” operation

I want to dynamically add a new list ("AddList" operation), and then use the SPServices "UpdateList" operation to add "newFields". I was able to get the "Text" fields to add properly, but the LookUp ...
1
vote
0answers
477 views

Auto Fill Lookup Column

I believe I am starting off on the right foot by using a lookup column. I am seeking a way for when a user enters in a order number the number auto populates in a choice column. So basically every ...
1
vote
1answer
862 views

Validate text column against [Me]'s Display Name

I have two lists in SharePoint 2013 Trips Drivers Drivers has a column called Active Driver that is a single line of text formatted "Lastname, Firstname". Drivers also has a separate column that is ...
1
vote
1answer
60 views

Add column to new document library template

a was trying to found a way to add a new column to List / Document L template!? I want to add a lookuop column to this view, is it possible ?
1
vote
1answer
1k views

Clear multi-value lookup via Jquery SP 2013

I am trying to clear a multi value lookup field using javascript when an item is re-edited. I have tried all the following combinations without success $("input[id^='Test'").removeAttr(); $("input[...
1
vote
1answer
2k views

Displaying multiple column data in a drop down menu

I'm using SP2010 unfortunately without SP Designer and only used InfoPath once. I have 2 lists: List A - Is a list of 'Event Codes' with a 'status' column displaying Active, Used or Reserved ...
1
vote
0answers
114 views

display lookup multivalue in quickpart

I have a lookup field with multi value. I'd like using quick part in my template (i know how to use quick part) But i need displaying multiple value (lookup multisel) in a dynamic table. How can i do ...
1
vote
0answers
353 views

Secondary lookup columns missing in Display/Edit form view

I have one list that has a lookup column for 4 different lists. Each lookup column also brings in a secondary lookup column which is a Calculated Column. I can bring both the lookup column and the ...
1
vote
0answers
124 views

Why aren't the addition field columns populating when I select a value from a lookup column?

I have an Equipment List that looks like this: Number Description Mill Area 1 pump warehouse 2 motor outside 3 shaft yard 4 bearing ...
1
vote
1answer
79 views

List form or Infopath filtered choice column

I'm about to start building a custom list to capture a number of different query types. I was intending to do this with some custom Site Content Types but I've realized that I'm going to need to ...
1
vote
0answers
78 views

How can I change the Mobile View “lookup” list threshold?

I came across a limitation when using "Mobile View" where my lookups were displaying a maximum of 20 items. This only happens in mobile view. How can I change or remove this threshold limitation? ...
1
vote
0answers
628 views

Cascade delete from lists

I have 3 lists with a lookup field to a document library. This fields is created from XML (deployed) with this properties: Indexed="TRUE" RelationshipDeleteBehavior="Cascade" Now, what I would ...
1
vote
0answers
65 views

Sharepoint 2013, cascading lookup/dropdown what happens with old data if data changes

Situations tend to change, so sometimes cascading dropdown menu's get adapted because they are no longer relevant ... My question is: what happens with metadata based on the old cascading dropdown ...
1
vote
0answers
84 views

SharePoint 2013 choice column DropDownlist

Is it possible to update a Choice column with workflow ? I have created a list and created a lookup column that displays the name Company. I have connected the column to a document the Library of ...
1
vote
1answer
2k views

Lookup field value is not getting set when using Client object model

I have a document library (contact). Have created a custom list (workstatus). Have added column to contact library which is lookup of workstatus. Below is my code using which i am setting the lookup ...
1
vote
1answer
570 views

How to change lookup hyperlink to open in another tab instead of a dialog in SP2013

Currently when I click on the accounting projects link: This dialog box opens: Instead of a dialog box I want this page to open in a new tab: Any Ideas on how I can do this? I tried using the ...
1
vote
1answer
102 views

Lookup Column of a List Column

I have a requirement for a project site in SharePoint. The Site will have: 1st List: a Stakeholders List with the names of people involved (people/group type) in the project and their Project Role (...
1
vote
0answers
107 views

Limit dropdown options when the lookup column is a site column and has more values than are relevant

I have a list of projects on my parent site with two columns: ` Project Category I would like to use Project as a site column that looks up values from the aforementioned list so I can maintain a ...
1
vote
1answer
77 views

Create a Cross Site Lookup in a declarative way

I can declare a lookup field with this line: <Field ID="{3EA24157-1C11-41CB-AA01-5EEEF93C2603}" Name="NewField" DisplayName="New Field" StaticName="NewField" ...
1
vote
0answers
109 views

How to filter lookup field by site name

I have a list like this: Title Site AAA Site1 BBB Site2 CCC Site2 which is referenced in a lookup column. Requirements are to filter in the lookup column only the items whose "Site" property is ...
1
vote
1answer
81 views

Moving files between Libraries along with Lookup Columns?

Is it possible to move a file from one library to another along with the lookup columns associated with it?
1
vote
0answers
2k views

SharePoint Online Lookup Dropdown Autocomplete/Combobox

I have a list in Sharepoint Online, which has a lookup to an other list. No matter what, on the form it will always render as a dropdown value. When this list of values becomes huge, it's hard to find ...
1
vote
0answers
185 views

How to Update/Set Field values by LookUpId in a sharepoint list?

I have a list called ResourceCheckList which contains following columns with lookup fields as below : Here Resource:ID is a lookup column which contains unique ID of another list. So, I want to ...
1
vote
0answers
753 views

CSOM retrieve List Item doesn't show some Lookup Key Value pairs

I try to load a ListItemCollection from my SiteCollection using CSOM C#. Therefore I use the following List rr = web.Lists.GetByTitle("MyTitle"); context.Load(rr); FieldCollection fcol = rr.Fields; ...
1
vote
1answer
83 views

Searching between two separate lists for matches

I have two SharePoint Lists each with a column called Unique Key, what I need to do is search list B for matches in List A. List B is the larger of the two and each List contains only unique entries ...
1
vote
0answers
61 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
1
vote
1answer
129 views

Update list item once library item is created

We have a list that is used to notify people that they need to create an item in a library. We want to update a field in the list once the item in the library is created. We tried to use the method ...
1
vote
0answers
43 views

How to develop an event receiver on selecting item from dropdownlist

In my SharePoint list,I have a lookup column. When I select one item from the lookup,I need to show the information from the selected one(like title,ID...). I think that developing an event receiver ...
1
vote
0answers
131 views

How to auto generate parent MMD columns based on child MMD columns?

This is the structure of one of my Term Sets. I have a Site Column called Record Type (Deeds, Agreements, Permits) I have a Site Column called Deed Type (D1, D2, D3) I have a Site Column called ...
1
vote
1answer
366 views

Lookup Column - SharePoint 2010

Is there any way to link parent site and sub sites? Problem: I have one list on Parent site and I have a few other lists on sub sites. I am trying to create lookup columns in the parent site list to ...
1
vote
0answers
53 views

Document Set lookup error

I have what seems like a minor bug when setting up a new document set. I've created a new content type based on a document set. One of the columns in the document set is a look up to a supplier list. ...
1
vote
0answers
589 views

Creating a survey with a question being lookup column with filtering

So I need to create a survey on a monthly basis with just one question. Possible answers should be the values from a lookup column, but limited only to those from the previous (calendar) month. Is ...
1
vote
0answers
268 views

SPD 2010 workflow, update (add and delete) lookup column

I have a list (with a custom InfoPath form) in which I have items that have a Parent / Child relationship with two lookup column to the title column of same list. The two lookups are "Child of" single ...
1
vote
0answers
27 views

Display deactivated items in lookup column

We have a list of projects. One column is named Status (a choise Active or Finished) One column is Active Projects (a calculated column which shows only the actieve projects) One column is named ...
1
vote
0answers
2k views

Site Lookup Column As Managed Property

Please let me know if my logic here is incorrect or suggest better alternative. This is hosted on Office 365. I have a Site Lookup column (EventLookup) that is linked to a list on my Root Site --> ...
1
vote
0answers
340 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
390 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
0answers
538 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 ...
1
vote
1answer
432 views

Include additional fields with Person Site Column

When I create a column of type Lookup, there is a section at the bottom labeled "Add a column to show each of these additional fields:" I want to do this same thing with a Person column. It seems ...