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
32 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 ...
0
votes
1answer
224 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
189 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
98 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
0answers
54 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
373 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
50 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
2k 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
32 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
43 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 ...
0
votes
0answers
37 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
34 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
31 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
98 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
757 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
81 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
543 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
71 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
139 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
90 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
151 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
62 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 ...
3
votes
0answers
277 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
22 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
955 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
90 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
2k 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
3k 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 ...
0
votes
1answer
69 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
98 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
40 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
1answer
47 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 ...
2
votes
0answers
244 views

Filtering LookupMulti by FilterMultiValue SP2010

I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment FilterName=Tags&FilterMultiValue=Flower;Sword Three is nothing, apart correlation ID. I found in ...
0
votes
3answers
490 views

XSLT Listview webpart not showing site column lookup values

The Problem: We have a top level site that contains various lists of data. The information in these lists are exposed to subsites using site lookup columns. In our subsites we have various lists that ...
5
votes
3answers
3k 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 ...
0
votes
0answers
9 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
22 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
31 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 ...
7
votes
3answers
1k views

Replace semicolon delimiter in a Lookup column on the list view

When selecting multiple values, the data is separated with semicolons. When many values are selected it starts looking cluttered. Is there any way to have each value on a new line? For example, ...
0
votes
1answer
92 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
77 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
112 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. ...
7
votes
5answers
9k views

Why is my column not shown under “Add a column to show each of these additional fields”?

In SP2010, I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
0
votes
0answers
61 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
3answers
285 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
1answer
749 views

In a DVWP my Multilookup column is not returning IDs, only column values

I've added a DVWP to a page. The DVWP shows data from a list with a multi value lookup column. The value returned for this column is in the form: value1;value2;value3. Now I want to render this ...
1
vote
0answers
54 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
396 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
70 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), ...
0
votes
1answer
158 views

Specify Lookup list for the 'Title' Column of a Gantt chart view

I was hoping to use a lookup list as the title column for a Gantt chart view. The problem is when I go to the Gantt columns in the settings for the view it doesn't display any of the lookup list ...