A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
0
votes
1answer
25 views
Lookup Field searchbar
I have this lookup field which is coupled to a customlist of artists.
I use this lookup field as a column for another list. So when someone creates
a listitem in this second list he or she can choose ...
0
votes
1answer
50 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
0answers
39 views
Grouping in lookup multi
I have Lookup field in the list, with multiple choice. On NewForm I have JS code which groups items in 2 listboxes of this field (SelectCandidate and SelectResult).
Problem: I need to group items ...
0
votes
1answer
47 views
List GetRelatedFields() returns field ID that doesn't exists in dependant list
I have got list item exception. [ArgumentException: Invalid Field Name.]
[ArgumentException: Invalid Field Name. {01b89bed-bbe3-4bcb-9b92-c64183ffe135} /Lists/AcceptanceAgreements]
...
1
vote
1answer
270 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 ...
0
votes
0answers
102 views
Filter a CQWP on a Lookup Column
I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
0
votes
1answer
61 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
0answers
124 views
Use JS to add new list item with lookup where multiple items in lookup list have same title
I'm trying to add a new ListItem using the client object model.
Scenario:
List I am adding to has Title, Team (lookup) and Date fields.
The list that contains the teams has Team Name, Department and ...
2
votes
2answers
510 views
access additional lookup fields using JavaScript and CSOM
In visual studio I have added lookup field (SubMenuItemIdRefTitle) to list definition listA that references ListB. I have also added
<ViewFields>
<FieldRef ...
0
votes
1answer
114 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
2answers
134 views
How to call a c# method in my XSL File
I have two lists Client and Project, each Client has from 0 to N Project stocked in his SPLookupField where multi values are allowed. And I created a new computed Column in the Client List where it ...
1
vote
0answers
151 views
Calculated columns supporting all column types
I would like to develop a column which will allow the end user to do the calculations based on values of other columns of the same item (SharePoint 2010). I need it to work also with people, look up ...
3
votes
2answers
982 views
Multiple fields to same list in join (CAML)
Current situation:
=============
In my example, I've got 2 custom lists:
Accounts
Addresses
In the "Accounts"-list I've created 2 lookup columns to the "Addresses"-list
Address1
Address2
When ...
1
vote
1answer
79 views
SPQuery on null lookupfield
I have a contact list with a company lookup field and I need to retrieve those without any company associated
so I was thinking can I put it like this:
<Query>
<OrderBy>
...
1
vote
0answers
137 views
user lookup field for external lists
Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
0
votes
0answers
28 views
Is there any programmatic way to determine if a list has any relationships to other lists?
If list A has a SPFieldLookup to list B is there any thing in list B's SPList object to show the relationship with list A?
While I can flip through list A's fields and find the relationship to List B ...
0
votes
1answer
251 views
lookup external list
I have two tables:
Documents
Project task
What I am looking for is the following:
I have a page with project tasks in a hierarchy list (done)
Clicking on a task will open an edit screen (done)
...
2
votes
2answers
379 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 ...
0
votes
0answers
23 views
Why Does a People Field Return a String by Default?
I recently "cleaned up" a chunk of code that was using SPFieldLookupValues like:
SPFieldLookupValue lookup = new SPFieldLookUpValue(listItem["Field"].ToString());
int itemID = lookup.LookupId;
string ...
0
votes
1answer
84 views
Can I edit a LOOKUP column?
More concisely: How do I edit a lookup column?
I have a custom list with columns [Name] and [Product] named
'MainList'. I would like a third column [Referral] which shows a name
found in ...
1
vote
0answers
98 views
Filtering LookupMulti by FilterMultiValue SP2010
I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment
FilterName=Tags&FilterMultiValue=Flower;Sword
Three is nothing, apart correlation ID. I found in ...
1
vote
1answer
166 views
How to add values from a multi-valued field from a list using SPD's Update an Item Action
I have a workflow that automatically updates the value of a multi-valued field in an item.
This workflow is working as expected. BUT, when that field/column of an item has a value already, the current ...
0
votes
2answers
715 views
Is it possible to make a lookup column that looks up “Person or Group” type from another list?
I'd like to create a lookup column in my list (hopefully using OOTB functionality) that shows a column from another list. Sounds simple enough, but the available columns to choose to lookup from my ...
1
vote
1answer
461 views
How to get users/usergroups from an lookup column from SPField
I have a custom list for example "MyCustomListA"
I have created a custom ListForm template and overide the ListFieldIterator. I have overide the ListFieldIterator and CreateChildControls to implement ...
0
votes
3answers
3k views
Lookup column to Documents library
Here's what I need to do for a SharePoint 2010 list: Allow users to select the filename from a dropdown showing the items in the Documents library. But the "Add new item" form of the list doesn't show ...
3
votes
4answers
3k views
Why is my column not shown under “Add a column to show each of these additional fields”?
In SP2010,
I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional ...
1
vote
2answers
1k views
Modify existing lookup type column to managed metadata type
We are in process of migrating one of our big website which is built in WSS 3.0 to SharePoint 2010 Standard version.
In the process we want to convert all lookup columns to managed metadata type. We ...
0
votes
2answers
63 views
Sorting out lookup values while getting them
I have two lists,
List A [Document Number, Name, Title,...] (document library)
List B [Information Number, Name, Title, Document Number] (simple list)
Now List B is getting all documents from List ...
0
votes
1answer
24 views
Checking if a list is consuming lookup value column or not
I have two lists,
List A [Document Number, Name, Title,...] (document library)
List B [Information Number, Name, Title, Document Number] (simple list)
Now List B is getting all documents from List ...
1
vote
1answer
476 views
Updating SharePoint List with Linked Access Database - New List Created Instead of Updating Old List
When you've linked an Access Database to SharePoint lists, how do you make sure that saving the database updates the existing list instead of creating a new one, so that lookup columns pull from the ...
0
votes
0answers
72 views
multiple column lists and lookup controls
I've created a List that has two columns a title (MyTitle) and a value (MyTitle), in my page I have a Lookup SharePoint Web Control that is currently just displaying the title, how can I set the ...
3
votes
2answers
2k views
How to display lookup additional field in display form?
I have two lists: Projects and Tasks
In the Tasks list, I have created a lookup field titled ProjectID which targets ID filed from the Projects list. Also, I have set for this field to display an ...
0
votes
2answers
232 views
Calculated Formula Insert From Another List
I have List A which has all information.
List B has Col 1 that looks up one of the List A's columns. Col 2 is a Calculated column that want to use Col 1 but SharePoint is not able to see Col 1 ...
1
vote
2answers
211 views
Allow Fill-in For Lookup Columns
Is it possible to enable Allow Fill-in option for Lookup type columns, like Choice type columns.
2
votes
1answer
395 views
SharePoint2010 Lookup Column Display issue
I have a simple list with three lookup columns in it. One LC has 5 items and displays as simple dropdown and there are no rendering issues (So ignore this column now). The other two columns has more ...
1
vote
2answers
212 views
Matching value from single line of text column to lookup column
I have a library containing a large amount of items.
The library contains a column of type 'Single line of text' with a code in it. The code was taken from an external system and entered manually.
...
1
vote
2answers
277 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 ...
0
votes
1answer
120 views
How to access User Information Columns in a Workflow
I need to access a custom column of User Information List in a work flow.
I've create a new column named MyCol in User Information List and now in a workflow I want to access to in when I lookup ...
0
votes
0answers
1k views
How to use CAML IN clause with MultiLookup field? [closed]
After making a long research I'd like to share the solution for executing a CAML query using IN operator dynamically based on a multi lookup field by workflow without any additional coding. Generally ...
0
votes
1answer
130 views
Using additional fields from Lookup in Word Document Information Panel
I have a Document Library in which I have a lookup columns to a Contact list, the contact list also includes linked values as email, phone numbers and so on.
When creating a new word document in ...
2
votes
1answer
152 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 ...
3
votes
2answers
530 views
Deactivate the link of lookup-fields! (2010)
On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen.
Of ...
1
vote
2answers
526 views
What columns count as lookup column concerning the “List View Lookup threshold”
I got the following entry in my SharePoint 2010 log file:
"Some lookup fields were omitted from the query results because the list exceeds the lookup column threshold."
I checked the setting (Central ...
1
vote
0answers
116 views
FilterMultiValue on additional lookup column Skill:ID
I try to filter my sharepoint list based on some filters. Because the checkbox option "Allow Multiple Selections" does not work I am trying to build some own implementation using the QueryFilter ...
4
votes
3answers
600 views
Replace semicolon delimiter in a Lookup column on the list view
When selecting multiple values, the data is separated with semicolons. When many values are selected it starts looking cluttered.
Is there any way to have each value on a new line?
For example, ...
0
votes
1answer
49 views
Is Multiple Lookup API's supported JavaScript
Is Multiple Lookup API's supported JavaScript language?
I need to create a new column, retrieve data from multi-lookup using JavaScript API's
not sure if it's supported.
2
votes
3answers
659 views
Sharepoint2010 Lists Lookup
I'm creating 3 lists using Sharepoint 2010 UI.
The lists and relationship are as follows:
Training (parent) -> Training Instance (child, look up Training ) -> Training Session (grandchild,lookup ...
2
votes
1answer
601 views
REST: unable to retrieve lookup data from top level
At the top level of my site collection, I have created a list called "Markets", and a site column called "Market", defined as a lookup to the Markets list.
In a subsite of this same site collection, ...
0
votes
2answers
170 views
Accessing LookupFieldValue throws error
I have a lookup field on a list (header) that looks up values on the same list. I am trying to read the value out of that lookup with this code:
using (SPSite site = new SPSite (mySite.ID))
{
...
0
votes
1answer
473 views
How to get count related Lookup value programmatically?
Another day, another question ;)
So, I have two custom Lists, "Attendees" and "Events". In the Events-List there's a Lookupfield "Registrations" which I want to fill programmatically on page_load. In ...
