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
2answers
7k views

How to return field from specific workflow task as Data source in Lookup tool?

In short . . . How do I do this: ? In Step 1 of my workflow, the first action is to create/assign a task with Task ID of TaskID1. For the next action, how do I assign a field the value of a ...
2
votes
0answers
70 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 ...
0
votes
0answers
192 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
33 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
1k 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
99 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 ...
1
vote
2answers
1k views

Is it possible to iterate all lists in Sharepoint in search for a given Field?

Is it possible to itterate all Lists in SharePoint to find out which ones use a custom Lookup field? I have an application which is currently failing because the custom Lookup field was pointing to a ...
0
votes
0answers
19 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
192 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
1answer
40 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
0answers
36 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
36 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
43 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 ...
2
votes
2answers
63 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 ...
3
votes
1answer
124 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
70 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 ...
0
votes
1answer
54 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
35 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
48 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
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
2answers
43 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
73 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 ...
6
votes
3answers
2k views

SharePoint 2010 Lookup Column Display issue

I have a simple list with three lookup columns in it. One LC has 5 items and displays as simple dropdown and there are no rendering issues (So ignore this column now). The other two columns has more ...
0
votes
0answers
98 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
31 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
214 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
84 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
33 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 ...
3
votes
4answers
2k views

How to create web-related lookup field to 'pages' list?

I have SharePoint site collection 'http://microsoft.com/' with few child webs ex: http://microsoft.com/news/ I want to create lookup field to 'Pages' list. On each child web lookup field should ...
1
vote
1answer
242 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
93 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 ...
0
votes
2answers
281 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
2answers
117 views

Filter Lookup from another lookup

I have a list of projects. Inside the project list you can select a Client. I have a list of Clients. I have another list, a list of Contacts, they have a lookup column called Client to specify from ...
1
vote
1answer
44 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. $("select[title='Subsystem']").click(...
0
votes
0answers
61 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
206 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 ...
0
votes
2answers
92 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
114 views

How to remove hyperlinks in the Look up field

How do you remove hyperlinks in the Look up field using jQuery in SharePoint?
2
votes
0answers
34 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 ...
0
votes
0answers
42 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
2answers
4k views

How to Find Lookup field list using Programmatically

How to find the list that a particular lookup column in a list is bound to, programatically?
1
vote
0answers
47 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 ...
0
votes
1answer
202 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(); $("input[...
0
votes
3answers
85 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 ...
1
vote
1answer
161 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 ...
1
vote
1answer
27 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
192 views

Lookup on same list

Are there a way OOTB if i have a lookup on my own custom list. If i select an other item. The other item is automatically linked. For example. I have list "test" with a lookup on "test" (so same ...