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)

1
vote
1answer
2k views

SharePoint 2013 - Remove the hyperlink from a lookup column in a list view

I've searched the web and found a solution.... IF I WAS USING 2010 or 2007. I have cascading selections referencing two different lists that hold the dependencies as lookup columns. My cascading ...
0
votes
0answers
39 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 ...
7
votes
5answers
8k views

How to display lookup additional field in display form?

I have two lists: Projects and Tasks In the Tasks list, I have created a lookup field titled ProjectID which targets ID filed from the Projects list. Also, I have set for this field to display an ...
0
votes
1answer
28 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
18 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
1answer
783 views

Export and Import the lookup relationship data in SharePoint 2013

In SharePoint 2013 having a blog site with Posts and Comments list, these 2 lists having the lookup relation ship, I export and import from one site to another site but in comments list PostTitle ...
3
votes
1answer
214 views

How to have a calculate column that compares the difference between the current item and the previously submitted item?

I have a list with the columns Room Number, Temperature, and a column Temperature Change. What I would like, is for Temperature Change to be a calculated like so: When the user fills out a new ...
0
votes
0answers
25 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
20 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
2answers
9k views

Coercion Failed: Can't get workflow to send notification to “Assigned To” user

I've created a simple workflow to send a notification email to the "Created By" user which works nicely. What I wanted to do is use the "Assigned To" built-in lookup instead, which is a "People ...
0
votes
1answer
30 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 ...
2
votes
2answers
2k views

Help with SPCascadeDropdowns cascading lookup column

I have this jquery added to my editform.aspx in SharePoint. I want the childcolumn to also have unique values, although it may contain duplicates example below. Example. When I select mycountry, I ...
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 ...
9
votes
6answers
18k views

Why is my column not shown under “Add a column to show each of these additional fields”?

In SP2010, I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
1
vote
2answers
38 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
54 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
48 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
62 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
183 views

SPD 2010 workflow, update (add and delete) lookup column

I have a list (with a custom InfoPath form) in which I have items that have a Parent / Child relationship with two lookup column to the title column of same list. The two lookups are "Child of" single ...
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 ...
1
vote
1answer
48 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
10 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
42 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
58 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
26 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 ...
1
vote
1answer
29 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
18 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
24 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 ...
8
votes
4answers
46k views

How to set ListItem Lookup Field value

How do I set a ListItem's Lookup field using code? SPFile file = list.RootFolder.Files.Add(destUrl, iStream, true); SPListItem item = file.Item; item["DocumentID"] = DocID.ToString(); ...
0
votes
1answer
32 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 ...
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
votes
1answer
46 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
73 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.
1
vote
3answers
2k views

Change the source on a lookup column?

Is it possible to change the data source on a lookup column? I have the source set to list A but I want to change it to List B.
0
votes
0answers
46 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 ...
1
vote
1answer
41 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 ...
0
votes
1answer
35 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 ...
2
votes
1answer
87 views

SharePoint 2013 and O365: Lookup column Value ID missing

Okay, this is my first question so forgive me if this is long winded. TLDR: I cannot seem to be able to target or get the Value ID of the Category Column in a blog post rollup. Why is this? ...
3
votes
2answers
3k views

lookup column in calculated column formula

I have a Lookup column(Discountfirst) which has Number. I also have another Calculated column(Finaldate) with Resulttype DateTime. One more column(DateofReceipt) in Date. My Calculated column formula ...
2
votes
1answer
60 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
28 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 ...
2
votes
2answers
6k views

Workflow condition using a lookup column

I am sure this is something quite simple but I can't seem to figure this out (I am new to SPD and workflows in general). I am building a workflow to notify key individuals of a new item(s) being ...
0
votes
0answers
28 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 ...
1
vote
1answer
60 views

CAML query with OR returns no result, where single part of it returns results

I have a CAML query which queries 2 multi taxonomy (managed metadata) fields. I use the IN operator for this. The query should return items where in one of the fields a match was found, so either in ...
3
votes
2answers
11k views

Add additional field to lookup field inside schema.xml

I'm following the steps in this article to setup a joined data view webpart joined on a lookup field: ...
1
vote
1answer
45 views

Need CAML query LookupMulti column help, Is it possible?

I am trying to create a CAML query for querying list, here is my problem. There is a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
1
vote
2answers
2k views

Default null value to a required Lookup Column

The title pretty well speaks for what I need. I have a lookup column on a list, getting data from a custom existing site column i created. I need it be null by default so they get an error if they ...
0
votes
0answers
17 views

Refreshing a lookup field in modal edit form via client side javascript

I have a list (list "Project") that on edit of a item opens a modal dialog for editing (editProject.aspx) The Project item has a lookup field "Document links" which points to a custom sharepoint list ...
0
votes
0answers
16 views

Sharepoint 2010 connect webparts using multilookup fields

I have one question. I have two generic SharePoint lists on my site. First list have lookup field that allows multiple values. Also I have web part page with two list view web parts from these lists. ...