Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

2
votes
2answers
11k 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
722 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
8 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
22 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
596 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
593 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
613 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
599 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
594 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 ...
0
votes
2answers
607 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
2answers
51 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
10 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
63 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
640 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
19 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
34 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 ...
1
vote
0answers
26 views

Cross site collection lookup field (SPO)

I need to create "cross site collection lookup field" in the SharePoint Online List. I can programmatically change "List" and "WebId" in SchemaXml from LookUp field. It helps to get "cross site" ...
0
votes
1answer
668 views

Can a workflow populate values in a lookup field for all the items in the list?

I have a list called Contacts, with 4000+ entries. It currently has a dropdown choice column with four specified values for different offices (MAO, NHO, MEO and CTO). I want to convert this dropdown ...
1
vote
1answer
19 views

Use infopath for a lookup column different site collections

I have a client who has 2013 SP and has 3 different site collections. They have an infopath form that is used. However they require they need to get information from a different list in other site ...
0
votes
0answers
11 views

Required lookup field being submitted with no value

We have a list form which users can use sign up to work induction sessions with. The induction session dates are stored on a separate list. Sometimes if a user doesn't have the correct permissions, ...
0
votes
0answers
18 views

Sharepoint Multilookup Empty Field

I'm facing an issue with a multi lookup field while doing a REST API call using pnp-js. So I have this list (let's call it A) that looks up into another list (let's call it B) using a lookup field (...
1
vote
2answers
687 views

Update Lookup Column with Multiple values using Designer Workflow in SPO

In SP Online using designer workflow,I am trying to update a lookup column(with multiple values enabled) from another lookup column(with multiple values enabled).Both lookup columns are in different ...
0
votes
3answers
1k views

Null Lookup column getting from REST API with Expand it give no key for expanded column

I am using REST API to for getting data from SharePoint. I have one list like category with three column Title and two lookup name like childcategory, parentcategory. I have some data in which there ...
0
votes
1answer
13 views

Pull mulitple fields when getting dropdown choices from external data source

I've tried searching for this as I'm sure others have had the question but can't find a way to word it to find a result. I have two lists setup - one with a list of people and their data (IDs, First, ...
0
votes
3answers
122 views

Format text on lookup popup and text inside a table

I have a multiple lookup data inside a table. I have to format a text "Stato" with green background if it is "PRONTO CONSEGNA". And do the same thing inside the table isolating the single "Id_uni" ...
0
votes
2answers
87 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
1answer
1k 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
805 views

Calculating on Lookup column without the use of SharePoint Designer?

Trying to find a way to join values in two separate columns into a third however one of these is a lookup field to a second list and as I understand you cannot do calculations on lookups without using ...
0
votes
2answers
49 views

Calculated Column Formula to hide blank values

So this is a follow up from my question yesterday as I believe I have found a work around or at least a potential one. To cut a long story short I have a list called "Team Information" this contains ...
0
votes
0answers
53 views

How to retain previous lookup values when initial lookup value is no longer available?

On parent site, have an Employee list with employees who are available/unavailable during different periods. There are several subsite Project lists using Employee list as a look-up for available ...
0
votes
1answer
757 views

How to add hyperlink from other list with lookup

I gave up. The task looked simple: I have a list with clients with 2 columns: clientname, clientid, URL. I made another list where managers could collect clients from this list that they frequently ...
1
vote
1answer
56 views

SP2013 Changing lookup source values

List A is a list of products and details about each product. List B is a list of collateral that includes a lookup column refering to product names in list A. One of the products in list A is getting ...
0
votes
1answer
765 views

Restricting number of selections on a multiple lookup column

How can I restrict the number of values a user can select from a lookup column? It doesn't seem to have the same column validation settings as some of the other column types. I only want a user to be ...
0
votes
1answer
699 views

How Do I Format A SharePoint 2010 Search Refiner Lookup

In SharePoint 2010 Search, I've added a new managed property that refers to a lookup column. I then added a custom refiner by modifying the Refinement Panel "Filter Category Definition". Basically, I ...
0
votes
1answer
69 views

Lookup column adding new columns from source list

This is on SharePoint Online. I have two lists, A and B. List B contains a column which is a lookup column from List A and also pulls in some additional columns. I've now added a new column in List A,...
1
vote
1answer
738 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
0answers
67 views

List people picker graph

I am pulling a list via the graph api. I would like to be able to filter on a people picker field. However I do I use the lookup field id to equate to a user/member i.e the id 18 person joe blogs.
0
votes
1answer
783 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
102 views

Search API not returning lookup column values

I want to retrieve all the library items of a content type "Prod Request". I am using REST API for this. I am not able to get lookup column values.In below query my lookup column name is LookUp1. I ...
1
vote
1answer
816 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
0answers
88 views

Filtering view and workflows for lookup columns

I have 2 lists with the following columns: List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)" List B - "StatusNameReq"(Lookupcolumn based on the columns in List A) Now, I want to ...
0
votes
1answer
806 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
77 views

how to add lookup value sharepoint online

How to add lookup value (Title ) column "achat" : lookup field enter c if (itemEnum.moveNext()) { // update the item var current = itemEnum.get_current(); // add lookup field var ...
0
votes
1answer
59 views

Show all the lookup column data

I have 2 lists: House and Room. House list has lookup column call Room(Room1,Room2,Room3). When I add a record for house list, I choose Room1 which is hyperlink to lookup column. Is there any way, ...
4
votes
1answer
104 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 ...
0
votes
3answers
1k views

How can I enforce cascade delete relationship between two lists

I created a Sharepoint 2013 app and I am trying to connect two lists with a lookup. If I set RelationshipDeleteBehavior="Cascade" on the lookup field the deploy of the app fails even if I also set ...
3
votes
1answer
80 views

Connect lookup field to a list inside an app

I have a list in SharePoint online which should get a lookup a field to a list which is inside a SharePoint hosted app / add-in. Is it possible? My app has "FullControl" rights on the web and on the ...