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

learn more… | top users | synonyms (1)

2
votes
0answers
64 views

Recurring Events in Calendar created from a template

Using SharePoint 2013 on-premise, I had a calendar working nicely in my test environment. I then Saved it to a template, moved it to another site collection and created a new calendar. It had lookup ...
2
votes
2answers
191 views

Counting the number of items added in LookUp column

I have a lookup Column in my list which can take multiple values. So I need to count the total number of items added in that lookup field. What is the simplest way to do this?
0
votes
0answers
60 views

Get Lookup Value in SharePoint 2013 List

In Sharepoint 2013, I have 3 lists containing these fields: Part Data: Part Number (a lookup field) Supplier Number Buyer Number Parts : Part Number Supplier Number Suppliers : ...
0
votes
0answers
173 views

How to remove duplicates from a lookup field in SharePoint 2013 online?

I have a lookup field which is created from the same document library and it is a multi selection lookup field. The values in Lookup having duplicate values. Are these duplicate values are showing ...
1
vote
1answer
97 views

How to remove hyperlinks in the Look up field

How do you remove hyperlinks in the Look up field using jQuery in SharePoint?
0
votes
0answers
39 views

Look-Up a Multiple Line of Text Column

I am looking for a solution that allows me to refer a multiple line of text column to another list in the same Site Collection. I find a lot stuff about SharePoint 2010 where it wasn't possible to ...
2
votes
0answers
31 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
1
vote
0answers
47 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
114 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 ...
0
votes
2answers
67 views

Different Users ID on each sites

I actually have a site we will call "Team" and one we'll call "Direction" And a list "Projects" in each of those sites. I wrote scripts to make save of each sites, looking if there are new entries in ...
1
vote
1answer
26 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 ?
0
votes
1answer
171 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(); ...
0
votes
3answers
75 views

What is wrong with the lookup in my InfoPath Form?

I have SharePoint Online list which I am customizing with an InfoPath form. Two of the fields on the Form are lookup fields with a secondary Data Connection to a second SharePoint List with Fields ...
0
votes
1answer
157 views

Lookup on same list

Are there a way OOTB if i have a lookup on my own custom list. If i select an other item. The other item is automatically linked. For example. I have list "test" with a lookup on "test" (so same ...
2
votes
1answer
87 views

SharePoint 2013 and O365: Lookup column Value ID missing

Okay, this is my first question so forgive me if this is long winded. TLDR: I cannot seem to be able to target or get the Value ID of the Category Column in a blog post rollup. Why is this? ...
0
votes
0answers
52 views

Validate over-20 dropdown lookup column

I have a lookup column with over 20 items so it displays the more complex (input element) dropdown menu. The trouble I'm having is that users can type anything into that input, even if it does not ...
2
votes
1answer
68 views

Multiple Choice Columns-Checkboxes. Is there a different format?

I have a column which uses a lookup to another library. I need the user to be able to make multiple selections based on this lookup, however the problem I have is that this library contains hundreds ...
1
vote
3answers
284 views

How to insert data into lookup column using javascript

I have created a custom drop-down list and inserting drop-down data into lookup column(in a list). How to insert drop down data into a look up column? I am trying below code but it is not working. ...
0
votes
0answers
25 views

Help with establishing list relationships between sites

I need some advice on allowing my lists to lookup information from parent lists. Parent Site: List: Employees List: Departments Employees primarily contains single lines of text. (fname, lname, ...
0
votes
0answers
28 views

CustomNew form additional lookup field

I'm not SharePoint developer, i'm just trying to add more info to my default new form but my knwledge is limited : Ok, i have list A called 'Service', and list B called 'Purchase'. I have lookup ...
1
vote
1answer
109 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 ...
0
votes
0answers
84 views

Dynamically Show the values in Drop-down Menu based on user name

I have a custom task list with a column that is designed as a drop-down menu (values: a, b, c) and a column "Assign To". My design goal is when users try to edit this list via the form, SharePoint ...
0
votes
0answers
52 views

SPD13 - Need Calculated column to include a lookup column in formula - workflow option

I have created a custom list called Account Code (which has 2 columns) Account Description Account code I have created another custom list called Codes (which has a few columns). Users will be ...
0
votes
0answers
76 views

Associating content type containing lookup site column to custom list programmatically using CSOM ERROR: Value does not fall within the expected range

I have created a list using CSOM - works fine. & associated a content type(Without Lookup Column) - works fine but If there is any lookup column associated with Content Type & when I try to ...
0
votes
1answer
37 views

Columns missing in LookUp target list

I'm in a project using SharePoint Online and want to add a lookup column type, but when trying to relate it to a specific list, show me a few columns in the list which has more than 30 columns, I ...
0
votes
1answer
38 views

SP13: Lookup column with multiple selections

In SP10 and later this was not possible, but it's hard for me to find if Microsoft has made it possible in SP13. I have created a lookup column and wanted to be able to select multiple choices from ...
2
votes
1answer
67 views

Exporting a list with lookup fields

I'm in a situation where I need to export 2 lists from site Site A to Site B. The lists I'm exporting have a lookup relation. List X has a lookup to List Y. List Y gets imported to the new location ...
0
votes
0answers
65 views

Using multivalue dropdown as a quickpart in word document

When using a lookup multivalue dropdown as a quickpart in a word document, creation of document fails. Using any other type, besides a multivalue dropdown, it works fine. When this error occurs, the ...
0
votes
3answers
82 views

Best Practices to declaratively create Lookup Fields in a solution

I am often coming to the point that I need to create lookup fields pointing on lists which are also created in the solution. There are many ways to do it either by using feature receiver or by using ...
0
votes
0answers
104 views

Add multi valued lookup column into another list using sharepoint 2013 workflow

I have a requirement where I have two tables(say A and B) and one master table(say Tech). Both the list contains tech as multiple value lookup column and another column say status on which the ...
2
votes
1answer
175 views

Remove Hyperlink for Multi Value look up column in Sharepoint

How can we remove hyperlink from a multi value look up column in SharePoint 2010 list. There are article on removing hyperlink from Single Value look up column. But I am not able to get a way to ...
1
vote
1answer
173 views

Lookup With Picker Not Working

I have a document library on SharePoint 2013 that has a column that is defined as type "Lookup with Picker" that looks at a list within the sub site. I have no idea if this is a SharePoint ...
1
vote
1answer
450 views

How to call SharePoint Rest Service with CAML and Lookup column [duplicate]

I am trying to query sharepoint list which is having Lookup columns. So to do so I am using below JavaScript function function getDataWithCaml(oDataUrl, caml) { var requestData = { ...
0
votes
0answers
69 views

Sharepoint Lookup List (Double lookup?)

Context: Duty manager list, changes weekly. I have two tables: Table 1 is a list of all managers, their department name, and their mobile. (Columns: Manager Name, Department, Mobile number) Table 2 ...
0
votes
3answers
126 views

CAML Lookup - get different value from lookup list using query

Say I have two lists: Support Pack ID : 1, SupportPackTemplateLookup:(ID#OtherValue), IsActive : True Support Pack Template: ID : 1, OtherValue: x, SuppType: 10 hr support pack ID : 2, ...
2
votes
0answers
38 views

Lookups in SharePoint Workflow Emails

I've created a workflow that sends an email to all users when any new item is added to my "Payroll Processing" list. I want to be able to display the Client Name in the email that gets sent. The ...
1
vote
1answer
48 views

How can I put a “Lesson number” in a column field based on time item created

I have a list being used for a school to record when a student is out of class. I want to create a column in this list called "Lesson" and have this automatically be filled based on the time that the ...
1
vote
2answers
66 views

How to determine which field is lookup field via REST API

I have to load data from various lists with various views via SharePoint 2013 REST API. I have no knowledge about fields that are configured in views (general fields, custom fields, lookup fields, ...
0
votes
0answers
33 views

The additional field I have added to my Lookup Site Column isn't showing up in my list?

I am using a lookup site column in my LIST2 that also automatically picks up other fields from the original LIST1. I have now added an additional date field from LIST1 to my site column - but it isn't ...
1
vote
0answers
68 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
1answer
155 views

Does SharePoint Online have a lookup column threshold?

My understanding is SharePoint Foundation, Server, and Server Enterprise have a default lookup column threshold of 8 to listview. I thought this would be an easy thing to locate online, but I haven't ...
1
vote
0answers
62 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 ...
0
votes
1answer
109 views

Get selected Value from Lookup Dropdown on ItemAdded

I am attempting to grab the text value of a lookup dropdown after an Item is Added. The way I'm currently doing this, gives me the string 23#ADMIN, which is the combined ID and text. I could go the ...
2
votes
1answer
62 views

Access lookup Site column from subsite

Is it possible to create a lookup site column at root site and access it from its subsite? I created it using site column template at root site and it was accessible at root site when added it to a ...
0
votes
0answers
107 views

Advanced Search on a lookup column

I am looking to customize the advanced search web part to allow users to search on a property which is a lookup. I have managed to find the crawled property, mapped it to refinablestring00. Then I ...
1
vote
0answers
60 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 ...
0
votes
1answer
24 views

Can I stop Filter Items from truncating on Column Filter Dropdown (…)

I have a Lookup field on a Library which is related to a List of Items. After these items reach a certain length, the items in the Filter Dropdown get truncated, and a '...' is added to the end of ...
0
votes
1answer
48 views

Order of Items in a single feature

Can we set order for items in a single feature? I was trying to create a site column of type lookup for which the lookup-list should be created first after that only we can create the column. In my ...
0
votes
1answer
56 views

Allow Posts and Discussions to use same Categories lookup field

I am creating a Community site and activating the BlogContent feature on that site. There are conflicting issues, because the Community Site and the BlogContent feature both create a Lookup List ...
0
votes
1answer
146 views

Invalid Lookup Values Found Error

I have a simple list with a non required lookup column. If I try to create a new entry in the list with the lookup column left as "none", I receive the error: The list item could not be inserted ...