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.

0
votes
1answer
24 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
19 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
16 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
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, ...
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
14 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 (...
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
71 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
0answers
30 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 ...
1
vote
1answer
33 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
41 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,...
0
votes
2answers
49 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
0answers
41 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.
1
vote
1answer
72 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 ...
0
votes
0answers
65 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 ...
1
vote
1answer
55 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
33 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, ...
1
vote
1answer
48 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
2answers
79 views

How to retrieve Multi Value Lookup List REST Api Sharepint 2013

have 2 lists, I tried to retrieve the values ​​of lookup field (one or more values ​​from the Finance list (Title, Country (lookup field to the list Country column "Title" $("#Finance").autocomplete({...
1
vote
1answer
43 views

Lookup User field limit

Is there any limit of lookup user field in ShP list(Sharepoint Online)? I've created just a simple list with over 18 single user select fields and everything seems to works fine, but I've seen ...
1
vote
1answer
103 views

Filter Lookup Multi-Select on previous selection

I have a Lookup Column called Region, and a second lookup column of type multi-select called Customer. I want to filter Customers column based on Regions selection. I found SPServices allows to ...
2
votes
0answers
91 views

Large Dropdown Lookup with Autocomplete

Wondering if anyone can point me in the right direction. Requirement is a drop-down field in a SharePoint Online list that references a customer table in SharePoint Online. Of course, the customer ...
1
vote
1answer
27 views

Using a Lookup Column (follow up question)

Following up this question on using Lookup columns: How to use LookUp column? How would you make this work looking up values from a calculated field (Store No) rather than manually inputting the ...
1
vote
1answer
29 views

Look-up column error

I am trying to implement same article as "Autofill column values of a list based on another list column value" Autofill column values of a list based on another list column value but unable to get ...
0
votes
1answer
41 views

Calculate with values in a lookup

we have built a list which lookups an amount in another table. This value is depending on other criteria in this list and we need to calculate a total. The output is hourly salary x hours worked. I ...
1
vote
1answer
79 views

Insert LookUp column in list using Sharepoint PNP PowerShell

I've this code bellow OfertaParticulares Connect-PnPOnline -Url https://test.sharepoint.com/sites/test/Negocio/OfertaParticulares -Credentials (Get-Credential) $listName="Páginas" $fieldName="...
0
votes
2answers
92 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
42 views

how to change lookup reference between sharepoint lists?

I have simple Sharepoint list named Alist with lookup value column. the lookup value column returns fields from other list named Blist. accidentally I have deleted this Blist and in Alist all lookup ...
0
votes
0answers
31 views

Filtered lookup displaying html in view

I created a filtered lookup column to pull in values from another list in my site based on a view. The drop down works great but when I see the item in my default view it is no longer a plain text. ...
1
vote
2answers
44 views

how to lookup multiple items from one list to another and the connect results into a string

I have list "A" in which i store name, email and product. I have a list "B" which should trigger an email based on some values. One of these values is product. If I chose "car", the workflow should ...
2
votes
1answer
57 views

restore sharepoint list lookup value

I have simple Sharepoint list named Alist with lookup value column. the lookup value column returns fields from other list named Blist. accidentally I have deleted this Blist and in Alist all lookup ...
0
votes
0answers
35 views

how to insert multiple values to lookup field in Sharepoint list?

I have Assignee field which accepts multiple values and its lookup column but whenever i try to post multiple values I am getting the below error "Cannot convert a primitive value to the expected ...
1
vote
1answer
57 views

How to add new value user field in sharepoint list?

I have people look up field in my list ..lets say "Checker" , its single selection user field but when i try to add user data to "Checker" field through rest api its not getting posted ... $scope....
0
votes
1answer
20 views

Javascript - Getting only 10 items from list column

I have a custom code to get data from a second list, this list returns some columns, but this code is getting only 10 values even tho the list have a lot more than that. I got this code from a ...
1
vote
0answers
18 views

SharePoint 2013 bulk edit column not updated

When selecting edit list, select the column, the choices are not updated from the lookup list. But if you edit an individual item the lookup choice is available for a selection. How do I get the ...
1
vote
0answers
41 views

Me Filter on Multiple Selection Lookup Column

I have found plenty of information about filtering lookup columns (title: Employee)during searches but I haven't located something that said using [Me] filter. I created a lookup column that has ...
0
votes
0answers
24 views

Document opens in tiny window

I have a list, in the list is a look-up column referencing a document library. (n.b. the Lookup column is actually a 3rd party column a Sparqube Lookup Tracker, but is a look-up column). Is there a ...
0
votes
1answer
58 views

SharePoint Lookup Column Additional Field Value

Hello SharePoint Community! So, I have a list of a item content type that has a Yes/No field. I reference this content type in a lookup relationship on a Document Library. From that lookup ...
1
vote
2answers
69 views

SharePoint Online Rest: Lookup Values visible in list, ID column does not reveal the Ids of the item

I have an odd issue today. When looking at a list I can see the lookup field is populated with an item, this is one of a few lookup fields on the list. However when I look at the results of a rest ...
1
vote
1answer
38 views

Sharepoint 2013 - Conditional validation on mutiple choice lookup column

Scenario: Sharepoint form created in infopath with multiple views. One multiple choice lookup column needs to be "Cannot be blank" for only one of the views. I have removed the ribbon save button and ...
2
votes
1answer
58 views

Lookup columns not visible in designer workflow

I have a massive 2013 list workflow build to handle projects on the SP Online platform. This workflow utilises a few lookup columns and people fields - but no more than 5! For some strange reason I ...
0
votes
0answers
32 views

Multiple choice lookup field does not render on edit form

I have, for the last few years, used a field called "Enabled" and a calculated field which returns the value of the Title field if Enabled is true. If Enabled is false, it returns an empty string ("")....
0
votes
1answer
34 views

SharePoint filter lookup field, based on another field in the list

I am using SharePoint online and am having trouble with the formulas since they are not exactly like Excel or InfoPath. This custom list I am creating has a lookup column for office locations and I ...
1
vote
2answers
137 views

Update Lookup Site Column

Is there a way to update a lookup site column? A colleague of mine deleted the list which the site column was referring to. We created a new list, but the existing site lookup column is practically a ...
0
votes
1answer
26 views

Syntax to update lookup columns with API rest in sharepoint 2016/online

I have a lookup column that I want to update using the Sharepoint REST API. the column is called "Titular" and shows the title of a list of companies. I have this code: const body: string = JSON....
1
vote
1answer
61 views

Provisioning Lookup field with reference to another provisioned list

I'm trying to provision two lists (List 1 and List 2). List 1 has a Title column and in List 2 i want to create a Lookup field with a reference to the Title column in List 1. The problem is that ...
0
votes
1answer
36 views

Fetching Data based on Look up value from another List

I have a small requirement , where in i have 2 lists say List A and List B. In List B, i have a lookup column which is looking up to List A column. Now on selection of Lookup column value in List B i ...
0
votes
1answer
33 views

Sharepoint Online- out of the box solution

Never used SharePoint before and have been given the task of setting up SharePoint Online and migrating list from SharePoint 2001. I set up subsites, however I now know that I cannot create lookups ...
0
votes
2answers
287 views

Insert user field using REST API

I have issue with my query to post item on test list, it returns 400 error. My list columns: Title | user Here is my body of json: const body: string = JSON.stringify({ "__metadata": {...
1
vote
1answer
71 views

OOTB: Manage employee skills requirements and departments in SharePoint

Need to create a log and a matrix for tracking requirements for job skills, required and after completed. Employees by location and current rank. Skills by categories, levels, and areas. Master list ...