Stack Exchange Network

Stack Exchange network consists of 174 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
Make your voice heard. Take the 2019 Developer Survey now

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
13 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
35 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
23 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
32 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
15 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
28 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
32 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
48 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
31 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
47 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
16 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
16 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
25 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
17 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
38 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
44 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
20 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
37 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
30 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
30 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
52 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
20 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
29 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
25 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
32 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
110 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
59 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 ...
0
votes
1answer
36 views

How to migrate site collection using powershell (SharePoint Online)?

The requirement is to migrate all the Lists(SharePoint Online to SharePoint Online). I have tried many ways. But Lookups don't work. It creates the lookup column with an empty reference to the other ...
1
vote
2answers
89 views

Is there a way to pass the Title of a parent item to the create form inside a Child list

We have 2 custom lists inside our sharepoint online team site:- Dept list. Employee list. this list has a lookup column to the Dept list. so inside the Employee Create & Edit forms, there will be ...
0
votes
1answer
79 views

SharePoint 2013 Lookup column

How to fetch I'd of the parent list from a lookup column value. I have created a report using jQuery data table in child list.( Ihave the lookup column in this list which is referring to the parent ...
1
vote
2answers
185 views

Set current user as default value for lookup column

I have a list with one Lookup field stores employees and one people picker, what am looking is based on a user login I want the user name to be default in the people picker and if the user name exists ...
0
votes
1answer
27 views

Data in Lookup Columns goes missing

We have SharePoint Online and within one site a Document Library. Within the Library are 8 Lookup columns that reference lists within the same site. When a Document gets uploaded to the Library, a ...
0
votes
1answer
78 views

Sharepoint Site columns how do i add a year in our column

I want to add 2019 to 2020 look upon our YEAR column. Please assist
0
votes
1answer
145 views

Expand Multiple Lookup field whit Microsoft Graph

How can I Expand a Multiple Lookup field whit Microsoft Graph. I need to get all fields from a multiple lookup field. Thanks.
0
votes
1answer
154 views

Filter dropdown/lookup field based on date

I have a Secondary List(B) that my Primary List(A) uses to populate a field in InfoPath called 'Current Pay Period' which is a drop down. List B contains a calculated column to display dates since ...
0
votes
1answer
43 views

Validation of lookup fields

I am using the following Javascript code using Script Editor on NewForm.aspx. It supposed to be working but by debugging I can see that the value returned from the dropdown select is empty. I looks to ...
0
votes
3answers
184 views

How to auto-populate specific column items from another list with related item

Salute comrades, So, i have two different lists say, ListUn and Listdeux, the fist one "ListUn" having items Test1 & Test2 under the fist column TestPand second column ColToPopulate ( see ...
0
votes
0answers
26 views

Populate a column based on another

I have a list of codes and corresponding locations (e.g 0001 = London). In another list, I created a Lookup column so that if a user selects a code, the corresponding location automatically populates ...
0
votes
1answer
70 views

Lookup columns in SharePoint Online

After configuring 2 lookup columns in a library that uses 2 different lists for lookups, we are unable to view any new items added to the 2 lists in the lookup column in the library. What would cause ...
1
vote
1answer
61 views

Query on a table with lookup columns doesn't work

What I have I've got 2 lists (listA, listB). In listA there are several lookup columns to listB. What I want to do I want to create a query that updates a field in all items in listA from 'empty' to '...
2
votes
1answer
29 views

How to set MultiLookupField in Workflow 2013 [duplicate]

I'm working on SharePoint 2016 OnPremise, Workflow 2013 and I'm trying to set a MultiLookupField with one ore more values. I tryied to set 1;#2;#3;#4 and 1;#;#2;#;#3;#;#4, or for one single item 1;#;# ...
0
votes
1answer
270 views

Auto-populate an existing column based on another column using data from different list

I have two lists filled with data (listA and listB). A is a list of people with column 'DepartmentName' in it. B is a list of departments with columns 'DepartmentName' and 'Building'. I want to ...
1
vote
0answers
134 views

Fetch values into dropdown list column based on query from another list - jquery

Please help me with some code (preferrably jquery). Sharepoint 2016. I have List 1 with columns Resource, Attribute1, Attribute2,..., Attribute10. And I have another List 2 with columns Project, ...
0
votes
0answers
151 views

Add Field List Instance to List Content Type using PNP Provisioning

I'm using PNP provisioning templates. I have created a template for the root site that creates columns and content types. In the subweb, I have another template that creates 2 list instances. One ...
0
votes
0answers
40 views

Change Sort Order of Lookup Column

With the introduction of JSON Formatting for columns, is it possible to edit the sort order of a lookup column? Or is it just in the list view? Any good way to do this? Thanks.
0
votes
1answer
38 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 ...
1
vote
1answer
34 views

List Filter in Look up

I have a list which contains a column for Name and a column for Department I'm building a secondary list which will contain two look up columns. These looks ups will display the Name column from the ...
0
votes
0answers
20 views

Lookup Column in Sharepoint

I have 2 lists. In the first list I have a code, description and quantity. In the second list I use a lookup to find the code and find the quantity. The idea is use the quantity to do some ...
1
vote
0answers
14 views

Use lookup to auto suggest [duplicate]

I have a list containing 200 items (List A) In my new list (List B) I want to include a lookup that will pull through the title from List A. OOTB lookup columns are drop downs and as List A continues ...
0
votes
1answer
32 views

Missing Lookup Column Including Search Form

I was trying to create new lookup column with search form in sharepoint online (365), but the lookup column with search form is missing. i want to ask, how to add lookup column with search form? as ...