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
1
vote
1answer
42 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
30 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
138 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
425 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
2k 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
281 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 ...
1
vote
2answers
612 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
188 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
103 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
142 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
29 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 ...
0
votes
1answer
286 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
283 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
221 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
343 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
37 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
40 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
571 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
105 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
175 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
222 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
41 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
1k 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
142 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
64 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
302 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
150 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
585 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
28 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
402 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
1
vote
2answers
626 views

Expand Multiple Lookup field with Microsoft Graph

How can I Expand a Multiple Lookup field with Microsoft Graph. I need to get all fields from a multiple lookup field. Thanks.
0
votes
1answer
439 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
166 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
669 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
1answer
119 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
301 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
62 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
3k 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
218 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
2answers
89 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
40 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 ...
1
vote
0answers
15 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
59 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 ...
0
votes
1answer
33 views

lookup column to load list(created to use in the lookup column) from current site not from the parent site where the lookup column is created

I have created a Lookup Column called "LookupSiteColumnA" in the parent site , I have created a List "ParentSiteSourceList" in the parent Site to use for Lookup Column , and saved this list as a ...
0
votes
1answer
950 views

Retrieve choice values from lookup field in SharePoint2013

I am trying to retrieve choice values from a lookup field in SharePoint 2013 using REST API. PFB the code: $.ajax({ url: _spPageContextInfo.webAbsoluteUrl+"/_api/web/lists/GetByTitle('Test')/...
0
votes
2answers
40 views

Get data from linked lists

I have two lists which are linked. When I want to add a record to the second (child) list I need to get data from the first list (parent). My parent list "PIR" has the fields PIR, number and source. ...
0
votes
2answers
199 views

How to update a lookup value in a Document Library With DocumentSet

I would like to update my document library but i do not know how to do with one of my field which is a lookup field. Here is my code: #plug-in SP PS Add-PSSnapin Microsoft.SharePoint.PowerShell -...
0
votes
0answers
152 views

jquery to get value from parent list

I have a list that uses a LookupField. I am trying to display the ParentID when I add a new item to this list. Here is my jquery code: <script src="/sites/SWR000744/SiteAssets/Scripts/jquery-3.2.1....
0
votes
1answer
282 views

SharePoint Designer Workflow Field Lookup Not Displaying

I have a SharePoint list called Item Orders. The "Item Name" field is a lookup from a field of the same name on the list Item Definitions. The field "Item Type" from Item Definitions is also displayed ...
0
votes
1answer
174 views

How to create a lookup column with Site Design for modern sites

As per the MS article i have created site design file and uploaded to SharePoint which is working fine. But I want to create a lookup column with the site design approach. I am using below code to ...

1 2
3
4 5
21