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.

1
vote
1answer
82 views

Searching between two separate lists for matches

I have two SharePoint Lists each with a column called Unique Key, what I need to do is search list B for matches in List A. List B is the larger of the two and each List contains only unique entries ...
1
vote
1answer
128 views

Update list item once library item is created

We have a list that is used to notify people that they need to create an item in a library. We want to update a field in the list once the item in the library is created. We tried to use the method ...
1
vote
1answer
366 views

Lookup Column - SharePoint 2010

Is there any way to link parent site and sub sites? Problem: I have one list on Parent site and I have a few other lists on sub sites. I am trying to create lookup columns in the parent site list to ...
1
vote
1answer
1k views

SP 2013 REST API retrieve values from lookup library

I have a custom list 'MyList', containing a (single value) lookup field 'MyLookupField', which points to a library 'MyLibrary'. I now want to retrieve all items from 'MyList', including the Link to ...
1
vote
1answer
428 views

Include additional fields with Person Site Column

When I create a column of type Lookup, there is a section at the bottom labeled "Add a column to show each of these additional fields:" I want to do this same thing with a Person column. It seems ...
1
vote
1answer
441 views

Filter a parent list by a particular child list item's lookup field value

I have two lists, Activities and Objectives. The Activities list has a multi-value lookup field that references the Objectives list. I am trying to create a filtered view on the Objectives list that, ...
1
vote
1answer
216 views

Displaying text in a Look-up column

Apologies for not being clear. I'm try to display a "multiple lines of text" column as a look-up field in a new view of the parent list. I have tried SP Designer and most of the standard webparts. ...
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
265 views

Document library forces check-in upon adding custom lookup column

SharePoint 2007 Team Site Add a Document Library with the Word 2003 template Add a new item, save, close document, no problems Add a (required) custom lookup field to the document library Add a new ...
1
vote
1answer
393 views

I need to have the data from a list in another site at the same level to be available as a lookup in sharepoint 2010

I have a parent team site (Services) that contains multiple sub sites. One of the sub Teamsites is Call Inventory Containing our Stock List. Another Teamsite is called Purchasing containing a purchase ...
0
votes
1answer
78 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
15 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
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, ...
0
votes
1answer
87 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
1answer
39 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 ...
0
votes
1answer
51 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
36 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
1answer
44 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 ...
0
votes
1answer
106 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 ...
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
224 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
77 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
1answer
41 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
137 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 ...
0
votes
1answer
426 views

SharePoint 2013 How to update a lookup column in different lists?

SharePoint 2013 updating a lookup column from another list not working Lists: IP Range: Includes a title column (single line of text) for ip ranges (ex. 10.1.1.x) IP List: Includes columns for ip ...
0
votes
1answer
156 views

Choosing between Choice, Lookup & Managed metadata to add keywords to our documents inside document libraries

I am working on SharePoint Online team site collection. And we have many document libraries that we want end users to be able to add keywords inside them. Now I want the approach to have the following ...
0
votes
1answer
28 views

Employee Based Projects

I have a small problem that i am facing currently in SharePoint Online. I have two list Employees & Projects and i have created cascading dropdown. When the employee selects its name from ...
0
votes
1answer
21 views

Lookup to list with identical values

I have a list that contains usage information for tooling. Each time a tool is used, a new line item in the list in entered. This results in the "Tool ID" column being the same (tool ID number), but ...
0
votes
1answer
123 views

Expand and filter nested lookup fields

Lets suppose this structure below: Is there any way to select children whom have root/Id eq 1 with REST API?
0
votes
1answer
344 views

Create a custom list from a template that includes lookup columns

I have a custom list that contains a number of lookup columns (looking up in 2 other lists). I would like to create copies of this list in subsites (with a subset of the data in the parent site's ...
0
votes
1answer
97 views

options for enhanced lookup column in “new experience” SharePoint Online

I have a site in SharePoint online which is using a lookup column to a large list (like 25k) of items. I'm getting the list view threshold error when trying to add metadata with that lookup column. ...
0
votes
1answer
153 views

Getting LookupField with SharePoint Online Management Shell

I am trying to get the user Email through a LookUpField. When I try to "Write-Host the Email", the screen is blank. There is no errors and nothing. What is wrong with my code? Any help is much ...
0
votes
1answer
259 views

SharePoint Online - filter lookup text field on new item form to current user

I have 2 lists: Traveler: Employee - Text (Ex:'Smith, John') Profile link - Url Travel Authorization Request: Traveling Employee - Lookup "Traverler:Employee" I need to apply a filter to the ...
0
votes
1answer
271 views

How to auto-fill fields on new form based on a lookup column of same list?

I have a lookup column that lists the issue ids of the same list. Based on its selection, I need to pre-fill the fields on new form with the values of previously created issues (like issue category, ...
0
votes
1answer
69 views

Lookup links not opening associated record from List form in Sharepoint 2016

I have set up a list that has a lookup field on Documents. This works nicely except for one thing. If I open a record (by double clicking on the record), a panel pops out showing a form populated ...
0
votes
1answer
202 views

Lookup Column Keeps Returning as Undefined

I am getting a TypeError that I cannot figure out for the life of me. I am unable to debug as my company forces IE11, and I do not understand its interface [I use Chrome, which I don't have access to]...
0
votes
1answer
29 views

Manipulate a value in a webpart and use it somewhere else

I hope you can help. We have two lists : countries and customers Countries fields : Country Name + Language Customers fields : Customer Name + Country Name In the dispform of customer, I need to ...
0
votes
1answer
34 views

Where does the Discussion Board 'Posted By' data come from?

We have an email that is sent out when there is a new post to the discussion board via SharePoint Designer workflow. In the email, it shows the user who posted the message or reply using 'Current Item:...
0
votes
1answer
37 views

How can i add linked data source to website?

I got two lists. And I want to join , merge them and select the same IDs.But i don't want to do this on Sharepoint Designer. I only use browser.
0
votes
1answer
49 views

Is it possible to get 13+ lookup field values in an All Items query via CSOM?

I know I could split the queries into 2 or 3 and combine them if I only specify 4-5 lookup fields I want to retrieve each time.. But is it possible to get all of the lookup IDs with CSOM in one CAML ...
0
votes
1answer
390 views

Discussion Board link with List Item - File not found

I have created a List A and a Discussion Board B. In order to link discussion in B with the item in A, I created a lookup column which get the value ID from item in A. This works pretty well when I ...
0
votes
1answer
177 views

Adding value to Lookup columns fails using CSOM in SharePoint 2010

Using the below code, I am able to update the Publications column but not the Authors column as it returns Invalid data has been used to update the list item. The field you are trying to update ...
0
votes
1answer
32 views

Error in sending mail to more than one user through multi valued column

I had a Organizer list with 2 main columns as event and email. Another list is Problem list which has a lookup column with look up field as event. So, a person poses problem and link all events he ...
0
votes
1answer
678 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
101 views

How to set the “title” in a lookup field

if you have a lookup field, its Html source is depicted as: <option value="79" title="G0058">G0058</option> I could use jquery to change the title from G0058 to company1 (field name: ...
0
votes
1answer
71 views

How Can You Show Columns Associated with Lookup On Select?

I've got a lookup column that is pulling another field with it. I am trying to show the other field on a New form when a selection is made from the lookup dropdown. The user needs to use use this ...
0
votes
1answer
243 views

SP2013 Add additional columns to a lookup field using REST

I'm trying to create a couple of lists automatically using REST. List A: TextField: ID TextField: Name List B: LookupField: ID (Get from list A) LookupField: ID:Name (Additional read-only column) ...
0
votes
1answer
123 views

Display Associated Lookup Field on Newform.aspx immediately after selection

Here is my scenario: I have List A called Case Info. In it, I am assigning a Case ID based on the YY-XXXX format (so 17-0001 is the first for 2017). In this list I define what firm the case is ...
0
votes
1answer
68 views

Trying to create a lookup field but unable to find the source field

I created 2 lists (A and B). A Field1 field2 Field3 B Field4 Field5 Field6 On A I have a lookup field Field2 which is based on the Field4 of B. It works fine. I would like to make a lookup in ...
0
votes
1answer
201 views

SharePoint 2010 - Use workflow to add multiple entries in a look-up field

So setting the environment first. List A - Item Request Field 1 - Request Item Name (Single Line Text) Field 2 - Current Requirements (Lookup field from List B with multiple selections allowed) List ...