Tagged Questions

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
20 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
17 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
18 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
25 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
0answers
28 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 ...
0
votes
0answers
32 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
0answers
34 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
15 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
1answer
40 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
29 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
0answers
17 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
97 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
49 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
1answer
85 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 ...
0
votes
1answer
51 views

How do I lookup string value from another list?

I'm having trouble using a "Lookup" type field to lookup values from another list. I have two lists. 'Invoices' list shows all the invoices' being entered by colleagues with all the general ...
0
votes
1answer
60 views

How to submit multi-checkbox items in a formatted string to SharePoint lookup column

I'm new to InfoPath and SharePoint and i also use the trial version of qRules, i have 2 sharepoint lists, with one (let's call it "list1") having a lookup column to the second ("list2"), and this ...
0
votes
1answer
31 views

New list column is not displaying in dropdown list when creating a lookup column

I have an existing list called Employees and I have added a new column "Company". I would like to create a lookup column using Company but Company is not displaying as an option in the dropdown list ...
0
votes
1answer
17 views

Lookup list filter only future events

I have a task list that assigns tasks to specific future events. The custom task has a lookup column that is based on an events calendar. Is there any way I can cleanup this lookup list to only show ...
0
votes
0answers
7 views

Choose a library view to add to item in calendar

We have a library for which we create views so that users can easily find documents. One of the regular views that we create (on a monthly basis) is a selection of documents for a meeting. We don't ...
0
votes
0answers
18 views

Can I implement “reverse” permissions?

I have got a SharePoint list that is going to be used as the data source for other pages, where people can look up information. It contains: Country (Short Text) Organization (Short Text) some data ...
0
votes
2answers
28 views

Lookup on a list with permissions

Is it possible to keep a list security trimmed to a small group, while allowing a list item column to be used as a lookup? The purpose would be for the larger audience to be able to create a task ...
0
votes
1answer
42 views

SP2013: List with columns “Lookup (information already on this site)” display as URL's

I have several lists on a site that have dropdown columns that refer to other lists on the same site to keep things consistent (e.g. a department dropdown that should show the same values everywhere). ...
1
vote
1answer
41 views

How to update content type to include additional lookup fields for all instances of content type?

I have created a lookup field as a site column in my root site. The field also brings several additional columns showing information from the list. It is used in a root site content type. I have ...
0
votes
0answers
70 views

Updating a (calculated) field based on lookup field :: Workarounds

I am a site owner in SP2010 impl., at work. Not a farm admin / super admin. For one of my needs, I am designing a list using Datasheet View. I have columns of People, Lookup and Choice datatypes. ...
0
votes
0answers
43 views

How to add document to doc library with lookup columns

I am creating an upload program that needs to be able to upload documents to my document library. This document library is configured to allow content types, and I am getting all of the columns from a ...
1
vote
0answers
34 views

How to auto generate parent MMD columns based on child MMD columns?

This is the structure of one of my Term Sets. I have a Site Column called Record Type (Deeds, Agreements, Permits) I have a Site Column called Deed Type (D1, D2, D3) I have a Site Column called ...
1
vote
1answer
111 views

Lookup column to Picture Library

I've created a picture library called "Reusable icons" with all my icons. Then I created a new Custom List with a lookup column to the "Reusable icons"-library. Problem is that I don't get the url ...
0
votes
0answers
24 views

SP2013: How to find invalid lookup targets

I have a lookup column on a large library (1000+ files) and I'm trying to turn on the 'Cascade Delete' relationship behavior. When I do that, it gives me the following error: This lookup column ...
0
votes
0answers
46 views

Filtered Lookup Column from other Lookup Column

Why is this so difficult! SharePoint Online Office 365 List 1 : Group - Title, Desc List 2 : Category - Title, Group-Title(Lookup) List 3 : Document - Title, Category-Title(Lookup), ...
2
votes
1answer
99 views

Lookup field is empty after List Item is added

Here is My Problem: I have a New Form in a list and I have added some custom JS code to it. In the form is a "Registration number" lookup field with more than 20 items in it. I need to populate it ...
0
votes
0answers
54 views

Get Lookup field ID from DataTable

I have this code : SPListItemCollection CatList = LinkList.GetItems(query); SPListItem test = CatList .GetItemById(1); SPFieldLookupValue tmp = new SPFieldLookupValue(test["Category"].ToString()); ...
1
vote
1answer
152 views

Lookup Column - SharePoint 2010

Is there any way to link parent site and sub sites? Problem: I have one list on Parent site and I have a few other lists on sub sites. I am trying to create lookup columns in the parent site list to ...
2
votes
2answers
65 views

Save Site as Template (with include content) does not accept LookUpSite Columns

After long search on the web i could not figure out why i have been facing wired behaviour today with my SharePoint Site. I explain, I have a Site Collection (Blank Site Template) which contains ...
0
votes
0answers
31 views

Cross site lookup columns

If I have site structure as per the below: Site Collection -Main Site -Site 1 -SS 1.1 -SS 1.2 -Site 2 -SS 2.1 -SS 2.2 If I have a list in SS 1.1 is there any way in which I can create a ...
0
votes
0answers
71 views

Import specific row column values into sharepoint list fileds based on a field value in the sharepoint list

I have a SharePoint list (Service List) and an excel document (all registered customers) in the same SharePoint 2010. The Customer list excel document has customer no, location, address, phone number ...
2
votes
0answers
61 views

Join SPQuery in list

List 1 "Posts", fields Title body #comments modified in this list #comments fields is look up from another list Comments: List 2 "Comments", fields title body comments post ...
1
vote
1answer
21 views

SPLookup Filed extract only string values

How do you extract multiple string values in an SPlookup field? I tried the following but it didn't work SPFieldLookupValue LookUpValues = new ...
0
votes
2answers
189 views

How do I remove duplicates from a drop-down list?

I have a field in a list with the type drop down. It is supposed to show available countries which works. However, there are a lot of annoying duplicates of the same country. How do I remove them?
0
votes
2answers
32 views

How to merge multiple lookup fields?

My scenario in a nutshell: Theres a list which contains some food for example. (2010 Server) Foods ID Name 1 Apple 2 Banana 3 Carrot 4 Potato Theres another list which contain food ...
0
votes
1answer
34 views

How are additional fields stored in a lookup column?

When creating a lookup column it is possible to select additional fields. Does SharePoint store the values of these additional fields in the "child" list, or is a database join performed every time a ...
1
vote
2answers
51 views

How to get LookupValue in ItemUpdating

I have a custom EventHandler for ItemUpdating on a list which has a Lookup column. If I look in the properties.AfterProperties for the column in the ItemUpdating event I get the LookupId value but ...
0
votes
1answer
55 views

More than one user not getting email alerts (SharePoint 2010)

I'm using SharePoint Designer 2010, and I'm creating an application which assigns tasks to other people. In the application, whenever a person is assigned a task, that particular person (or group of ...
0
votes
1answer
105 views

Send Email using Lookups from Workflows (SharePoint 2010)

I'm currently using SharePoint 2010 Designer, and the 2010 version of SharePoint. So I'm currently designing a SharePoint application which can assign tasks to other employees. Any tasks assigned ...
1
vote
0answers
31 views

Document Set lookup error

I have what seems like a minor bug when setting up a new document set. I've created a new content type based on a document set. One of the columns in the document set is a look up to a supplier list. ...
0
votes
1answer
29 views

List provision order on deployment

I have a generic list with just title fields. I'm trying to have another list use a lookup column to list each item. If I add the lookup to second list after deployment it works. But if I simply ...
1
vote
1answer
61 views

SP 2013 REST API retrieve values from lookup library

I have a custom list 'MyList', containing a (single value) lookup field 'MyLookupField', which points to a library 'MyLibrary'. I now want to retrieve all items from 'MyList', including the Link to ...
0
votes
1answer
207 views

Workflow condition using a lookup column

I am sure this is something quite simple but I can't seem to figure this out (I am new to SPD and workflows in general). I am building a workflow to notify key individuals of a new item(s) being ...
0
votes
0answers
22 views

Workflow Lookup Column in Site Workflow

I am using Sharepoint Designer 2013, and I am looking for a way to create a column lookup that looks up the current item and looks for the column Due Date. Can you do this and apply this workflow to ...
2
votes
1answer
55 views

How does the look up function work?

I currently have two lists: List #1 have the fields country and colour (and several other fields that are irrelevant) List #2 have the field colour (and several other fields that are irrelevant) So ...
0
votes
0answers
166 views

SPServices.SPCascadeDropdowns - Display Title rather than key

I'm using SPCascadeDropdowns to filter a child drop down which is working. However, I would like to display another column than the one in the relationship. I have created two lookup columns that ...