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)

2
votes
1answer
23 views

SharePoint List CreateBy column storing date value

we discovered some very strange behavior in a list. within the last couple weeks, the Created By column for all items was replaced by a date: 35;#2014-12-23 23:17:51 I got this using powershell, ...
1
vote
2answers
35 views

Get SharePoint user by email address

Is it possible to get the SharePoint user by email address? I'm writing a SharePoint 2013 workflow and the steps are : call a web service to get user email address look up SharePoint user using ...
2
votes
1answer
30 views

Restricting a lookup field in a list

I'm putting on SharePoint Lunch and Learn training for my company. I'm wanting them to sign up. In one list, I have title and date Lunch and Learn 1, January 15 Lunch and Learn 2, January 22 In ...
1
vote
0answers
30 views

Lookup doesn't work on field that has taxonomy field

Is there any reason why lookup field in one list would stop working when taxonomy field is added to other list that lookup is referenced to? Before adding the taxonomy field lookup was working just ...
2
votes
2answers
43 views

How to get the text, not the ID number, from an external look-up field with InfoPath?

I have an InfoPath form with a drop-down list that needs to be populated with a field from an external SharePoint list. However the field is a Look-up Field and when I get it to populate the drop-down ...
0
votes
0answers
82 views

Set value of lookup field using JSLink

I am trying to use jslink to update the value of a lookup field in a quick edit view. I haven't been able to figure out how to do it. I have done a fairly exhaustive search online, but the closest I ...
3
votes
0answers
31 views

Is it possible to create a lookup column with a list of all lists on the site using a WSDL data source?

I have a list in which I want the user to be able to select the name of 1 or more lists/libraries that exist on the account. I know I can use _vti_bin/lists.asmx?op=GetListCollection to get a list of ...
0
votes
0answers
250 views

Set value in lookup field in workflow?

how can I set only the one value to required lookup field, when I create new item in workflow. I tried use workflow variable, ID but I do something still wrong. So I have one list A wiht values AB, ...
0
votes
0answers
76 views

Lookup to a column in a library having multiple hierarchical folder structure

I have a library A that has multiple folders and documents. I want to create a list B with a lookup column pointing to a column in Library A. The problem I face is that the lookup column fetches ...
0
votes
0answers
18 views

Lookup field getting value instead of text

I have departments list ,I want to use departments list in another list by using visual webpart it works fine but I am getting values instead of text in the list after saving the list item. in ...
0
votes
1answer
85 views

Limit choices in (lookup or choice) field based on user

I have a list with a column 'Customer Code'. This code consists of a 5 digit number. I have another list of active customer codes and authorized users. Each customer code is also set up as it's own ...
0
votes
0answers
34 views

Adding two columns from multiple lookups

Pardon for the confusing nature of this question. I have two different lists, Business Units and Campaigns, which are used to clarify the different aspects of my business. These are fluid and there ...
0
votes
1answer
31 views

Look up additional column in InfoPath 2013

I have a list in SharePoint 2013 called 'Product'. I want to create a purchase form in InfoPath 2013. I have created to look up in infopath for product code from sharepoint list. But I want the unit ...
0
votes
1answer
34 views

Entire Lookup Row to Appear in Dropdown

I hope I can explain this clearly. I am working in SharePoint 2013 and created a custom list that I pulling the data from that list into another list using lookup columns. For example, ID# is one of ...
2
votes
0answers
42 views

Is cross-site lookup possible with a provider-hosted app?

I have following problem. I got two projects, one sharepoint-hosted app and another provider hosted app. Both contain a couple of lists. So far so good. Now I need the data from the sharepoint-hosted ...
0
votes
0answers
21 views

Selecting a lookup filter causes all lookup information to dissapear (Recent SP '13 Upgrade)

I have a list of project documents that I'm using lookup fields to tag information about the document. When I want to look at just one project, eg Varian Implementation," I select that column and ...
3
votes
1answer
100 views

Document Library Lookup Column

I have a sharepoint list of communities. Each community has an owner (people column). I have a sharepoint document library and a view that joins the document to a community. I am not able to ...
1
vote
0answers
42 views

Adding fields to a list's existing lookup column won't add them to list's existing content types

I have created a custom list, in which I am not using any Site Columns or Site Content Types; I started with the OOTB Item content type and added various custom columns to the list using the "Create ...
2
votes
2answers
54 views

Change GUID in lookup column

I have a sandbox solution in SharePoint . I have created number of site columns, Content Types , list definitions and list instances. Everything has individual feature. For Ex: Site column ...
0
votes
1answer
41 views

Lookup to Person Picker field

I'm trying to do a lookup to a person picker field in another list, but SP2013 won't show me that column. Any thoughts on how to bypass that?
0
votes
0answers
27 views

SharePoint 2013 Lookup field and workflow

I have currently the problem that I can not see in a workflow the additional fields from the lookup colum. Although I see my field lookup, but not the additional fields. Why the whole? I have on a ...
0
votes
0answers
16 views

Connect an OOB DisplayForm WebPart to a DVWP on a lookup field

When trying to connect an OOB WebPart to a DVWP and send the value of a lookup field it sends the value like "ID;#Title". The problem is I cannot use this as a filter in the SelectCommand to filter on ...
0
votes
0answers
39 views

List Add Form-Lookup column selection box cutting off options

I have a Sharepoint 2013 list with a multiple select look up column and the form fields for selecting and adding data items to a new or existing list item are cutting off the lookup text. See below: ...
0
votes
2answers
41 views

Lookup Column Question

I am new to SharePoint so please bear with me. My environment is Sharepoint 2103 standard (Planning upgrade to Enterprise soon) on premise with separate SQL server 2014 installation. I've built ...
1
vote
1answer
65 views

Create Lookup + Calculated column

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
0
votes
0answers
60 views

How to update existing list lookup column reference through powershell

How to update existing list lookup column reference through powershell. I wrote the following code to add lookup column. Now I need to update column reference. $myCustomList =$_.Lists["Test A"] ...
1
vote
0answers
30 views

Auto generate sequence column + a look up info column from another list and calculate in Sharepoint 2013

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
0
votes
2answers
107 views

Set LookUp Value using Jquery in Default List Forms

I am trying to set Look Up Drop down using JavaScript/Jquery. I am able to set the value but while saving by default 1st option in drop down is Set. Thanks in Advance...!!!
1
vote
1answer
73 views

Sharepoint 2010 Workflow send email after list item creation

I'm creating a custom workflow for my team in SharePoint 2010. When someone edits a list item and sets a value to "New" then a new item is created a different list. I would like to email the user and ...
0
votes
0answers
27 views

make lookup option only available if status not completed

I'm creating a way to tag documents against projects, so I've created a list for the projects and numerous libraries that access the list as a lookup for tagging purpose. The list also has a status ...
0
votes
0answers
20 views

How to add addition column info to a lookup field's form dropdown

I have a Sharepoint List MyList, that has a Lookup Field to another sharepoint list, MyLookUpList In the dropdown, one of the MyLookUpLIst's field is displayed (say ID or Title) but I want more info ...
0
votes
0answers
30 views

lookup displaying (None)

I have a library with a lookup column, when I add a document a edit form is presented and the lookup is available however the first item in the lookup is (none). If I then try to make this a required ...
1
vote
1answer
119 views

Create a LookUp Column using SPServices “UpdateList” operation

I want to dynamically add a new list ("AddList" operation), and then use the SPServices "UpdateList" operation to add "newFields". I was able to get the "Text" fields to add properly, but the LookUp ...
2
votes
0answers
62 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
3
votes
1answer
197 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
2answers
183 views

caml query for filtered lookup column

My project uses the 2010 version of the Sharepoint Filtered Lookup Field, which has the option to filter a column using a caml query. So I have three lists: Categories, SubCategories and MainList. ...
1
vote
1answer
42 views

Function to run when drop down is clicked

I have a lookup field. I need to filter the values in that drop-down, so I thought of writing function when the drop down control is clicked. Something like. ...
2
votes
0answers
64 views

Recurring Events in Calendar created from a template

Using SharePoint 2013 on-premise, I had a calendar working nicely in my test environment. I then Saved it to a template, moved it to another site collection and created a new calendar. It had lookup ...
2
votes
2answers
163 views

Counting the number of items added in LookUp column

I have a lookup Column in my list which can take multiple values. So I need to count the total number of items added in that lookup field. What is the simplest way to do this?
0
votes
0answers
58 views

Get Lookup Value in SharePoint 2013 List

In Sharepoint 2013, I have 3 lists containing these fields: Part Data: Part Number (a lookup field) Supplier Number Buyer Number Parts : Part Number Supplier Number Suppliers : ...
0
votes
0answers
161 views

How to remove duplicates from a lookup field in SharePoint 2013 online?

I have a lookup field which is created from the same document library and it is a multi selection lookup field. The values in Lookup having duplicate values. Are these duplicate values are showing ...
1
vote
1answer
89 views

How to remove hyperlinks in the Look up field

How do you remove hyperlinks in the Look up field using jQuery in SharePoint?
0
votes
0answers
38 views

Look-Up a Multiple Line of Text Column

I am looking for a solution that allows me to refer a multiple line of text column to another list in the same Site Collection. I find a lot stuff about SharePoint 2010 where it wasn't possible to ...
2
votes
0answers
31 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
1
vote
0answers
46 views

Auto Fill Lookup Column

I believe I am starting off on the right foot by using a lookup column. I am seeking a way for when a user enters in a order number the number auto populates in a choice column. So basically every ...
1
vote
1answer
95 views

Validate text column against [Me]'s Display Name

I have two lists in SharePoint 2013 Trips Drivers Drivers has a column called Active Driver that is a single line of text formatted "Lastname, Firstname". Drivers also has a separate column that ...
0
votes
2answers
59 views

Different Users ID on each sites

I actually have a site we will call "Team" and one we'll call "Direction" And a list "Projects" in each of those sites. I wrote scripts to make save of each sites, looking if there are new entries in ...
1
vote
1answer
25 views

Add column to new document library template

a was trying to found a way to add a new column to List / Document L template!? I want to add a lookuop column to this view, is it possible ?
0
votes
1answer
153 views

Clear multi-value lookup via Jquery SP 2013

I am trying to clear a multi value lookup field using javascript when an item is re-edited. I have tried all the following combinations without success $("input[id^='Test'").removeAttr(); ...
0
votes
3answers
73 views

What is wrong with the lookup in my InfoPath Form?

I have SharePoint Online list which I am customizing with an InfoPath form. Two of the fields on the Form are lookup fields with a secondary Data Connection to a second SharePoint List with Fields ...