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
3k 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
11 views

Lookup Column - Shows Some Additional Fields, But Missing Columns

I have created two related lists. The first list is keeps track of specific meetings, with the following: Name of meeting (Single Line Text) Date of meeting (Date and Time) Chair of meeting (Person) ...
0
votes
1answer
336 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 ...
1
vote
2answers
17 views

Sorting Lookup Values

I have a list that breaks down periods within our accounting calendar. P1, P2, P3,...P12. The problem I am having is when I perform a lookup on this column it's sorting by alphabetical order and it ...
1
vote
1answer
84 views

Sharepoint 2013 - How to lookup custom string in workflow task

I'm creating a workflow that assigns a task to a person. After that person completes the task, they are required to input a string of text (a server URL) before they can press "Approve." Once this is ...
0
votes
0answers
28 views

Problem while resetting the share point lockup value with 20+ items

I have a sharepoint lookup and a text box. On Text box changed event i want to reset the next lookup value to (None) and text box to empty. Below is the code for the same. This code is working ...
1
vote
1answer
126 views

SharePoint 2013 - Remove the hyperlink from a lookup column in a list view

I've searched the web and found a solution.... IF I WAS USING 2010 or 2007. I have cascading selections referencing two different lists that hold the dependencies as lookup columns. My cascading ...
1
vote
1answer
20 views

Weird formatting for Item lookup

I have a lookup column in a List (A) which gets its value from a Single line of text in another List (B) where there is only a Title column. When sending out emails and I try to look up the value of ...
1
vote
1answer
76 views

Edit Lookup table programmatically via Project Server Interface (PSI)

I have a standard lookup table database table "LOOKUP_TABLE_VALUES" in a SharePoint 2013 solution with columns like: LT_UID - for the Lookup table GUID LT_VALUE_FULL - storing the values with the ...
1
vote
1answer
588 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
26 views

How to Increasing Lookup column limit from 8

I am facing following problem: 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Detail: The query cannot be completed because the number of lookup columns it contains exceeds the ...
1
vote
4answers
6k views

How do you connect a Calendar List to a Project Tasks list using Web Part Connections?

I created a Calendar List and a Project Tasks list. Then I added a lookup from the Tasks list to the Calendar list. However, when I try to connect the two with the related field visible on both list ...
1
vote
2answers
43 views

Add a lookup field for a list in Sharepoint Client Model

This is what I've achieved do far: var listCreationInfo = new ListCreationInformation(); listCreationInfo.Title = "New List"; listCreationInfo.TemplateType = (int)ListTemplateType.CustomGrid; List ...
0
votes
1answer
22 views

Making imported column to a Lookup Value

I did a Excel import to a SharePoint list, there are 3-4 columns that are lookup values. Is there a way to make those columns lookup values again? I tried to edit the column but only options seem to ...
1
vote
2answers
520 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
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 ...
0
votes
1answer
473 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 ...
1
vote
1answer
872 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
1answer
34 views

Sharepoint 2010 - Make assigning users easier

we are using Sharepoint 2010 and maintaining an Action Item/Issue tracker list (for a limited number of people, <10). To make assigning Action Items to users easier I want to implement to option to ...
0
votes
1answer
16 views

Why using Decimal in this CAML Query is not returning correct records?

I have the following table: DoubleNumber ------------- 10.50 44.77 88.90 I am using the following CAML Query: query.Query = "<Where><Contains><FieldRef ...
4
votes
2answers
723 views

REST API Filter by multilookup property

Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer ...
0
votes
0answers
43 views

Calculate Field with a Lookup Additional Column

Would like to ask some suggestion if i have 2 lists (Vendor List & Order List). Where Vendor List is contain with name & discount fields And i create new list "Order List" with field Items, ...
1
vote
1answer
718 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
907 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 ...
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
392 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
14 views

How to recognize which button was pressed in workflow task outcome

I am creating a workflow, and I have a modified task outcome with custom buttons. It looks like this: When the user presses "Extension Approved" I want the loop in my workflow to continue running, ...
3
votes
3answers
2k views

GridView lookups displaying as “id;#value”

I am using an ASP.net gridview. The datasource is SPList.Items.GetDataTable(). The gridview is working fine; however, lookup and multilookup columns display as "id;#value". Is there any way to just ...
0
votes
1answer
21 views

Auto-completing Lookup Columns for Datasheet View and Allowing Multiple Values

I have a user that fills out their list most of the time in Datasheet view for quick data entry. They have a lookup column for single values only where they can just start typing in the name they're ...
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
0answers
29 views

Workflow Error: Coercion Failed: Input cannot be null for this coercion

I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here's how the data looks: Look Up Title ...
2
votes
5answers
4k views

How to Force Alphabetical Order in Lookup Dropdown with Multiple Choices

In my portal (Sharepoint Server 2010 Enterprise) I have a simple list with only the title field. I've created about 50 entries in the list. In another list, I have a lookup column that pulls from ...
0
votes
1answer
16 views

SP 2010 - Lookup Column not working with Conditional Formatting

I have a lookup column for Tabs: Major Sub-1 Sub-2 Sub-3 Technical Pricing I need to setup conditional formatting so the row color changes with the level of tab selected. I can do this with drop ...
0
votes
1answer
27 views

Display Lookup ID into list view

How can I display the lookup Id (of a lookup field) instead of title into a list view? I am using SharePoint 2013 on-premise.
0
votes
1answer
21 views

How do I send data to a lookup field with ReST? SP2013

I've been working with a jQuery AJAX call to post data to one of my SharePoint lists. One of the fields in this list is a look-up field. In forming my JSON data to push to the list I was able to ...
0
votes
3answers
168 views

Filtering Look up Columns with Javascript

I'm trying to find a way to dynamically filter a look up column on the new and edit forms in SharePoint 2013. I want to be able to get a value from the URL and use that to filter the look up ...
0
votes
1answer
50 views

lookup column in calculated column formula

I have a Lookup column(Discountfirst) which has Number. I also have another Calculated column(Finaldate) with Resulttype DateTime. One more column(DateofReceipt) in Date. My Calculated column formula ...
0
votes
1answer
32 views

SharePoint Copy Blog to new site collection in c#

I am trying to make a code that copies Posts and Comments to a site. It is working, except setting the lookup field to connect Comment with Post. using Microsoft.SharePoint; using System; namespace ...
0
votes
0answers
15 views

Item moved copy associated lookup column in new library

How to explain this correctly :D I have two document librairies in one SharePoint site: - Source. - Dest. Both librairies have no Content Types. Both librairies have a column created within the ...
0
votes
0answers
15 views

Column Lookup only will not return numerical values

I am attempting to link two lists within a Sharepoint site. On the list being referenced, I have values stored a numbers. However, when I do lookup from the second list, it only returns the values as ...
1
vote
1answer
34 views

Searching between two separate lists for matches

I have two SharePoint Lists each with a column called Unique Key, what I need to do is search list B for matches in List A. List B is the larger of the two and each List contains only unique entries ...
0
votes
1answer
62 views

Extracting text from a lookup field in a SharePoint 2013

I switched from InfoPath to the Designer forms. In the list i have a Lookupfield that Points to another list. In the Control modes Edit and New the select boxes are created automatically using the ...
0
votes
1answer
34 views

More than one showFields in lookup column

When we create lookup column OOTB, there is option "Add a column to show each of this additional fields", so that we can have more than one show fields in list for that lookup. But how to do same ...
0
votes
1answer
68 views

Different sets of options in a lookup or choice column depending on the content type

I have a list content type and other content types that derive from it. I need to add a lookup or choice column to the content type (or the list itself) just so that each child content type or list ...
0
votes
1answer
35 views

Creating a lookup field that contains calculation?

So I created a lookup table, how would go about truncating via a lookup? For example, Choices 56, 56SW, 56FR are using the same calculation Choices DDS IDSL, ISDN TR, ISDN are using the same ...
3
votes
1answer
498 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
3answers
151 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
40 views

Using Additional fields of lookup in a worflow

For some reason, SharePoint saw fit that we would not be able to use a lookup in a lookup, so I have been doing the workaround where you use a workflow to copy the contents of the first lookup into a ...
1
vote
2answers
214 views

Filter lookup column based on another field value

Scenario: I have Tasks list with a (lookup) column Project. I have also a multivalue lookup column Predecessors pointing to the Tasks list itself. Question: Is it possible to filter available Tasks ...
3
votes
1answer
66 views

Create a lookup field that is text instead of a drop-down (or similar)?

In SharePoint, I have a list (staff) and a document library and have successfully made a custom lookup column/field from the document library pointing to the staff list (staff id column). This ...