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

learn more… | top users | synonyms (1)

0
votes
1answer
37 views

Add dynamic link to InfoPath multi-selection field

I had to modify a form using InfoPath in order to achieve a feature that populates a multiple-selection field with data returned from a query (similar to what this tutorial outlines). Before making ...
0
votes
0answers
17 views

I need to pull the version data from 6 Libraries into a single list

I have an existing SharePoint2010 list. It contains information about document approvals (all manual data). I need to compare the manually approved version number to the current actual document ...
0
votes
1answer
62 views

Lookup items says “Count Related”

I am not very skilled with SharePoint, but I have been tasked with using it on a daily basis, and am always at least "trying" to make improvements to it. The issue I am having today is that I have 2 ...
1
vote
2answers
1k views

Cascading Dropdown for Lookup with more than 20 items

I have implemented cascading dropdown using SPCascadingDropdown (SPServices) it was working for lookup with 19 items . When the items count became more than 20 , the lookup column is displayed as ...
1
vote
2answers
191 views

SharePoint Best practice for multiple images per list item

I have to create a simple Classifieds system in SharePoint. One classified item can have multiple images. Does anyone have suggestions on design for this initiative? For example, should I have a ...
0
votes
1answer
53 views

Is it possible to create an automatic connection between the look up field and another column?

Im struggling with a problem in SharePoint 2013. I have one list with procedure codes, which includes the “procedure code” plus some other fields In another table, i have volume data related to ...
1
vote
2answers
181 views

Save Document library lookup field using Rest API

How can I save document library lookup field using REST API Post in a SharePoint list? I tried like 'docItem':'1;#test' But, it is throwing an error : {"error":{"code":"-1, ...
0
votes
0answers
39 views

Weird lookup column issue

I have process that I setup to summarize a list in a lookup column in another list and to automatically generate emails based on the lookup column. I noticed that things weren't behaving quite as ...
0
votes
1answer
305 views

Using additional fields from Lookup in Word Document Information Panel

I have a Document Library in which I have a lookup columns to a Contact list, the contact list also includes linked values as email, phone numbers and so on. When creating a new word document in ...
0
votes
0answers
147 views

How to create a filtered list on Lookup columns

I have created a couple of custom lists, one called Partners, the other named Countries. The Countries list is populated with a list of the world's countries. The Partners list is a list of our ...
1
vote
1answer
65 views

Client API lookup field: LookupId has a value but LookupValue is null

I'm doing something very similar to this question; trying to get the value of a lookup field using the Sharepoint .NET client API. I can get the Id, but not the value. For some reason, the value is ...
1
vote
2answers
446 views

add a new value to a lookup field

I have a custom list in SharePoint 2013. This list contains text and lookup fields. While I do not have an issue populating the text fields, the lookups are giving me trouble. I found and tried ...
7
votes
3answers
213 views

Working around the “Lookup column threshhold”

To level-set, I'm working in a large enterprise with no Farm Admin access or access to SP Designer. I have out-of-the-box capabilities only as owner of a team site. I'm building a roster/schedule ...
2
votes
3answers
791 views

Binding lookup fields to document library template

I have features that define site content types and a document library template that uses these content types. Now, when I create a document library from the template, all the content types appear ...
0
votes
2answers
4k views

How can I combine multiple Lists into one view for editing

I had a list with 18 lookups which exceeded the SharePoint 2010 threshold. So I broke it up into 3 lists all having the same "ProjectID" column as a lookup to the first column so that there is only ...
2
votes
2answers
2k views

Is it possible to have a lookup field with multiple source lists?

I have two lists: list A and list B. List A should have a new multiple choice lookup column that allows the user to choose items from both list A and list B. Is this even possible? I have a kind of ...
2
votes
1answer
113 views

Filtered lookup column with 'WHERE' clause

I have 2 lists: List 1 and List 2. List 1 has 2 columns 'supplier' and 'broker'. List 2 has 2 columns 'nature' and 'supplier name'. My requirement is 'supplier' is a lookup from 'supplier name' ...
2
votes
2answers
873 views

SP 2013 - Updating a multi-value lookup field via the REST API

When adding a new item to list via the Sharepoint 2013 REST API I want to populate one of its multi-value lookup columns. I've tried passing in an array of Ids or a string with separators but nothing ...
0
votes
1answer
60 views

Calculated Lookup from another Lookup

I'm sure this has probably come up before but I'm getting nowhere fast so I thought I'd ask the question! I have a list called Areas, which has an Area column (text). I have a second list called ...
1
vote
1answer
219 views

During ItemAdding of parent list, assign lookup field of a child list

I'm attempting to create a projects/tasks lists. When a user creates "ProjectA", I want to create a list of tasks based on the template that was selected for that project. In general, everything is ...
1
vote
1answer
73 views

Example of a workflow pulling lookup column data for use in a calculated value column

I'm looking for an example of a workflow using SharePoint Designer 2010 that pulls information from a lookup list or via a lookup column and places it within a hidden field for use in a calculated ...
3
votes
1answer
994 views

Help with getting the value of a look up field

Currently, I am using an ajax request to access the list items. The fields that are not lookups come as expected but the lookup fields come across as an ID of the object that corresponds to its ...
2
votes
0answers
86 views

Sorting a Lookup Column from Survey that pulls from Calculated Field SP 2010

I'm looking for a way to sort a Lookup question in a survey that pulls from a calculated field. Specifically, I have it lookup a calculated field that combines the date and name from a list. I want ...
2
votes
3answers
2k views

Can a SharePoint 2010 lookup column point to a multi-line rich text field from same list

Can a SharePoint 2010 lookup column point to a multi-line rich text field in same list? i dont find multiline column while creating a lookup column. Is there any way to achieve this. Because my ...
5
votes
3answers
5k views

Deploying List Instance - LookupMulti Type Column in XML

So I have been able to populate rows with Lookup type fields as such: <ListInstance ... > <Data> <Rows> <Row> <Field ...
1
vote
1answer
1k 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
2answers
5k views

How to get multivalue lookup column items from sharepoint list to infopath?

I am on a project. I have a list that have 2 columns. One is the title, other is a multiple value look up column from another list. Everything is ok, working well. And call it ListA. BUT, i am ...
2
votes
1answer
144 views

Uploading a file to a library with curl - how do you also update the column values

I'm able to upload files from linux to sharepoint using something like this curl -u "Domain\Account":'Password' --ntlm -k -T report.xls https://portal.company.com/test_site/test_doc/ I would ...
1
vote
0answers
18 views

Display deactivated items in lookup column

We have a list of projects. One column is named Status (a choise Active or Finished) One column is Active Projects (a calculated column which shows only the actieve projects) One column is named ...
1
vote
3answers
720 views

Get value of lookup field

I have a cascading lookup using two lists on my SharePoint 2010 site. I want to get the value of first selection made in the lookup and show/hide other fields on my custom form based on that first ...
2
votes
2answers
1k views

Copy lookup value from one list to another with SPD workflow

I have two lists and a workflow that copies items from list A, if they get approved, to list B. Problem is that a field in list A uses a lookup list, if I select Dog in the Field Animal and save the ...
1
vote
0answers
136 views

Site Lookup Column As Managed Property

Please let me know if my logic here is incorrect or suggest better alternative. This is hosted on Office 365. I have a Site Lookup column (EventLookup) that is linked to a list on my Root Site --> ...
0
votes
2answers
233 views

Lookup field not updating when the document uploading

I am uploading document programically and passing lookup field value but its not get updated, how to handle this?
2
votes
1answer
245 views

Calculated field shows seemingly random number when set to be empty

I'm trying to set up this solution for creating a filtered lookup: How to make a filtered lookup field I have set up an ItemAvailable column like this: The column "Availability" is a choice ...
0
votes
0answers
47 views

I can't change the “Return Field As” in SPD for a “lookup” type column

I recently used this topic to help me create a WF that creates a new discussion item every time a new issue item is added to the issue tracker, however I ran into a small issue when changing the ...
3
votes
1answer
581 views

CAML Query on a Lookup Field that points to a Calculated Field throws Exception

I wrote some CAML Queries to get data from a List that has lookups on another List. All is working fine as long as I do not reference a Lookup Field which points to a Calculated Field. I tried ...
2
votes
1answer
119 views

Lookup field doesn't support some field types

Its looking more and more like you can't add additional fields that are anything other than string boxes (no person or yes/no etc) is there any work around for this?
0
votes
1answer
210 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
1
vote
1answer
654 views

Extending Content Types from Content Type Hub

I have defined a content type in content type hub. I would like to use this content type on a site (other than the hub) but also to extend it with an additional (lookup) column. Is it possible to do ...
0
votes
0answers
55 views

Load a SharePoint list into a workflow variable?

I am trying to use a workflow to lookup data in a column in a list and then compare that data in another library column then update another column in the library based on if it equals eachother. ...
1
vote
0answers
124 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
1
vote
0answers
181 views

Sharepoint 2013 - Add lookup column to key filters

I've got a document library of invoices. It has various columns (mainly choices) such as, Year, Status, Location, etc. and I've been able to add them to metadata navigation as key filters. However, ...
0
votes
1answer
2k views

Bind lookup column with another subsite list

I have a site "ABC Company" in which I have two subsites. HR Inventory In HR subsite there is a list "Employee" which has a column "Full Name" In Inventory subsite there is a list "Issue ...
1
vote
1answer
259 views

InfoPath form referencing fields from another list

Environment: SP2013 Enterprise, InfoPath 2013 I'm building a course registration system for a SP client but am having a little difficulty with lookup fields. Basically there are two lists, a course ...
0
votes
0answers
50 views

Workflow to Update Library Column with Data from List

When creating a new item within the library I want a workflow to lookup a field in a list and if it equals a column in my library I want to update another column in my library. The field I need to ...
2
votes
0answers
107 views

Getting distinct/unical values from External List

I have got an External List. I want to get distinct values from this External list to the dropdownlist getting from lookup Field. The values are often repeated. How can I get distinct values from ...
1
vote
1answer
622 views

Modifying XSL for multi lookup field

I'm trying to create custom XSLT for a multi lookup field, based on this article. When changing disable-output-escaping to yes I can see the html I want to modyify: <a ...
0
votes
2answers
318 views

Hide link in Listview on Lookupfield

In my customList there are several lookups. They link to the sourcelists. My question is: How can I hide these links?
14
votes
2answers
853 views

When deploying a site from custom site template, one lookup column in doclib has empty values for Office 2010 (docx, xlsx, pptx) files

I'm deploying sites using a custom site template (WSP) that is: Saved as WSP from customized Team Site Deployed as Farm Solution Has lists, libraries with content customized in Visual Studio ...
0
votes
1answer
220 views

What is use of LookupMulti in Sharepoint 2013

Can somebody tell me what is the use of LookupMulti in Sharepoint 2013 and how to implement this with visual studio 2012? Can we use this for chaining purpose ? For example, I have 2 lists country ...