Questions tagged [lookup-column]

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

Filter by
Sorted by
Tagged with
2
votes
5answers
15k 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 ...
2
votes
2answers
396 views

Lookup List and return data from within a Form

OK, I'm beginning to despair at SharePoint...please help restore some faith :) Seems some very basic things are very hard to achieve? 1: I have data in an SQL database table. 78,000 rows, but I want ...
2
votes
1answer
7k views

Using an Additional Lookup Column Value in a Calculated Column

I have a lookup column based on another list's description (a 'Category' list) and have ticked the other list's 'Category ID' column to be shown at the same time (I note that this is a manually '...
2
votes
3answers
760 views

Department lookup from User Profiles - SharePoint 2007

We have some 30,000 user profiles . We'd like to build a custom list with lookup for Department from a unique list of departments in our User profiles. Possible? Was thinking of buildin a new ...
2
votes
3answers
313 views

Managing multiple related lists and lookups in SharePoint 2007

I have a custom solution, which has multiple related lists. Four of the Lists have a lookup field based on the field of one list. And, that list has a lookup based on the field of another list. So, ...
2
votes
1answer
2k views

Validate a date column against a lookupfields additional column

In a list you can create a lookup column which queries data from an other list, the fun part is that you can add "additional columns" which results in some sort of ghost column which is added to the ...
2
votes
1answer
2k views

Calculating on Lookup column without the use of SharePoint Designer?

Trying to find a way to join values in two separate columns into a third however one of these is a lookup field to a second list and as I understand you cannot do calculations on lookups without using ...
2
votes
1answer
1k views

“Enforce relationship behavior” for my lookup column will be missing, if the Target lookup list and the current list are not on the same web

I am facing this scenario inside my SharePoint server 2013 & sharepoint server 2016. and i am not sure if there is a way to get it fix. i have a site collection of type team site. i added a list ...
2
votes
1answer
3k views

Crawl Properties & Managed Properties for my lookup site column's Title. why this is not being managed automatically

I am working on 2 lists inside my sharepoint enterprise server 2013. the list are:- Departments Project where the Project list have a lookup field (named ProjectDepartment) to the Department list , ...
2
votes
2answers
2k views

Workflow: Create List Item String to Lookup

Hi I am using SharePoint Online. I am trying to create a list item (list is called Tasks) in SPD workflow. I am trying to set a lookup column in the Tasks list using a calculated column (string value) ...
2
votes
1answer
95 views

Moving list with contents from root site to sub-site does not keep the information of the lookup fields [duplicate]

I have tried the following steps to move a list from root site to subsite. Go to list Setting > Save List as a template and include the contents At sub-site > Add app > create a list from this ...
2
votes
3answers
628 views

Number of Column Look Ups effect on performance

We have a scenario where we need to have many columns inside a library, for which the drop-down values will be retrieved using look-ups from several lists. As we know there is a default threshold set ...
2
votes
2answers
5k views

Retrieve lookup field value using REST API

In my SharePoint site, I have another subsite. On the top level site, there is a list to store 'document type'. Within the subsite, I have a document library which lookup the 'document type' list. I ...
2
votes
1answer
1k views

How to get parentlist of a lookup column in CSOM

What I want is this using (Web web = lookup.ParentList.ParentWeb.Site.OpenWeb(lookup.LookupWebId)) { List list = lookup.r.LookupWebId.LookupList; Field ...
2
votes
1answer
409 views

Multiple Choice Columns-Checkboxes. Is there a different format?

I have a column which uses a lookup to another library. I need the user to be able to make multiple selections based on this lookup, however the problem I have is that this library contains hundreds ...
2
votes
1answer
5k views

SharePoint Online: How to configure search to enable refiners on a lookup column

I have a list of location names at the root of a site collection. I have a site column at the site collection level that is a lookup to the locations list. In sub sites I use the site column in ...
2
votes
1answer
3k views

Workflow error: The value 'Value' cannot be read as type 'Int32'

I've a list named APE - Opções with this values: Título | Nota Nunca | 1 Algumas vezes | 2 Frequente | 3 Sempre | 4 N/A | 0 And a list ...
2
votes
2answers
985 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
1k 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 ...
2
votes
2answers
1k views

Save Site as Template (with include content) does not accept LookUpSite Columns

After long search on the web i could not figure out why i have been facing wired behaviour today with my SharePoint Site. I explain, I have a Site Collection (Blank Site Template) which contains ...
2
votes
1answer
2k views

More than one user not getting email alerts (SharePoint 2010)

I'm using SharePoint Designer 2010, and I'm creating an application which assigns tasks to other people. In the application, whenever a person is assigned a task, that particular person (or group of ...
2
votes
1answer
338 views

How does the look up function work?

I currently have two lists: List #1 have the fields country and colour (and several other fields that are irrelevant) List #2 have the field colour (and several other fields that are irrelevant) So ...
2
votes
1answer
2k views

SharePoint 2013 - Reverse Lookup

I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are ...
2
votes
2answers
6k views

How to Find Lookup field list using Programmatically

How to find the list that a particular lookup column in a list is bound to, programatically?
2
votes
1answer
710 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 between "...
2
votes
2answers
3k 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 ...
2
votes
2answers
1k views

SharePoint 2010 NewForm.aspx Lookup Fields Issue

I have a SharePoint 2010 Foundation site that has recently been upgraded from WSS 3.0. The upgrade was completed successfully with no glitches. However, ever since I have upgraded the site I have ...
2
votes
2answers
2k views

Cascading Dropdown for Lookup with more than 20 items

I have implemented cascading dropdown using SPCascadingDropdown (SPServices) it was working for lookup with 19 items . When the items count became more than 20 , the lookup column is displayed as ...
2
votes
2answers
3k views

Copy lookup value from one list to another with SPD workflow

I have two lists and a workflow that copies items from list A, if they get approved, to list B. Problem is that a field in list A uses a lookup list, if I select Dog in the Field Animal and save the ...
2
votes
2answers
503 views

Chart Web Part and lookup fields

How can I make my Chart Web Part look good when I use it with lookup fields? The issue I have is that the chart displays the field id along with its value. For example, it displays "2;#Bing" when I'd ...
2
votes
1answer
1k views

Lookup site column not saving/storing metadata for Office 2007 documents?

I'm having this issue on several server environments. We have a list at the site collection root. There is a site column created as a multi-value lookup on that list's Title field. This site column ...
2
votes
1answer
47 views

metadata error SP.FieldLookup

Arigato is a lookup field. I would like to change its value. I got error with FieldLookup. Can you help me?
2
votes
1answer
2k views

column formatting with json for lookup fields

I have problems formatting the column of a lookup field with json. Precisely, it is an additional field, displayed from the parent list that I want to format. The lookup field is of type multiple, so ...
2
votes
1answer
253 views

restore sharepoint list lookup value

I have simple Sharepoint list named Alist with lookup value column. the lookup value column returns fields from other list named Blist. accidentally I have deleted this Blist and in Alist all lookup ...
2
votes
1answer
5k views

How to update the SharePoint list form access?

I have a SharePoint list with Lookup columns and metadata(Content type) fields. I opened the list in Access When I was trying to add new data or edit the data it's saying "can not update database ...
2
votes
2answers
1k views

REST - how to get item ID and document name while filtering by a Lookup field?

I am trying to query a document library via REST and get the item ID and the document name. The query needs to filter on a (single value) lookup field. Originally I was using a CAML query to do the ...
2
votes
1answer
2k views

Query data from SharePoint list

I have an "Employee" list which contains username and employee no. and there is another list which contains a column that lookups employee no. in Employee list. The issue is that I want to show only ...
2
votes
3answers
65 views

List Lookup Column - Select Library

I would like to add a lookup column in a SP list, which allows the user to select a specific library (rather than an item within that library). Is this possible? Many thanks
2
votes
3answers
2k views

How to change the output of a Multi-value Lookup column in a View?

Could I edit the way the Lookup column displays information, if possible without code? (Or an easy explanation as to how to do it?). Currently it is displaying as "Name; Name; Name; Name". I would ...
2
votes
1answer
88 views

Can Lookup Column be displayed?

I use Cross-site publishing in SP13, create a authoring site and a intranet(display site.) I have created a list of content including a lookup column for contact person; look up from another Contact ...
2
votes
1answer
83 views

SharePoint List CreateBy column storing date value

we discovered some very strange behavior in a list. within the last couple weeks, the Created By column for all items was replaced by a date: 35;#2014-12-23 23:17:51 I got this using powershell, ...
2
votes
1answer
2k views

Displaying multiple column data in a drop down menu

I'm using SP2010 unfortunately without SP Designer and only used InfoPath once. I have 2 lists: List A - Is a list of 'Event Codes' with a 'status' column displaying Active, Used or Reserved ...
2
votes
1answer
768 views

Access lookup Site column from subsite

Is it possible to create a lookup site column at root site and access it from its subsite? I created it using site column template at root site and it was accessible at root site when added it to a ...
2
votes
1answer
94 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 ...
2
votes
1answer
1k 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" ...
2
votes
1answer
694 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 practice....
2
votes
1answer
1k views

SharePoint 2013 lookups with more than 20 items as select or input?

So I was reading about doing some JavaScript to manipulate the default forms for our lists and came across this: http://geekswithblogs.net/SoYouKnow/archive/2011/04/06/setting-sharepoint-drop-down-...
2
votes
1answer
2k 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 ...
2
votes
2answers
801 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 ...
2
votes
1answer
4k views

Uploading a file to a library with curl - how do you also update the column values

I'm able to upload files from linux to sharepoint using something like this curl -u "Domain\Account":'Password' --ntlm -k -T report.xls https://portal.company.com/test_site/test_doc/ I would ...

1 2 3
4
5
21