A lookup column is a SharePoint list column that retrieves its available values from another column within another list in the SharePoint site.

learn more… | top users | synonyms (1)

0
votes
0answers
30 views

vLookup function in Sharepoint WebApp

This is very straight forward with a vLookup in Excel, but not sure how to do it on Access Sharepoint WebApp. I have a Customer_List table containing 'Customer_Account_Code', 'Customer_Name', '...
0
votes
1answer
50 views

Can a workflow populate values in a lookup field for all the items in the list?

I have a list called Contacts, with 4000+ entries. It currently has a dropdown choice column with four specified values for different offices (MAO, NHO, MEO and CTO). I want to convert this dropdown ...
0
votes
0answers
15 views

limit a lookup input field on a document upload form (SP2013)

I've created a project site with a tasklist and put a document library on it. The task list WebPart is filtered to show only My tasks Every added document requires a task list a title to be entered (...
0
votes
1answer
42 views

Create lookup column using AssignedTo column from Task List to Document Library

I made a task list, and some tasks are assigned to multiple people. A document webpart gets a filter view, of a selected task in the task list. When i add a new document to the document library, I'm ...
0
votes
2answers
31 views

Anonymous Access Users cannot see lookup values between lists and libraries

I have a document library which uses lookup fields from other lists in the properties of the of the document. I then use the lookup field to group the documents. For authenticated users, the list of ...
0
votes
1answer
18 views

SPListItem access to lookup column not work

I have one list definition like this: <ContentType ID="0x01..." Name="CNT_List" Group="List Content" Inherits="TRUE" Version="0"> <FieldRefs> <FieldRef ID="{guid}" Name="...
0
votes
0answers
11 views

Create a list column of Project Web Access project names

I'm trying to make a site column in Project Web Access which contains a list of the projects managed within that instance of PWA. There's a few types of data in the PWA that look like they should ...
0
votes
1answer
30 views

How to make Person/Group and Look-up column values non-clickable in SharePoint 2013 list views

I'm using SharePoint 2013 Enterprise. For a SharePoint 2013 XSL List View Web Part, I need for the person/group column value, as well as look-up column value to be non-clickable. I have seen multiple ...
0
votes
2answers
40 views

Lookup list with dependencies/permissions

Below is a drawing of a scenarium I want to create in SP2013. My question is wether this is possible OTTB, or possible at all. The main concern is, how possible is it to make drop-down depend on each ...
0
votes
0answers
29 views

lookup with criteria

I have three lists in Sharepoint: Customer Product Lizens A Customer has a unique Name and a Adress. A Product has a unique Name belongs to a specific Customer(can also be unasigned). A Lizens ...
0
votes
0answers
13 views

create custom field linking to library contents

Trying to create a change request list requiring the viewer to specify the artifact to change, based on the filenames in the artifact library (same sharepoint). The displayed control to select could ...
1
vote
1answer
89 views

Drop down list lookup field SharePoint Designer 2013

I would like to create a list with inventory on it. This would be just numbers like A1 through A24 (List A). Is there a way to create a lookup field in another list (B) with a column that shows those ...
0
votes
0answers
25 views

How do I get the linked to title field in a rest call?

How do I get the linked to title field in a rest call? Also, will there be an additional step if this field is on another list? I've already expanded and included the specific field in my current ...
2
votes
3answers
35 views

List Lookup Column - Select Library

I would like to add a lookup column in a SP list, which allows the user to select a specific library (rather than an item within that library). Is this possible? Many thanks
1
vote
0answers
27 views

SharePoint Designer Workflow create new item with lookup to current item

I have two lists, "customers" and "expense Sheets". The list "expense sheets" has a lookup column "related customer" to the "title" field of the "customer" list. I am trying to create a workflow for ...
0
votes
1answer
47 views

SharePoint 2013 Unexpected Error while creating lookup column to use external list

I am using SharePoint Server 2013. In that I am creating a custom column which lookup to an external list. My ECT is based on an SQL Server table and I have created the external list in the site. I ...
0
votes
1answer
48 views

Adding a many to many relationship, and having a form input data into two lists

I'm building a form for a Marketing Event list. The list would track name/type/location/date etc of the event and also those people associated with it (for example recipients or attendees) These ...
2
votes
0answers
34 views

Filtering Lookup Column By Expiration Date [duplicate]

Scenario: I have created a lookup column with two columns. A department column and Expiration Date column. Each Department has a Expiration Date. For example see the image. When the Department ...
0
votes
0answers
22 views

Pulling in a task field in lookup for string

Here's my scenario 1. I have a task which is asking a user to add details in a task field called 'Additional Details' 2. Once user fills in and submits the task, another task is created with approval ...
0
votes
0answers
61 views

Lookup field on 1 list doesn't update when the text field in another list changes value

I have a target list with Employee Status: Pre Hire by default. Once items are completed that changes to Active Employee. I have a field in list #2 with Employee Status as a lookup field pointing to ...
0
votes
0answers
8 views

Cross Site Collection Boundary for SPFieldLookup

I am looking for a solution similar to this post, Cross-site and SPFieldLookup, but I need to cross a site collection boundary. Is this possible with modifications to the powershell on the posted ...
0
votes
1answer
48 views

The lookup that you defined is not guaranteed to return single value

Error: The lookup that you defined is not guaranteed to return single value. If more than value is returned only the firs value will be used How to return multiple values from a lookup column?
0
votes
0answers
19 views

What is the best way to Manage meeting attendees in custom list?

I am trying to manage a custom list for a large meeting in SharePoint 2013 . I already have a contact list with all information, this will be my basic invitation list. The person who call for ...
0
votes
0answers
26 views

Auto populate a multiline column based on a lookup one

I am an absolutely beginner. I am creating a IT support ticketing system based on Sharepoint online. I do not have access to "InfoPath" or "SharePoint Designer". I have added the "Incidents" vanila ...
0
votes
0answers
24 views

Link on lookup field go to filtered list

I currently have a List A with a lookup column called "Category" that is using a list of categories in List B. The column is currently hyperlinked and when clicked it shows the item from List B. Is ...
0
votes
0answers
21 views

Sorting dropdown of a lookup to another column

I have a column that looks up it's values from another column (Single Line of Text). The users would like the order of the lookup dropdown reversed (currently displaying as 1,2,3 they want it as 3,2,1)...
0
votes
1answer
36 views

Creating an interactive form with a custom list with lookup fields

I have a list that we are using to order new computers for staff members. They fill out all their information, like name department and cost centre. Then I want them to select from a list of ...
1
vote
2answers
42 views

Filter items based on lookup

I have an SP list with 6000 items.It contains 10 lookup columns. I want to filter,retrieve and display a set of items in a page based on these lookup value. I tried using REST API & CSOM but I am ...
0
votes
1answer
57 views

SharePoint 2013 Workflow with many variables

I got stuck with the problem of lookup workflow. I need to fill the SharePoint list based on the 2 variables introduced earlier to another list. After some searching lookup workflow seems to be the ...
0
votes
1answer
52 views

Updating a lookup type field

I have 2 lookup fields on a form. I have the following code and it's populating the 2 lookup fields. However, when I click on save button it complaints about field is required but I see both are ...
2
votes
3answers
83 views

How to change the output of a Multi-value Lookup column in a View?

Could I edit the way the Lookup column displays information, if possible without code? (Or an easy explanation as to how to do it?). Currently it is displaying as "Name; Name; Name; Name". I would ...
1
vote
0answers
17 views

Using a lookup column to filter library web part

I want my users to select ID's in a list - those ID's have been contacted that day. The problem is: for future reference, the managers want to go back to that day and easily access all library items ...
3
votes
2answers
103 views

Get lookup from REST API

REST API url is /sites/MySite/_api/web/lists/getbytitle('MyList')/items?&$top=100 I have a lookup column called Sector in the list. How to retrieve this lookup value from the success call of ...
0
votes
0answers
11 views

Infopath: multiselect and Sharepoint multiselect

I have built a form in sharepoint in which the users are using to filling information, let's call this formA. Within FormA, I have the following fields: Form Name (single line text) List items (...
0
votes
1answer
51 views

Create an order purchase in SharePoint

I'm a newbie in SharePoint and I need advice. I would like to use SharePoint 2013 to manage order purchases assuming that each order can have multiple products related. Due to SharePoint do not ...
2
votes
1answer
91 views

How to get parentlist of a lookup column in CSOM

What I want is this using (Web web = lookup.ParentList.ParentWeb.Site.OpenWeb(lookup.LookupWebId)) { List list = lookup.r.LookupWebId.LookupList; Field ...
0
votes
1answer
29 views

three lists, two parents one child lookup relation

I have three lists, parentListA, parentListB, childList Example of parent A: parentListA = { ID: 1, Title: 'a parent', Description: 'lorem ipsum' } Then I created the child list, so ...
0
votes
0answers
21 views

Assigning a List Item's default lookup value based on the most recently modified item in the same list (SharePoint 2013)

Is there a way to assign the default value of a Lookup Column in a New Item as the value of the most recently modified item's Lookup Column in the same list? In my 'Articles' List, I have 3 Columns: ...
1
vote
1answer
27 views

Need help in adding new lookup column in SharePoint List

I have a list for Person in which there is a lookup column for StateID of States list. In States list there is a lookup column for CountryID of Countries. I want to add CountryID to Person list by ...
0
votes
1answer
35 views

Lookup column data from another database

I've explored lookup columns, managed meta column, and external datatypes, and I'm either not understanding them, or I haven't found what I'm looking to do, so I'm hoping I can describe my goal and ...
-1
votes
1answer
72 views

Is it possible to lookup people picker type field [duplicate]

Is it possible to lookup a people picker type field from a list. I have tried OOTB as well. But I couldn't do it through OOTB even. I need something like as following: Here "Person" is a people picker ...
0
votes
2answers
115 views

How to set multiple values in sharepoint lookup field using c# [duplicate]

I want to set the multiple values in lookup column. my string format is id#;id#;id#; but it is giving error.
0
votes
0answers
37 views

In SharePoint lists - how add a field that gets data from a database connection?

Background: We have SharePoint lists that contain user requests for compilation of software, various regression testing, and other tasks. They automatically cause start of these tasks. I need to add ...
1
vote
1answer
31 views

Can Lookup Column be displayed?

I use Cross-site publishing in SP13, create a authoring site and a intranet(display site.) I have created a list of content including a lookup column for contact person; look up from another Contact ...
0
votes
0answers
53 views

Lookup field is empty in workflow - ItemAdded

I want to view parent task ID in Task List. But it is hidden. So I created new field, that is not hidden. This works in View - When I use Why? What am I making wrong? Here is my definition of ...
0
votes
1answer
48 views

Lookup column restriction

For a school project we are setting up a SharePoint for a non profit organisation who handle clients. we have made a document library where we store documents sets for every client thats added. In a ...
1
vote
1answer
43 views

How can I create a [Me] filtered view using a Lookup column with names in it?

Any help will be hugely appreciated as really struggling with this. I am limited by company regulation saying I can't use code so any answer will need to be code free and not require the use of Design ...
2
votes
1answer
71 views

If [LookUp] equals [String] doesn't always work. Sometimes I have to use [1;#String] instead, why?

I am using SharePoint Designer 2010. I created a workflow in which I needed to test the value of a lookup column. I (perhaps naively) simply tested if the lookup column equals the literal string I ...
2
votes
1answer
31 views

Library upload form Dropdown options order

I have a library to store files (obvious) with column "City" which is a lookup to list with two columns (CityName & Order). How to change ordering of options in dropdown field (which is in ...
0
votes
0answers
33 views

How do I create a workflow to input a date from one list to another on item create or edit?

I am new to SP workflows and cannot work out how to create a workflow for the below. Can anyone help? I have 2 lists, list A and list B. In list A, I have a unique identifier (UID) field and a number ...