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
0
votes
1answer
601 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 ...
1
vote
1answer
858 views

Getting “404 NOT FOUND” when clicking on lookup link

In the past, when clicking on a lookup item on a list, it would show a popup with the data of that lookup item, but now I get a "404 NOT FOUND". I tried creating a new list and adding a lookup from ...
0
votes
1answer
760 views

Sharepoint online lookup field hyperlinks not working

We are using SharePoint Online and we have noticed the hyperlinks on lookup fields in a list are not working. These are the links that appear in the list view when you have a lookup field that points ...
0
votes
1answer
300 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
2answers
473 views

Filter Lookup column based on Current Logged in user

I have a small problem i am facing in CAML queries. Currently i am trying to filter a Lookup column based on Current logged in User in SharePoint Online. Here is my code and i am new to using SP ...
0
votes
1answer
30 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 ...
1
vote
1answer
470 views

Adding to Multi-Value Lookup Column via PowerShell (SP 2013)

Is there any way via PowerShell to add data to a multi-value Lookup column instead of overwriting it? For example, the item already has stuff checked off in the Lookup column. Values 1 and 2 are ...
1
vote
1answer
42 views

Can't add document to lookup field

I have a SharePoint 2016 on-premises site with a custom list. One of the fields in this list is a lookup to my Shared Documents library. All of the documents in this library are contained in sub-...
0
votes
1answer
27 views

Using Lookup field but removing some items

We're creating a sign up list for our fortnightly inductions at work. We've got a list which has all the induction dates, and another list for the signups. The signups list has a lookup field to the ...
1
vote
1answer
342 views

How to embed a search field in a dropdown of a lookup column's cell

Let's say I have a list which is opened in quick edit mode(Datasheet view) have a lookup column when I click on any cell of the column I can see a drop down of items and also that drop down getting ...
-1
votes
1answer
55 views

Rest API combining two lists

I have two lists with look-up columns, Address and Employee. GetID (Address) looks up list Employee. Below is the rest query. But its throwing error (404 Bad req). Can anyone give some insight into ...
0
votes
1answer
25 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 ...
1
vote
1answer
199 views

JSOM - CAML query - Not able to get columns from joint lists

I am trying to get data from 3 lists through Join. However not able to access columns of 2nd and 3rd list which i had fetched in query. Relation between lists is as follows; Test3rdList has Lookup ...
0
votes
2answers
485 views

System.ArgumentException: Column 'ABCIniti' does not exist. It may have been deleted by another user

We are using SP2010 on-premise and InfoPath 2010. Recently we found one of InfoPath library's workflow page got error. After investigate the ULS log, the error is "System.ArgumentException: Column '...
1
vote
2answers
303 views

Lookup field deployed through feature can't be added to new list

I have deployed a number of fields, content types, and list definitions/instances to a site through a couple features. The fields and content types are deployed through a Site scoped feature, and the ...
0
votes
1answer
188 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
2answers
43 views

Human Resources Information System in Sharepoint

Is it possible to create a list from active directory users and make the list editable that syncs back to AD using User Profile service? I also want to add additional columns not in AD to the list. ...
1
vote
2answers
63 views

Show in look up field only values by specific values in look up list

I have two custom lists (Customer, Contracts). Customer list contains: Name, Address, Active (yes/no) Contract list contains: Name, Customer (lookup field), Contract When I add a new contract I ...
0
votes
1answer
201 views

Get emails from a column in an associated list (lookup list)

I'm trying to create a reusable workflow that will send notifications to users about updated items in lists/libraries associated with a master tracking list. I've got something like this: TRACKING ...
2
votes
0answers
196 views

Filtered lookup based on lookup

My situation is this: I'm trying to set up a review site for the publishing house I'm working for. Basically, the editors should be able to pick reviewers for new books based on certain categories. ...
0
votes
2answers
39 views

Choose one or another lookup value in NewForm.aspx

I have two lists, A list looks like this: I want the B list to display those values and in NewForm.aspx I would be able to lookup those values either by the code or by the name. B list: NewForm....
0
votes
1answer
532 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
30 views

Site architecture for a document library linked to an arbitrary number of items in different lists

I am pondering the architecture of a site revolving around a document library of job reports of different services. Each job report will be linked to the various services performed, ID of the service ...
1
vote
1answer
140 views

Creating filtered lookup in SharePoint 2010 with InfoPath 2010

I have a requirement similar to this. https://www.sharepointusecases.com/2010/01/creating-filtered-lookups-in-sharepoint-2010-with-infopath-2010/ In my case Project field should be a text field and ...
1
vote
1answer
576 views

SharePoint 2013 REST - Create List Item with Lookup User Field

How do I create a new list item for a list that has a user lookup field? I have seen other people pass the ID of the user, but that isn't working for me. I get a 400 error when I try that. I have ...
0
votes
1answer
135 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
6k views

Autofill column values of a list based on another list column value

I am an newbie to JS, SP Services and JQuery. I am on SharePoint Online environment. I have a List A with columns Title (Text Field), Location (Choice field) and Event Date (Date field). I have a ...
1
vote
0answers
187 views

Can you use a lookup column to filter results in a content search webpart?

I am working on a site in Sharepoint 2013 and I have created a content search webpart in a page layout used for multiple pages. I want to be able to display items from a list that are associated with ...
0
votes
1answer
201 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
152 views

Get last item linked via lookup field

Imagine I've got List A with a field Name And List B with fields Date & Name (lookup from List A) There are multiple items in List B linked to each item in List A. I need to get the Date of the ...
1
vote
0answers
88 views

set value in Sharepoint cascading dopdowns 2013

I have a newform that sets values on selection of a dropdown value in other fields on form. eg. I select a value in ID dropwdown and all the field values related to that selection are prefilled in ...
1
vote
1answer
47 views

SharePoint calculate value

Quick question - I have 2 lists: ListA and ListB On ListA user can create multiple entries with their absence plan. Their choice is saved to field XXX as number. ListB contains value with granted days ...
0
votes
1answer
27 views

Customize Excel Online app formula with a choice list where data are read in a List app

I have an ExcelSheet application. I want to restrict the input of a column depending on another application "Custom List". This in what I want to do: see link. Should I switch my app from Excel ...
0
votes
1answer
285 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 ...
1
vote
1answer
370 views

How to set the values of cascading lookup columns using javascript

I have two lookup fields that are cascaded with each other like: 1. Function and 2.category. First I select Function based on that Category field gets value. But I have to set value in these two ...
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
2answers
246 views

SharePoint 2013: Custom Display Form - “Unable to display this Web Part” when

My Questions Question 1: Has anyone seen Error below when working with 20+ lookup fields in custom Display form? Question 2: Can it be fixed/ worked around/ hacked/ etc...? Error: Unable to display ...
2
votes
0answers
113 views

Link to related documents in another list

I have two sharepoint lists. List 1 has a list of projects and includes a geolocation column. This allows me to view the projects on a map. List 2 is a document library where up to 3 documents are ...
0
votes
3answers
1k views

How to delete Lookup columns

I have a list with more columns in SharePoint Online 2010. When I am making the extraction to Access or Excel, I have some columns which do not appear in my list of columns I created. I can see them ...
0
votes
1answer
361 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
617 views

Unable to update single or multiple lookup values with rest api

I have a list name "Parts", This list has a lookupfield called Parts and it look into the Parts list. Aka 1 part can contain other parts. Hope you get the Idea When I'm trying to update the ...
1
vote
5answers
2k views

Automatically populating a list column with department of user filling in the list

I have a list that needs to contain the department of the user filling in the list item. How do I automatically fill in the department for the current user filling in the list item? Is this even ...
0
votes
1answer
50 views

FieldLookupValue[] next assignment always replacing all previous positions - SharePoint Online

I have a ; separated string BusinessCategories. These values should be found as List Items in a custom list BusinessCategoryList, and I want to create a link to them in a multi value lookup field and ...
0
votes
1answer
110 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
85 views

Disable 1 time firing double click event from Multiple Choice Lookup column using jQuery/javascript

I have a multiple choice column of potential attendees that are to be enrolled in a course. After the number of available spots is filled, I disable the column along with the "Add" button, yet one ...
1
vote
0answers
74 views

how i can create a site column of type lookup with empty source list (Get information from), and modify the “Get information from” at list level

I am working on an on-premise sharepoint server 2013 farm. i have the following:- 1) i have a team site collection which contain 5 sub-sites. 2) under each sub-site i have a custom list named "...
0
votes
1answer
277 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
185 views

Sort lookup column to show Active = Yes category on top in on edit form

We are on SharePoint 2016 on premise. We have one document library in which we have added look up column (Category) of existing list(Allow multiple selection). We We want to sort by Active column (yes/...
0
votes
1answer
32 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
56 views

Filtered Lookup on Created By

I have two lists. First one is a Projects List and Second List has a lookup column to the First list. I want the lookup column on Second list to show only the Projects filtered by the column "Created ...

1 2 3
4
5
21