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
0answers
18 views

WP connection, lookup in children causes unexpected error when in view

I have the following scenario: MainList / ChildrenList {MainList:ID lookup column, ThirdList:ID lookup column} In the MainList display item form: WP#1: MainList with columns {ID, Title, ...
1
vote
1answer
144 views

Lookup column missing from document properties list

For the scope of this question I am working with SharePoint 2013. I have a Tasks list that was created with the OOTB (add an app) Task list. I have a Document Library that was created with the OOTB ...
0
votes
0answers
51 views

Lookup column output includes strange characters in workflow

I am having problem displaying values from a cascade lookup to display the values in my email body. Example: I have a passenger column with this values already entered and save "Faith and John". Now, ...
1
vote
2answers
148 views

How to read lookup multi columns with the Sharepoint Listdata Client Object Model?

I have a list with a couple of multivalued lookupcolumns. When I try to do something with these fields the count is 0 even though I assigned it a couple of values. Below is a snippet of my code: (I ...
0
votes
1answer
92 views

Add new button to a column with “single line of text data type” in SharePoint

I am trying to create a "Add new" button to a column called "other Passengers" which has a "Single line of text data type". Such that I can add up "0 to n" numbers of passengers not in our LDAP i.e ...
0
votes
1answer
51 views

How Do I Format A SharePoint 2010 Search Refiner Lookup

In SharePoint 2010 Search, I've added a new managed property that refers to a lookup column. I then added a custom refiner by modifying the Refinement Panel "Filter Category Definition". Basically, I ...
0
votes
2answers
89 views

Update a field after running standard approval workflow

I copied the approval workflow available. After completing the approval, I want one field related with the item that was approved to be updated. I tried different ways but nothing works. Should I ...
0
votes
1answer
126 views

Sharepoint 2010 site definition and Lookup column

I have created a custom list definition with a lookup field using Visual Studio. Everything is working perfect. After that I created a site definition using Visual Studio and added this custom list ...
2
votes
1answer
72 views

Lookup column with no duplicates

I have a library containing documents, each one regarding a project. I also have a custom list with tasks (for monitoring) which has a column PROJECT. There are more than one tasks per project so this ...
1
vote
3answers
101 views

Limiting permissions to list-items and library files without using folders

I have some files in a flat library, i.e., no subfolders, that need to have access restricted to a couple usergroups. I understand that one way to do this is by placing items in a subfolder in the ...
2
votes
0answers
57 views

Sharepoint 2013 not displaying lookup field as input

I have a lookup column whose datasource has many items (2 000+) and when creating an item that references the source list, a dropdown is not very suited for the task. In SP2010 when there were more ...
1
vote
2answers
89 views

Multi Level Lookup in SharePoint 2010?

I would like to achieve multi level lookup as below Cluster List structure Project List structure Project List Entries Phase List structure When I select the cluster, it should show only the ...
0
votes
1answer
125 views

Lookup value not being copied

I am using following xml code (copy.asmx > method CopyIntoItems). Per Microsoft http://msdn.microsoft.com/en-us/library/websvccopy.copy.copyintoitems(v=office.14).aspx I should be able to update ...
0
votes
0answers
46 views

How to select look up column in sharepoint workflow

I have a list "Tasks" which has "Assigned to" field. This "Assigned to" field is a lookup for another list column. (The list is "Team" and column is "firstnamelastname"). Now I am using a workflow. ...
0
votes
2answers
312 views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field throw PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl $myCustomList = ...
1
vote
0answers
92 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 ...
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
192 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 ...
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
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 ...
0
votes
1answer
93 views

SharePoint 2013 - Reverse Lookup

I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are ...
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 ...
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 ...
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' ...
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 ...
5
votes
3answers
1k views

BCS External Content Type with 20,000+ items (O365)

We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
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 ...
2
votes
5answers
309 views

Cascading Dropdown

I am new to SharePoint 2013. What I need to figure out is based on the following situation. I have several school districts with multiple schools within the school district. I would like to create a ...
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
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?
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 ...
0
votes
1answer
836 views

Add new item to child list and refresh the parent form - multiple lookup

I've created a parent list (Vendors) and a child list (software list). There can be multiple vendors for one piece of software. I've created a custom new form with a link which opens up a modal to add ...
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 ...
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 --> ...
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 ...
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, ...
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?
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 ...
0
votes
1answer
2k 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
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 ...
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, ...
2
votes
2answers
706 views

infopath form not updating fields

I have an infopath form that has three read-only fields referencing items in another list, but when someone opens the form the values never change, even if they have changed in the other list. It ...