A lookup column is a SharePoint list column that retrieves its available values from another column within another list in the SharePoint site.

learn more… | top users | synonyms (1)

0
votes
2answers
67 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
0
votes
0answers
182 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 ...
1
vote
1answer
172 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
1answer
68 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 ...
3
votes
1answer
327 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 ...
0
votes
1answer
167 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?
1
vote
0answers
45 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 ...
3
votes
1answer
300 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 ...
1
vote
1answer
64 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
302 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 ...
1
vote
0answers
101 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 ...
3
votes
4answers
924 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
202 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
1answer
37 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
1answer
285 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
66 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 ...
1
vote
1answer
2k 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
96 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
28 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
72 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
1answer
48 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 ...
1
vote
0answers
266 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
1answer
195 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
157 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
1k 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
176 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
45 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
167 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
1answer
2k 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
243 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
655 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
391 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
77 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 ...
2
votes
2answers
1k 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
54 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
27 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
1answer
2k 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
161 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
58 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
283 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
142 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 ...
2
votes
1answer
2k 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 ...
3
votes
2answers
3k 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
154 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 ...
1
vote
1answer
53 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 ...
1
vote
2answers
676 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
313 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
328 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
61 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
2k 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 ...