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

How to change the color of each column in a SharePoint chart?

How does one change the color of each column in a SharePoint Chart Web part? For example the "passed" column would be green, the "stopped" would be red. I am pulling data from this list: It ...
0
votes
1answer
28 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 ...
0
votes
1answer
26 views

SharePoint 2013 lookups with more than 20 items as select or input?

So I was reading about doing some JavaScript to manipulate the default forms for our lists and came across this: ...
0
votes
0answers
13 views

How to get lookup field value in document template while editing in word application?

I have a document library whose content type has a document template. I am setting the field values while creating new document in word application where the fields are available to set. Among the ...
0
votes
1answer
1k 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 ...
0
votes
3answers
27 views

Get value of lookup

In js, i retrieve some items and inside there are lookup column and people column. When i print them, it's [object Object] Are there a way to determine if it's a lookup column? This one doesn't work ...
0
votes
1answer
7 views

Content Types Template problem with lookup column in template

I have a content type. When I want to create a new document from that content type the properties (Columns) for that content type also open in my document. The problem is that there is one lookup ...
0
votes
0answers
7 views

When I am using a look-up column, once I have used one value from another list, can this value be hidden for any subsequent entries?

I'm in the testing phase of setting up a database and a log on SharePoint. The log requires information from the database so I have set up a look-up column in the log and database to link the ...
0
votes
0answers
12 views

How get current user login name and populate his records in a lookup field

I have a library 'Download Asset' in which different user will upload files. In this library there is a column 'AssetName' . Now I am creating another list 'feedback'. In the feedback list there is ...
2
votes
1answer
482 views

How to update metadata?

I have following code (didn't list the whole code) behind a button on a InfoPath Managed Form. and it works meaning I can submit data to a list. Now I have 2 controls on the form that is ...
0
votes
1answer
14 views

Columns not displaying value

I've added some columns (name, ID etc ) to the document library after the documents have been uploaded, and got no value displayed. Is there any way to fix this or I'll have to recreate the library?
0
votes
2answers
32 views

SharePoint 2013: How to find orphaned lookup values

I've got a projects list in SharePoint 2013 that connects to two document libraries by way of a lookup column. Each document set in the libraries should ideally have its lookup column pointing to a ...
0
votes
0answers
12 views

MultiValue Send an Email Lookup

Is there a way for the Lookup that is in the body of the email to send multiple values. I have a repeating section in my form and it currently will send a seperate email for email repeating for I want ...
0
votes
0answers
26 views

Display error - web parts with look up columns

as seen below I have a display error with my dropdown arrow from the look-up columns. I have basically put two appparts on a webpart page on Sharepoint 2013. Appart 1 contains of two lookup columns A ...
1
vote
1answer
698 views

Document Information Panel contacted a data source but failed to receive data. The form will load without the requested data

The query cannot be run for the following DataObject: list_48985ACC-FDDD-4732-AA48-078CFE123F35 Document Information Panel cannot run the specified query. The SOAP response indicates that an ...
0
votes
1answer
181 views

get an error while exporting access database to sharepoint 2007 lists: lookup contains values that do not exist in the related table

I try to export a table in a access database to sharepoint 2007. All related tables are automatic exported to SharePoint as lists. SharePoint creates lookup fields for each relation. Under the export ...
0
votes
0answers
21 views

Lookup Columns and Web Part Connections

I'm working on creating a Page Template which will display various content from different lists together based on a common lookup field which is in each list. I've created a new Content Type based ...
0
votes
2answers
41 views

Cascading Lookup columns

I have a project where I need to create a form. In that form I have several columns. The columns that I have questions about are assignment category Assignment type I have questions because the ...
0
votes
1answer
400 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
0
votes
0answers
15 views

Accessing individual elements of a field that has multiple values in a workflow

So I have a Class and the class has a field Students. Students is a lookup to the Students List that accepts multiple values. I want to build a workflow that, on item creation, will make a row in ...
2
votes
1answer
278 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
2answers
36 views

Lookup in SharePoint

I'm using Sharepoint 2010. I have a List "Discipline" with 3 columns Discipline Code Discipline Des.-Site 1 Discipline Des.-Site 2 A A1 ...
1
vote
3answers
1k views

Compare two person columns in a list

I have a list which has a "Person or Group" column called as Reviewer. I want to notify the reviewers whenever he/she is added to the list item. I created a custom workflow which sends a mail on ...
0
votes
0answers
22 views

Can't use additional fields from lookup column in workflow

I have a list with name, department, email and summary column (which is a calculated column from name/email/department). Then i have a document library. Here i have a lookup column called Guarantor ...
1
vote
0answers
32 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
1
vote
1answer
928 views

content query web part with multi value lookup column

I am trying to work out how I can query a content type with a multi value lookup field using the content query web part. I know that natively this is not possible with ootb sharepoint 2010 however I ...
1
vote
1answer
1k views

set multiselect lookup column using jquery

I have a Multi select Look up column which as you all know is a control with two list boxes and "Add or Remove" Buttons. The user populates the right-hand side of the control with some values by ...
1
vote
1answer
539 views

Clear all values in a multi-value lookup, via REST, SP 2010

Conditions: SP 2010, html/javascript, using REST to read/write to various lists. Im using a jquery multiselect plugin to set a multi-value lookup column. I need the selecting Groups of items, easy ...
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 ...
1
vote
2answers
400 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 ...
1
vote
1answer
836 views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
0
votes
0answers
24 views

Rootfolder=* in lookup-link causing troubles

I've got 2 lists, a User- and an Issue-list. On the Issue-list I've got a single-lookup to the User-list, so 1 Issue can have 1 User assigned for it. The column in the User-list that's being looked ...
1
vote
1answer
29 views

Update list item once library item is created

We have a list that is used to notify people that they need to create an item in a library. We want to update a field in the list once the item in the library is created. We tried to use the method ...
1
vote
0answers
23 views

How to develop an event receiver on selecting item from dropdownlist

In my SharePoint list,I have a lookup column. When I select one item from the lookup,I need to show the information from the selected one(like title,ID...). I think that developing an event receiver ...
0
votes
0answers
38 views

copy one column value to another column in a list

I have a list named ABC in MOSS 2007 List has 2 Views (All Details and Multi Location) 2 columns (BA-tech and BA for both views) BA- tech field is "Single line of text" type and BA field is "Look ...
0
votes
4answers
674 views

Accessing LookupFieldValue throws error

I have a lookup field on a list (header) that looks up values on the same list. I am trying to read the value out of that lookup with this code: using (SPSite site = new SPSite (mySite.ID)) { ...
0
votes
0answers
42 views

Using multiple value lookup column for an email “To:” line

I'm having an issue using a multiple value lookup column in SharePoint 2010. I have two lists. One is a task list and will be the main list that users use for this site. The second list is just a ...
4
votes
2answers
460 views

Set a date/lookup in ListInstance elements.xml

I have two lists. The first one has customers and the second one has Orders. Now i want to add some (test) data in the elements.xml of the listinstances. For customers this works without a problem ...
0
votes
0answers
42 views

Copy lookup field

I have two lists: Task List Project A" (Title, Project, Parent Task) and Task List all Projects" (Title, Project, Parent Task) In both lists "parent task" has to be a lookup field. I want to ...
0
votes
1answer
22 views

Add items to the lists having lookup relation using powershell?

I am trying to add items to the comments list based on the Post list having lookup relation ship between these two lists,can any one give me an example how to update the lookup column values using ...
0
votes
0answers
46 views

Content search web part - lookup field - SharePoint 2013

I'm trying to get display lookup fields in my cswp. I know that Microsoft doesn't support this out of the box. But is there a way without having to create a single list without lookup fields? I've ...
0
votes
1answer
51 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 ...
0
votes
1answer
34 views

Can a Lookup list field point to web property bag?

In my subwebs I have a 1 row list called "Details" that contains various bits of data that are meant to be web-level metadata. Image field, AssignedTo field, couple of string columns, etc. On top of ...
0
votes
1answer
113 views

Problem copying lookup column data from one list to another via PowerShell

I have the below script that works for moving list data between two lists on sites next to each other that have the same schema. Everything works perfectly bar a column of type LOOKUP named "Name of ...
3
votes
0answers
200 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
0
votes
0answers
18 views

Return specific value by criteria in row and column

I have SharePoint 2013 list with countries as column and Prod Ref as row and price as Value like this Germany Spain Portugal 12#1_____12______33________12 15#1 ...
1
vote
0answers
168 views

Sharepoint 2010 - Workflow, return field as Lookup Values, Comma Delimited getting both lookup id and lookup value

I'm working on a simple workflow in SPD 2010 which is going to send an email to multiple recipients based on lookup values and even though I set the "Return Field As: Lookup Values, Comma Delimited" ...
0
votes
1answer
57 views

Trying to get lookup (Title) value, but returns null only in Client Object Model

I have this query: <View> <ViewFields> <FieldRef Name='Title' /> <FieldRef Name='itlgCategoria'/> ...
0
votes
3answers
1k views

Displaying value in infopath not the number

Infopath. In my infopath form. I want to show the teamName as "team 1" value but it is displaying "1" number instead of "team 1". The TeamName is a lookup column in the ProjectList.
2
votes
5answers
621 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 ...