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
117 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 ...
1
vote
1answer
756 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 ...
1
vote
0answers
341 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
2
votes
0answers
13 views

Multiple Criteria Lookup in Parent List

I have a list of projects (Project List) and another list of periodic status updates (Status Update List) related to each project (one-to-many). I need a lookup column in the Project List that ...
0
votes
2answers
4k 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
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 ...
0
votes
2answers
37 views

Alternative to Lookup Column

I have a list with a lookup column displayed as a dropdown menu in the NewForm allowing the user to pick a contact person retrieved by lookup to the contacts list, however this list will soon grow ...
0
votes
0answers
9 views

Sharepoint 2013 Foundation filtered value from other list

We have two lists- One for contacts and other is vacations. Our goal is following: When we open a contact card there would be a value from vacations list what would only display the vacations of the ...
0
votes
1answer
391 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
1answer
1k 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
38 views

SharePoint 2010 Rest query for Lookup fields

I am writing a REST query to retrieve data from child parent list. States is the parent list with "Title" column. LocalGovernment is the child list with "State_Territory(InternalName) and State / ...
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
1answer
528 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 ...
2
votes
1answer
28 views

Lookup column showing up properly when logged in as Full Control user, but not showing up properly when logged in as Contribute user

I have a SharePoint 2010 form with a couple lookup columns. The form looks normal to me with Full Control permissions, and the dropdowns for these items are showing up normally on the form, but ...
0
votes
0answers
15 views

Workflows - getting fields to populate look up fields before sending an email

I'm working between two sites (a) and site (b). I'm also using cross-site publishing. On site (a) each item from a document catalog on site (b) is displayed and the url contains the ItemID. On ...
0
votes
0answers
16 views

How to interact with a XsltListViewWebPart

Try to imagine this scenario: You have a list A with one field TitleA, and you have a List B with three fields: TitleB, FileAttachement, Lookup(A). From an Application Page you want to create a new ...
2
votes
1answer
60 views

JSLink and lookup field problem

I am trying to make a cross site lookup field. So for now I made javaScript file and overrided the JSLink parameter. I want to made it clear for sharepoint and followed clientforms.debug.js ...
0
votes
0answers
15 views

List only shows id numbers and not the text when mapped with infopath

I have run into an interesting problem and was wondering if anyone else has experienced this and found a workaround. We have a list with several choice columns. The choices in those columns were kept ...
0
votes
1answer
1k 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
2answers
1k views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field through PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl ...
1
vote
0answers
26 views

Limit dropdown options when the lookup column is a site column and has more values than are relevant

I have a list of projects on my parent site with two columns: ` Project Category I would like to use Project as a site column that looks up values from the aforementioned list so I can maintain a ...
3
votes
1answer
918 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
2answers
27 views

lookup another lookup

I've 3 lists. List B looks up List A and then I need to create a lookup in List C that lookups List B but also get values in List B that are lookups of List A. How is this achievable? Thanks
1
vote
1answer
23 views

Create a Cross Site Lookup in a declarative way

I can declare a lookup field with this line: <Field ID="{3EA24157-1C11-41CB-AA01-5EEEF93C2603}" Name="NewField" DisplayName="New Field" StaticName="NewField" ...
0
votes
0answers
6 views

Client side populate dropdown with lookup values

In the UI of SharePoint I've added a lookup to a child list. I now need a custom form where the user can set this value via a dropdown. Do I need to load the data from the parent list or is it all ...
0
votes
2answers
647 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 ...
1
vote
1answer
53 views

Reasons why a Lookup field doesn't work

I'm struggling with the declarative creation of a lookup field: <Field ID="{3EA24157-1C11-41CB-AA01-5EEEF93C2603}" Name="NewField" DisplayName="New Field" StaticName="NewField" ...
0
votes
0answers
20 views

Filtered lookup using SPServices

I have 3 lists: Schools, Interactions, Contacts In the new form for a Interaction item I have a lookup field displaying a long list of contacts, however I need to filter this list to only display ...
0
votes
1answer
30 views

Set a Lookup reference to a Field that already exists

I need to set the lookup reference to a field that already exists (of type lookup) that is not pointing to yet. I can get the lists and the fields but I don't know how link to each other. Can you ...
2
votes
1answer
72 views

Search Display Template Not Returning Values for Managed Property

Search results has no value for a custom site column. Ok, so I have a lookup column created as a site column in the root of my site collection. I found the field in crawled properties. NOTE: I am ...
2
votes
1answer
39 views

How to set image path to lookup column?

I have a custom list having lookup with a picture library. But when I am creating lookup it just gives some of the columns like Title, Created, Modified, etc. it do not gives any value like FileRef or ...
1
vote
1answer
616 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 ...
1
vote
1answer
1k 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
793 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 ...
1
vote
0answers
33 views

Cascading functionality in quick edit mode in Office 365

I've sandbox solution in Office 365. I want cascading functionality of Country, State, City in SharePoint lists. I got that by using SPServices JavaScript but only in NewForm and EditForm. Want this ...
0
votes
1answer
32 views

How to show Created By and Modified By columns as lookup field?

When I want to add a lookup column to a document library, created by and modified by columns are not listed. Can I add these columns to another list or document library as lookup column?
0
votes
0answers
18 views

SharePoint 2013 List Error when selecting less than two Items in a Column Filter (Primary Lookup Column)

I have a SharePoint list with many columns, two of which are SRN and PN. SRN is a Primary Lookup Column (values to choose from are populated from source list), and PN is a Secondary Lookup Column ...
1
vote
2answers
688 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
0answers
17 views

How to filter lookup field by site name

I have a list like this: Title Site AAA Site1 BBB Site2 CCC Site2 which is referenced in a lookup column. Requirements are to filter in the lookup column only the items whose "Site" property is ...
1
vote
1answer
26 views

Moving files between Libraries along with Lookup Columns?

Is it possible to move a file from one library to another along with the lookup columns associated with it?
1
vote
0answers
49 views

SharePoint Online Lookup Dropdown Autocomplete/Combobox

I have a list in Sharepoint Online, which has a lookup to an other list. No matter what, on the form it will always render as a dropdown value. When this list of values becomes huge, it's hard to find ...
0
votes
0answers
27 views

SharePoint 2010 Lookup IE more than 20 items no longer working

As opposed to almost everyone over the forums I looked, one of our internal client would like to have the complex lookup field to work back again. Since a month or two, apparently this feature stop ...
1
vote
0answers
37 views

How to Update/Set Field values by LookUpId in a sharepoint list?

I have a list called ResourceCheckList which contains following columns with lookup fields as below : Here Resource:ID is a lookup column which contains unique ID of another list. So, I want to ...
0
votes
1answer
21 views

how to lookup column that has versioning enabled in SharePoint Designer

I have a custom list "Requests" which is used to capture user requests. There is a column "Comments" which I have enabled versioning to capture conversation exchange between the user and request ...
0
votes
0answers
12 views

Projected field value display in view

I have a bank list with bank id and bank name. I have another list with bank name as lookup. In server side code when I am getting the Customer list collection I am getting bankID projectfield ...
0
votes
1answer
40 views

look up column error

I am getting into a null array - $spList = $webobj.Lists["Studentlist1"] Exception calling "update" with "0" argument(s): "This lookup field cannot enforce a relationship behavior because it is not ...
0
votes
0answers
31 views

Associated Lookup column

I have a SharePoint 2013 list that contains a lookup column, and additional columns associated to that lookup. For example lookup column 'Car' and the associated is 'Car:CarDescription'. I have a ...
1
vote
1answer
30 views

Dynamic Column choices

I have a task to create a Document Library in Sharepoint. I have done this several times. This particular site have a bit of a complex index structure. I am stuck on figuring out if it is even ...
0
votes
1answer
39 views

PowerShell script to create a list and add a lookup column

I need a Script to create a custom list and add a look up column into it and add the column into a default view. The look up column should have relationship of Restrict delete.
0
votes
0answers
17 views

Can a content type item inherit sibling column values from lookup column item?

Here is how I have my lists structured - in case it matters, List A does not currently utilize Content Types. The problem is in the List B view of Site Column B. Since Content Type Y doesn't ...