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.

0
votes
0answers
11 views

Indexing lookup column in SP2019

I am working on a project where a document library is about to exceed threshold and lookup column is one of the metadata columns being used in the library, I am working with SP2019 on prem. The ...
0
votes
1answer
38 views

Replace HTML list values with substring on SharePoint 2013 Custom List Field

I'm using SPAutocomplete from SPServices because I have a requirement to make a searchable lookup field rather than an OOTB lookup field (drop down menu), as there is potential for thousands of values ...
1
vote
1answer
747 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 ...
0
votes
1answer
800 views

Lookup column added to list created by importing Excel spreadsheet not working

I have a list on a site that was created by importing an Excel spreadsheet. I have several lookup columns that were deployed to the site using a feature. Going into the site columns gallery, I see ...
0
votes
1answer
1k views

Link two SharePoint lists and edit at the same time where one list can have multiple items per one item on the source list?

I have two sharepoint lists. The first, LIST1, is a location listing with a unique plant code to each. The second list, LIST2, is a list of contacts with a column that ties back to that plant code. ...
1
vote
2answers
163 views

Lookup field deployed through feature can't be added to new list

I have deployed a number of fields, content types, and list definitions/instances to a site through a couple features. The fields and content types are deployed through a Site scoped feature, and the ...
1
vote
1answer
834 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 ...
0
votes
1answer
818 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 ...
0
votes
1answer
15 views

Multiple Cascading Delete

I have 3 lists, lets say A, B, and C I have a lookup in a column from B to A I also lookup in a column from C to B. I have the column lookups in B and C as Cascading Delete. If I delete A, I know ...
0
votes
0answers
25 views

Can I lookup what a lookup column looks up?

To explain the concept, let's pretend I wanted to make lists of cocktails and ingredients. First off, we have a list of ingredients (gin, rum, campari etc.) and columns of relevant information (cost, ...
0
votes
4answers
5k views

Is it possible to have a lookup field with autocomplete feature

I have defined a lookup field with multiple values over a contact list inside my SP 2013 team site, and by default I got a select list as follow:- So is there a way to have the lookup field with ...
1
vote
1answer
1k views

Get value automatically similar to Excel's vlookup function

I want to get data from another list automatically based on a column from this list. Let's say the source list shows the ID A, B, C and the related values 1, 2, 3. In my list I show in a column one of ...
0
votes
1answer
962 views

copy one column value to another column in a list

I have a list named ABC in MOSS 2007 List has 2 Views (All Details and Multi Location) 2 columns (BA-tech and BA for both views) BA- tech field is "Single line of text" type and BA field is "Look up"...
1
vote
1answer
29 views

column formatting with json for lookup fields

I have problems formatting the column of a lookup field with json. Precisely, it is an additional field, displayed from the parent list that I want to format. The lookup field is of type multiple, so ...
1
vote
4answers
18k views

Get value from drop down using jQuery (lookup column)

I feel like this should be an easy one but am having trouble finding the answer here and via Google. Using jQuery, how do I retrieve the currently selected value from a dropdown in an EditForm/...
5
votes
2answers
149 views

SharePoint 2013: Error while creating lookup column

We are using SharePoint 2013. We have two lists in our site: one custom list and one calendar list. We are trying to add lookup column in Calendar list and referencing the custom list. Adding ...
2
votes
1answer
644 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
0
votes
2answers
3k views

Multi select Lookup column returns null in javascript client object mode;

I am trying to retrieve the selected values of multi select lookup column and store them in array and then set the lookup column with the same selected values after drop down value changes but always ...
0
votes
2answers
30 views

Lookup Column Value through Rest API

i have a small requirement, where in i am pulling in a lot of data from List A to List B through Rest API. but i am stuck at one place where in i am not able to pull in lookup value in List B. Hope ...
5
votes
1answer
1k 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

How do I send data to a lookup field with ReST? SP2013

I've been working with a jQuery AJAX call to post data to one of my SharePoint lists. One of the fields in this list is a look-up field. In forming my JSON data to push to the list I was able to ...
0
votes
1answer
1k views

Adding a many to many relationship, and having a form input data into two lists

I'm building a form for a Marketing Event list. The list would track name/type/location/date etc of the event and also those people associated with it (for example recipients or attendees) These ...
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
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[...
2
votes
2answers
5k views

Workflow Error: Coercion Failed: Input cannot be null for this coercion

I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here's how the data looks: Look Up Title ...
0
votes
2answers
627 views

Columns not displaying value

I've added some columns (name, ID etc ) to the document library after the documents have been uploaded, and got no value displayed. Is there any way to fix this or I'll have to recreate the library?
3
votes
2answers
12k views

How can I pass a Parameter via Query String to populate a lookup field on a New Item Form/DVWP?

I have two lists: List A: Products List B: Requirements I'd like to have a nice Create Requirement page launched from the Product Listing page. I have a DVWP/Multi-Item View displaying all Products....
1
vote
1answer
2k views

Sort Order of a Lookup Column

I am trying to sort my lookup column based on a column called sortby. I've tried an few of the suggestions, but just can't seem to get it to work. This is what I have tried and it doesn't sort by ...
2
votes
2answers
2k views

Pull multiple values through a lookup

I am rather new with SP so I apologise if I cant express myself too well. Problem at hand: Two lists - Shops and Managers with a many-to-many relationship between them. I.E. in Shops there can be ...
1
vote
4answers
28k views

Is it possible to make a lookup column that looks up “Person or Group” type from another list?

I'd like to create a lookup column in my list (hopefully using OOTB functionality) that shows a column from another list. Sounds simple enough, but the available columns to choose to lookup from my ...
0
votes
0answers
30 views

Lookup to populate Text Box or Dropdown

I was following this to pull Additional Fields to appear on the form using calculated field and it is worked perfectly. However, when I try changing the calculated field to text box, it won't load in ...
0
votes
4answers
1k 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 ...
2
votes
2answers
12k views

Set value in lookup field in workflow?

how can I set only the one value to required lookup field, when I create new item in workflow. I tried use workflow variable, ID but I do something still wrong. So I have one list A wiht values AB, ...
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
2answers
791 views

Retrieving Lookup Values, Javascript SharePoint 2013, Not Working

I've seen a lot of info on the above question but none of it has answered what I'm looking for, so far. I'm trying to retrieve list items that have a great number of lookup fields. I've had success ...
0
votes
0answers
28 views

Cascading lookups/filtered choice columns in modern sharepoint

We are using modern sharepoint pages. I currently have a document library with a column that indicates the subject of the document. there's a 2nd column that has the sub subjects. I'm looking to set ...
0
votes
0answers
27 views

SharePoint - Infopath - Lookup Field - Filtering Out Items

I'm working with a SharePoint List (we'll call it List A) that has a lookup field to a second list (List B). List B has two fields: REPORT_NAME & RETIRED. RETIRED will either be blank or have an '...
0
votes
1answer
621 views

The lookup that you defined is not guaranteed to return single value

Error: The lookup that you defined is not guaranteed to return single value. If more than value is returned only the firs value will be used How to return multiple values from a lookup column?
6
votes
1answer
3k views

set multiselect lookup column using jquery

I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons. The user populates the right-hand side of the control with some values by ...
0
votes
3answers
635 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, OtherValue: ...
0
votes
1answer
625 views

look up column error

I am getting into a null array - $spList = $webobj.Lists["Studentlist1"] Exception calling "update" with "0" argument(s): "This lookup field cannot enforce a relationship behavior because it is not ...
1
vote
2answers
2k views

How to get the value of Person field and Lookup field depending on ItemID using Javascript/Jquery?

I have a form where I have a lookup field displaying issue ids of same list. On selection of Issue id, Person field (Issue Assigned to) and other Lookup field (Function) to be prefilled. I have ...
0
votes
1answer
609 views

How to submit multi-checkbox items in a formatted string to SharePoint lookup column

I'm new to InfoPath and SharePoint and i also use the trial version of qRules, i have 2 sharepoint lists, with one (let's call it "list1") having a lookup column to the second ("list2"), and this ...
0
votes
1answer
597 views

Lookup items says “Count Related”

I am not very skilled with SharePoint, but I have been tasked with using it on a daily basis, and am always at least "trying" to make improvements to it. The issue I am having today is that I have 2 ...
1
vote
2answers
175 views

Can we create a look up column from multiple lines of text column in list

we need to create a lookup column from multiple lines of text column in SharePoint online list is it possible.
0
votes
0answers
13 views

Adding a sum column which uses data from lookup

I have a list with employee names and a lookup column from another list, which has the training names and training duration. The training duration is added as an "additional field" from the lookup ...
0
votes
1answer
79 views

Update another field with an id of a lookup column

I have a list with around 1000 columns and I need to be a able to prepopulate another field with a lookupid of another lookup field on the same list I am getting error when I use: var ...
0
votes
1answer
679 views

SharePoint Error Invalid look-up value. A look-up field contains invalid data. Please check the value and try again

While trying to update a value in pages library, I am getting below error: Invalid look-up value. A look-up field contains invalid data. Please check the value and try again. This is happening for ...
0
votes
1answer
33 views

Getting link from lookup document library

I have created a Lookup field linked to the document library which allows multiple files. I am able to get the Title of the linked documents, but I can't find a way to get the url? How can this be ...
0
votes
2answers
52 views

Create a self-lookup field which only show certain items based on criteria

I am working on a sharepoint online classic team site. where i added a custom list named "Pricing", which contain these main 2 fields:- 1) a column named "Type" of type drop-down list and have 2 ...