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.
395
questions with no upvoted or accepted answers
0
votes
1answer
752 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
1answer
69 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
136 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
1k 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
1answer
335 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 ...
0
votes
2answers
757 views
Columns not displaying value
I've added some columns (name, ID etc ) to the document library after the documents have been uploaded, and got no value displayed.
Is there any way to fix this or I'll have to recreate the library?
0
votes
2answers
75 views
Lookup in SharePoint
I'm using Sharepoint 2010.
I have a List "Discipline" with 3 columns
Discipline Code Discipline Des.-Site 1 Discipline Des.-Site 2
A A1 ...
0
votes
1answer
1k views
copy one column value to another column in a list
I have a list named ABC in MOSS 2007
List has
2 Views (All Details and Multi Location)
2 columns (BA-tech and BA for both views)
BA- tech field is "Single line of text" type and BA field is "Look up"...
0
votes
1answer
626 views
How do I lookup string value from another list?
I'm having trouble using a "Lookup" type field to lookup values from another list.
I have two lists.
'Invoices' list shows all the invoices' being entered by colleagues with all the general ...
0
votes
1answer
661 views
How to submit multi-checkbox items in a formatted string to SharePoint lookup column
I'm new to InfoPath and SharePoint and i also use the trial version of qRules, i have 2 sharepoint lists, with one (let's call it "list1") having a lookup column to the second ("list2"), and this ...
0
votes
1answer
116 views
New list column is not displaying in dropdown list when creating a lookup column
I have an existing list called Employees and I have added a new column "Company". I would like to create a lookup column using Company but Company is not displaying as an option in the dropdown list ...
0
votes
1answer
213 views
Lookup list filter only future events
I have a task list that assigns tasks to specific future events. The custom task has a lookup column that is based on an events calendar. Is there any way I can cleanup this lookup list to only show ...
0
votes
0answers
73 views
Cross site lookup columns
If I have site structure as per the below:
Site Collection
-Main Site
-Site 1
-SS 1.1
-SS 1.2
-Site 2
-SS 2.1
-SS 2.2
If I have a list in SS 1.1 is there any way in which I can create a ...
0
votes
1answer
511 views
Send Email using Lookups from Workflows (SharePoint 2010)
I'm currently using SharePoint 2010 Designer, and the 2010 version of SharePoint.
So I'm currently designing a SharePoint application which can assign tasks to other employees. Any tasks assigned ...
0
votes
1answer
142 views
List provision order on deployment
I have a generic list with just title fields. I'm trying to have another list use a lookup column to list each item. If I add the lookup to second list after deployment it works. But if I simply ...
0
votes
0answers
1k views
SPServices.SPCascadeDropdowns - Display Title rather than key
I'm using SPCascadeDropdowns to filter a child drop down which is working. However, I would like to display another column than the one in the relationship.
I have created two lookup columns that '...
0
votes
1answer
73 views
How to show/Hide Data in dropDown field in a list depending on other list boolean field
I have two lists; Cars{brand,color,price} and Colors{designation,disponibility}.
I made the field color as a lookup field to display colors from colors list.
My problem is that i ONLY want just to ...
0
votes
0answers
340 views
Look up field shows [object Object] on view
My list is custom code, which has a look up field to another list on same site.
But when I create items, this field displayed as [object Object] on view (in display form, it still displays normally).
...
0
votes
0answers
29 views
WP connection, lookup in children causes unexpected error when in view
I have the following scenario:
MainList / ChildrenList {MainList:ID lookup column, ThirdList:ID lookup column}
In the MainList display item form:
WP#1: MainList with columns {ID, Title, Description}...
0
votes
1answer
733 views
How Do I Format A SharePoint 2010 Search Refiner Lookup
In SharePoint 2010 Search, I've added a new managed property that refers to a lookup column. I then added a custom refiner by modifying the Refinement Panel "Filter Category Definition". Basically, I ...
0
votes
1answer
442 views
Sharepoint 2010 site definition and Lookup column
I have created a custom list definition with a lookup field using Visual Studio. Everything is working perfect.
After that I created a site definition using Visual Studio and added this custom list ...
0
votes
1answer
625 views
Lookup items says “Count Related”
I am not very skilled with SharePoint, but I have been tasked with using it on a daily basis, and am always at least "trying" to make improvements to it. The issue I am having today is that I have 2 ...
0
votes
1answer
563 views
Is it possible to create an automatic connection between the look up field and another column?
Im struggling with a problem in SharePoint 2013.
I have one list with procedure codes, which includes the āprocedure codeā plus some other fields
In another table, i have volume data related to ...
0
votes
0answers
112 views
Load a SharePoint list into a workflow variable?
I am trying to use a workflow to lookup data in a column in a list and then compare that data in another library column then update another column in the library based on if it equals eachother.
...
0
votes
0answers
156 views
Workflow to Update Library Column with Data from List
When creating a new item within the library I want a workflow to lookup a field in a list and if it equals a column in my library I want to update another column in my library. The field I need to ...
0
votes
0answers
287 views
Get Items Lookup Mult timeout
I have a list with many records , and when I'm doing a filter for a column that is Lookup Multiple runs smoothly :
Example
<Where>
<Eq>
<FieldRef Name='Column' LookupId='TRUE'...
0
votes
1answer
36 views
Start and assign an approval task to all users in the given department(s)
I have a form containing a multi-select "Departments" column. I would like the user to be able to check off which departments the list pertains to, so that when the list is submitted for approval, all ...
0
votes
1answer
78 views
Is there a way to get a set of 'child list' in sharepoint; i.e., lists that contains a lookup field to a given list?
This is what I have so far. It seems to work, but is very slow since its traversing all lists and fields in the site. Note: I am looking for the first list that shows up as a 'child list':
private ...
0
votes
1answer
500 views
Prefill the input boxes of a list based upon lookup
I had a list say company that contains columns like CompanyName.
Then another list called as Addresses contains a lookup to conmpany and additional columns like Street, City
What i need to do is to ...
0
votes
1answer
40 views
How to set value to fields of List item getting values from the folder that it is in?
I have some folders with some properties(Name of project, Project Number and etc.) When I create a item inside of this folder I need to fill out these information again for the item.
I would like to ...
0
votes
1answer
356 views
Specify Lookup list for the 'Title' Column of a Gantt chart view
I was hoping to use a lookup list as the title column for a Gantt chart view. The problem is when I go to the Gantt columns in the settings for the view it doesn't display any of the lookup list ...
0
votes
0answers
790 views
Values missing for dependent lookup column from parent list when using linq
Situation
I have 2 site content types defined that are deployed as a site feature:
Customer
Name
Address
Order
Value
There is a second web feature that deploys a list to the root site for ...
0
votes
1answer
57 views
Menu control in sharepoint
Is it possible to have a top menu in sharepoint like when i click on the tab it should provide me a mega menu.Is it possible through OOB of sharepoint..please share your ideas..
0
votes
1answer
188 views
How do i declare array for the lookup column using jquery
How do i declare array for the lookup column using jquery. I have a column whose values should be declared as array. so that my requirements get it complete.
I need that ID for every values to get ...
0
votes
1answer
870 views
Access Lookup to Linked List
I am trying to create a lookup from one Access table to a linked list from SharePoint. I need to have a lookup between the two because in order to create the type of subform that I need, there has to ...
0
votes
1answer
277 views
Lookup fields blank after dialogue
I have a problem on a SharePoint 2010 site. I have lists which contain Lookup fields.
When I perform any action on the site that causes a custom dialogue to be displayed, the lookup fields become ...
0
votes
1answer
100 views
Cross site cross database lookup field SP2010
SiteCollection 1 in ContentDB 1 has List 1 with custom lookup field.
This lookup field returns all text fields from any selected list in a site collection specified. Each site collection is in a ...
0
votes
1answer
37 views
quick way to access splistitem in different list?
I have 2 lists: listA and listB
listA has 2 fields:
Title (text)
PortalID (text)
listB has 3 fields:
Title (text),
listAField(lookup to listA Title field)
UserID (text)
I have a UserID value and ...
0
votes
1answer
835 views
Restricting number of selections on a multiple lookup column
How can I restrict the number of values a user can select from a lookup column? It doesn't seem to have the same column validation settings as some of the other column types.
I only want a user to be ...
0
votes
1answer
114 views
Possible to lookup a Sharepoint list in Access?
I am trying to make a very large list of records with about 1,000 items or more added monthly, and I was told that it would be better to use an Access table instead of a Sharepoint list for so many ...
0
votes
1answer
578 views
Adding the other fields in addtional to lookup field in CAML
I have a custom field definition in VS2010 that contains a lookup field (Title). All is well and I can use the Title ref to add items in the SharePoint list UI. in the instance UI, I can also check ...
0
votes
0answers
382 views
“Linked Item” Lookup available in browser by not SPD2010?
When I create a Lookup site column in the Browser, this enables me to choose "linked to item"...which then means it pulls back all the related information.
However, if I do the same in SPD 2010, ...
0
votes
0answers
2k views
Lookup multiple-values on form-library sharepoint 2010 for InfoPath Form
I use InfoPath form template for a form library without coding. I want to get multiple-value of lookup to another list items. For lookup I should use sharepoint 2010 column due to no such data type in ...
0
votes
0answers
288 views
How to retain permissions for a user in Lookup field?
I have column level permission using a custom code. But I am unable to retain permissions for a user in Lookup field! Is there a way to do it?
0
votes
1answer
34 views
Content Types Template problem with lookup column in template
I have a content type. When I want to create a new document from that content type the properties (Columns) for that content type also open in my document.
The problem is that there is one lookup ...