The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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.

Filter by
Sorted by
Tagged with
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. ...
0
votes
1answer
839 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 ...
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 ...
1
vote
1answer
871 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
836 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
1k 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"...
2
votes
1answer
308 views

Sharepoint REST API empty value on expanded lookup columns causes error

I have a list with lookup columns. When I get an item from the list and expand the lookup columns, I get an error if any of the lookup column values are empty. For example if I have a list with the ...
2
votes
0answers
113 views

Selecting nullable property of an expanded object

Symptoms I have a list, call it Questions, that has a multi-lookup to another list, call it Answers. To get a single question by Id with its Answers, my query would look something like this... $...
0
votes
1answer
23 views

SharePoint 2013 - Related List Web Parts

I have two related lists (parent-child relationship) in my SharePoint 2013 site. The child list contains a lookup column containing the unique titles that exist in the parent list. I have added the ...
1
vote
1answer
16 views

SharePoint 2013 - Custom WebPartPage for List Form

I'm looking to add related lists to a Display Form for a list and tie them together with filters. I can create a new custom Display Form in SPD and add the related web parts with filters based of the ...
0
votes
0answers
24 views

Error: Binding a non-repeating control to a repeating field or group is not supported in SharePoint list forms

I am creating a sign-up list for a company potluck, and I want to show the number of certain dish types that have already been signed up for. Details: I have two lists: Potluck Signup List, and Dish ...
0
votes
0answers
23 views

Look-up Columns redirecting to folders changed their behaviour

I am using SharePoint Online site. Some months ago I created a lookup column in document library [A] that referred to another document library [B]. This was the best option I found to be able to ...
5
votes
2answers
133 views

Too many lookup columns error - stable list with no new lookups being created or used

Users & 'Full Control' site collection admin are unable to EDIT items. Error message reads: The query cannot be completed because the number of lookup columns it contains exceeds the lookup ...
0
votes
1answer
24 views

How to Update Newly Added Lookup Column using Value from the existing Choice column through powershell

I am working with SharePoint on prem 2019 and in one of the document libraries, I have a field called 'Trust' of type choice, this library contains about 7000 files. Now we have to convert this ...
2
votes
1answer
721 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
4answers
20 views

How to get value from Multi Lookup field using SharePoint rest API call?

I have one list with lookup column #lookupColOne and this value is used in #list2. #List2 have a lookup column of #List1 ID field. I want to get #list2 data along with #list1 lookup column values. ...
0
votes
1answer
855 views

REST API get lookup additional column

I am trying to get the data from an additional lookup column with REST API. I have two lists. The main list is "OIE Alerts" and the second list is Countries. The main list has the field "Country" ...
0
votes
2answers
39 views

Sorting multiple value lookup column - alternatives

Is it possible to sort lookup columns that allow multiple values or is there any alternative that can be applied in a modern list view?
1
vote
0answers
21 views

SharePoint Online (Office 365): REST API is not working from yesterday (19th September 2019)

Since from yesterday 19th September 2019, Simple Rest URL Select=* is not working. Note: list is having 12 person or group/lookup column excluding created by & modified by. However it was ...
0
votes
1answer
46 views

Microsoft Graph api user lookup

I have a user lookup field in SharePoint however the id given is the lookup id and not the userid. Where is the lookup id referencing? Looking at a link like this: Create list relationships by using ...
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, ...
1
vote
1answer
33 views

Adding a search function to a lookup column?

Situation: I have a list and a library. The list has a lookup column that allows you to choose multiple documents from the library. Problem: The library has several hundred documents, so it's very ...
0
votes
1answer
19 views

How to use GroupBy in lookup field

I have a lookup column and i want to use groupby for that lookup column in rest api. Anyone suggest me how to do this?
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
0answers
7 views

Copy result of additional lookup column field

I need a way to filter a document library based on the value of a lookup fields additional column. Set up: Lookup list has various fields including Company and Accountant. Document library has field ...
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 ...
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
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[...
0
votes
1answer
29 views

Sharepoint look up - big number of lookups, so I want to write them down instead of having cascade down option

I am creating a SharePoint lookup function for all the products of my company (there are a lot). I want to, as soon as I put the code of the product, have a lot of parameters appearing. Currently, ...
6
votes
2answers
348 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
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 ...
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 ...
0
votes
2answers
659 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?
1
vote
1answer
34 views

Lookup Columns in Word desktop are greyed out in properties pane

I am working with SP on Prem 2019. Users perform File->Save As from word or excel desktop apps and try to save it to the desired document library in sharepoint. The save fails as it expects required ...
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 ...
0
votes
1answer
54 views

mandatory lookup column doesn't work

So I have a pretty basic scenario. Two lists (Projects and Clients). In the Projects list I have a mandatory lookup field that aims at the Clients Title column. Now when I fill out the form for ...
0
votes
1answer
25 views

How to create a lookup field from another lookup column

I have one lookup column. I need to create another lookup column to look up the existing lookup column in different lists. I am notable to do this, Could you please suggest some idea to implement the ...
0
votes
1answer
51 views

lookup column in sharepoint modern page

I have sharepoint list where we have lookup column which is not loading the data(options) related. Anyone has idea how to resolve it. This is working fine in classic mode.
0
votes
2answers
40 views

How to view a list item and its linked items in simplest way?

There is one list Clients, and another list Projects. Latter is linked to Clients by looking up Clients ID column. Now if I am in Clients list page, how can I click one client row and somehow display ...
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 ...
6
votes
2answers
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 ...
1
vote
2answers
888 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
3answers
673 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: ...
1
vote
1answer
54 views

Display value of lookup fiels on webpart

I am beginner on SharePoint framework and with TypeScript. My problem is I have a list that contains a lookup type field "categorie", When I try to get the records from the list with rest API, the ...
0
votes
3answers
280 views

Lookup column agains list with more than 5000 posts

I am new to SP online. This is about a lookup column that displays data from another list which is currently exceeds the 5000 items limit? Any easy solution as I dont have much programming ...
0
votes
2answers
1k views

Add column (lookup field) to another site

I create a column "LookUpValues" of type LookUp in Site A but I'm trying to add from existing site columns in Site B but it doesn´t show up. Is it possible to do it? Any ideas?
0
votes
1answer
35 views

How To insert field of type lookup in the SharePoint List

I have a list with name Product Catalog and there are two lookup fields with name Country Preference and Location Preference one date field and multiselect field. I tested with list name without any ...
0
votes
1answer
650 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?
0
votes
1answer
626 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
36 views

Document Lookup Column

all, In SharePoint Online I have a doc library (Reference Docs) and a list (Projects). The goal is for users to choose a doc from a lookup drop-down in Projects, which, when clicked, will directly ...