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
34 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 ...
0
votes
1answer
63 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 ...
1
vote
1answer
37 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
75 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
21 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 ...
0
votes
1answer
25 views

Lookup column, using one or two features?

I have 2 lists with a lookup column. I'm thinking about 2 choices. Even putting them in the same feature or separate them in 2 features. My question is : Does putting the lists in the same feature in ...
0
votes
0answers
40 views

Lookups are empty

I have a rule set with two content types A and B. Both content types have the same parent content type and nothing else more. They are identical except for their name and ID. I'm adding files to the ...
0
votes
0answers
19 views

LookupField isn't displayed in application page

I have a custom list which I have a SPFieldLookup in. I've created an application page with my own custom creation form for a new item of that list so I'm trying to put an LookupField but nothing ...
0
votes
1answer
30 views

Lookup Column Making Creating a New List Item Take Way too Long

We have a Sharepoint list that contains information based on a daily receiving log for our receiving department. When it was set up, there was no archive workflows created, so now this list has grown ...
0
votes
0answers
24 views

OrderBy on a lookupMulti

I need to order a Caml query result's on a lookupmulti. Is that even possible ? Thx in advance.
0
votes
0answers
45 views

Cascading dropdowns with 2 parents

I've used SPservices to create cascading dropdowns via lookup columns without issue. My question is if it is possible to create a cascading dropdown with two parents (without using infopath). ...
0
votes
0answers
79 views

CSOM retrieve List Item doesn't show some Lookup Key Value pairs

I try to load a ListItemCollection from my SiteCollection using CSOM C#. Therefore I use the following List rr = web.Lists.GetByTitle("MyTitle"); context.Load(rr); FieldCollection fcol = rr.Fields; ...
0
votes
0answers
47 views

Issue Tracking and Related Issues Lookup Field

I'm using the out of the box issue tracking list and I'm trying to find a way to filter a multi choice lookup field based on another multi choice lookup field. I'm on Sharepoint Online, on an Office ...
0
votes
0answers
70 views

How to remove link to Lookup field in default DispForm

I have a list, with several fields, including a Lookup field. I display the items of the list on a custom webpart. Everything works fine. When I click on an item in the web part, the default DispForm ...
0
votes
1answer
48 views

How to copy choice column values to lookup column values

I am using sp 2010. I have a column from type "choice" and is multiple. I have created a new column from type lookup field. Also this lookup column is multiple. I already have migrated the values to ...
0
votes
2answers
103 views

Using a calculated column from a lookup list

I am working with SharePoint 2013 at a hosted site (not Office 365). Most of the questions I see when I search relate to including a lookup field in a calculated column. That is not my issue (but it ...
0
votes
1answer
58 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) ...
1
vote
2answers
33 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
33 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 ...
0
votes
0answers
55 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 ...
0
votes
1answer
76 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
2answers
72 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 ...
2
votes
1answer
240 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 ...
0
votes
1answer
58 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 ...
0
votes
1answer
43 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 ...
0
votes
1answer
146 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, ...
0
votes
1answer
48 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
18 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, ...
0
votes
0answers
607 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 ...
0
votes
1answer
54 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
27 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
39 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
46 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 ...
1
vote
1answer
654 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
2answers
172 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
85 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
36 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
22 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
42 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
205 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
86 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
117 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
39 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 ...
0
votes
3answers
590 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
43 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
750 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 ...
0
votes
1answer
34 views

Is it possible to craete a lookup field to your own list?

sp 2010: Is it possible to craete a lookup field to your own list? I try it now, but the lookup field is empty. My target is to have list items which refer to other list items. Like main and sub ...
0
votes
1answer
144 views

Pull multiple values through a lookup

I am rather new with SP so I apologise if I cant express myself too well. Problem at hand: Two lists - Shops and Managers with a many-to-many relationship between them. I.E. in Shops there can be ...
1
vote
1answer
404 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
2answers
95 views

Limit to the amount of values you can have in a lookup field?

Is there a limit to the amount of values I can lookup? When I search for the topic I only get hits on the number of lookup fields you can have in a list. I have tested this a bit and it was ...