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
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
2k 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
1answer
93 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
534 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
4k 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
975 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
2answers
14k views

Set value in lookup field in workflow?

how can I set only the one value to required lookup field, when I create new item in workflow. I tried use workflow variable, ID but I do something still wrong. So I have one list A wiht values AB, ...
2
votes
1answer
390 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
4k 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
2k 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
950 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
5answers
8k views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
2
votes
2answers
963 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
334 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
687 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
2k 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
500 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
41 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
1k 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
173 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
4k 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
915 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
64 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
81 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
661 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
87 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
679 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
728 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 ...
2
votes
2answers
124 views

Am I doing something wrong, or are these common pitfalls or limitations of using lookup lists?

I'm using (and limited to) OOTB Foundation 2010, and have been exploring lookup lists. I am discovering a few things that aren't working the way I'd like, seem to be working inconsistently, and are ...
2
votes
3answers
8k views

Can a SharePoint 2010 lookup column point to a multi-line rich text field from same list

Can a SharePoint 2010 lookup column point to a multi-line rich text field in same list? i dont find multiline column while creating a lookup column. Is there any way to achieve this. Because my ...
2
votes
1answer
634 views

SharePoint 2013, Lookup field cross-Web

It looks like I found pretty annoying bug in SharePoint 2013. Can anyone confirm this? Create site-column lookup to list placed on rootWeb (I will refer to it as WebA), the title should be used as ...
2
votes
1answer
2k views

Issue with lookup column in subsite

I add lookup columns with a elements.xml file and like everyone else I had issues with them once deployed, i.e. "Get information from:" was empty for the lookup list. I found www.n8d.at/blog/lookup-...
2
votes
1answer
1k views

Use count-related column value as int in a SP Designer-workflow

I have another problem concerning the count-related column-value of SP2010 in a workflow(see also: How to get count related Lookup value programmatically? ). my use-case: I have a column "actual ...
2
votes
2answers
3k views

Can text in a lookup column be displayed as text with no link?

SharePoint 2007 and have site curate access only. List-A has a column Name and that is a lookup to List-B, which only has names and no other information. Now when looking at lookup columns in views ...
2
votes
2answers
3k views

Invalid Look up Value . A look up field contains invalid data

I have a multi select Lookup column . I have to populate values to the lookup column from another column on a button click. I achieved it using below code but when i try to click ok/save it is ...

1 2 3 4 5 21