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

learn more… | top users | synonyms (1)

1
vote
1answer
89 views

Example of a workflow pulling lookup column data for use in a calculated value column

I'm looking for an example of a workflow using SharePoint Designer 2010 that pulls information from a lookup list or via a lookup column and places it within a hidden field for use in a calculated ...
3
votes
1answer
2k views

Help with getting the value of a look up field

Currently, I am using an ajax request to access the list items. The fields that are not lookups come as expected but the lookup fields come across as an ID of the object that corresponds to its ...
2
votes
0answers
114 views

Sorting a Lookup Column from Survey that pulls from Calculated Field SP 2010

I'm looking for a way to sort a Lookup question in a survey that pulls from a calculated field. Specifically, I have it lookup a calculated field that combines the date and name from a list. I want ...
5
votes
3answers
2k views

BCS External Content Type with 20,000+ items (O365)

We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
2
votes
1answer
409 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
5answers
2k views

Cascading Dropdown

I am new to SharePoint 2013. What I need to figure out is based on the following situation. I have several school districts with multiple schools within the school district. I would like to create a ...
1
vote
0answers
18 views

Display deactivated items in lookup column

We have a list of projects. One column is named Status (a choise Active or Finished) One column is Active Projects (a calculated column which shows only the actieve projects) One column is named ...
1
vote
1answer
2k 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?
0
votes
1answer
81 views

Calculated Lookup from another Lookup

I'm sure this has probably come up before but I'm getting nowhere fast so I thought I'd ask the question! I have a list called Areas, which has an Area column (text). I have a second list called ...
0
votes
1answer
1k views

Add new item to child list and refresh the parent form - multiple lookup

I've created a parent list (Vendors) and a child list (software list). There can be multiple vendors for one piece of software. I've created a custom new form with a link which opens up a modal to add ...
1
vote
3answers
888 views

Get value of lookup field

I have a cascading lookup using two lists on my SharePoint 2010 site. I want to get the value of first selection made in the lookup and show/hide other fields on my custom form based on that first ...
1
vote
0answers
345 views

Site Lookup Column As Managed Property

Please let me know if my logic here is incorrect or suggest better alternative. This is hosted on Office 365. I have a Site Lookup column (EventLookup) that is linked to a list on my Root Site --> ...
2
votes
1answer
348 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 ...
1
vote
2answers
241 views

Save Document library lookup field using Rest API

How can I save document library lookup field using REST API Post in a SharePoint list? I tried like 'docItem':'1;#test' But, it is throwing an error : {"error":{"code":"-1, ...
2
votes
1answer
248 views

Lookup field doesn't support some field types

Its looking more and more like you can't add additional fields that are anything other than string boxes (no person or yes/no etc) is there any work around for this?
1
vote
2answers
513 views

add a new value to a lookup field

I have a custom list in SharePoint 2013. This list contains text and lookup fields. While I do not have an issue populating the text fields, the lookups are giving me trouble. I found and tried ...
0
votes
1answer
3k views

Coercion Failed: Can't get workflow to send notification to “Assigned To” user

I've created a simple workflow to send a notification email to the "Created By" user which works nicely. What I wanted to do is use the "Assigned To" built-in lookup instead, which is a "People ...
0
votes
1answer
341 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
0
votes
0answers
71 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. ...
1
vote
0answers
134 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
1
vote
0answers
211 views

Sharepoint 2013 - Add lookup column to key filters

I've got a document library of invoices. It has various columns (mainly choices) such as, Year, Status, Location, etc. and I've been able to add them to metadata navigation as key filters. However, ...
2
votes
2answers
1k views

infopath form not updating fields

I have an infopath form that has three read-only fields referencing items in another list, but when someone opens the form the values never change, even if they have changed in the other list. It ...
0
votes
0answers
62 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 ...
1
vote
1answer
433 views

InfoPath form referencing fields from another list

Environment: SP2013 Enterprise, InfoPath 2013 I'm building a course registration system for a SP client but am having a little difficulty with lookup fields. Basically there are two lists, a course ...
2
votes
0answers
199 views

Getting distinct/unical values from External List

I have got an External List. I want to get distinct values from this External list to the dropdownlist getting from lookup Field. The values are often repeated. How can I get distinct values from ...
0
votes
1answer
279 views

What is use of LookupMulti in Sharepoint 2013

Can somebody tell me what is the use of LookupMulti in Sharepoint 2013 and how to implement this with visual studio 2012? Can we use this for chaining purpose ? For example, I have 2 lists country ...
0
votes
0answers
153 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' ...
0
votes
1answer
183 views

Filtered Lookup Field for more then one element

How could I do filtered lookup field for more then one element? I make for one Element by this link: http://howididit-sharepoint.blogspot.com/2012/04/filtering-lookup-columns.html But how could I ...
1
vote
1answer
3k views

Create lookup item with workflow

I have to create an item at the end of my workflow. The list that will contain the item has a lookup column... So I'm using the option : "Create item" and setting the values one by one. But how can I ...
7
votes
3answers
249 views

Working around the “Lookup column threshhold”

To level-set, I'm working in a large enterprise with no Farm Admin access or access to SP Designer. I have out-of-the-box capabilities only as owner of a team site. I'm building a roster/schedule ...
0
votes
1answer
323 views

Lookup field with formatted text

I've created several lookup fields programmatically in existing lists, currently they render with just one field as the text value, however I'd like them to display the contents of two text fields ...
1
vote
0answers
148 views

Count number of references in a multi-value lookup column

I'm using SharePoint Online, and I have one list of meetings, and one list of people. Meeting has a multi-value lookup column of people, so that several people can be added to a meeting. How would I ...
0
votes
1answer
474 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
2
votes
2answers
1k views

SP 2013 - Updating a multi-value lookup field via the REST API

When adding a new item to list via the Sharepoint 2013 REST API I want to populate one of its multi-value lookup columns. I've tried passing in an array of Ids or a string with separators but nothing ...
1
vote
1answer
1k views

SP2010 Search: Managed Property on lookup column returns “ID” instead of “Title”

I've got a document library named "Documentation" and a user defined list named "Suppliers". "Documentation" has a lookup column linked to "Suppliers": WAWI(text) -> linked to "Suppliers:Title" ...
0
votes
1answer
34 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
212 views

get an error while exporting access database to sharepoint 2007 lists: lookup contains values that do not exist in the related table

I try to export a table in a access database to sharepoint 2007. All related tables are automatic exported to SharePoint as lists. SharePoint creates lookup fields for each relation. Under the export ...
0
votes
1answer
59 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
85 views

Moving SharePoint 2007 Lists/Lookups between subsites within same site collection

We have a list 'Leaders' that we want to move from one subsite (A) to subsite (B) that is in the same site collection. I had gone into 'Site Actions' -> 'Site Settings'-> 'Modify All Site Settings' -> ...
0
votes
1answer
221 views

Set lookupfield value on document upload through event receiver

I have a custom list, where when I create a new item, I assign a custom id to that element through an event receiver. After the item is created, I create a file that I upload to a document library. ...
0
votes
1answer
86 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
2k views

Cross-site and SPFieldLookup

I've read a numbered time that SPFieldLookup is cross-site by its nature. But now I'm a little bit confused, here is my SharePoint structure: /SiteCollection /Site1 Projects /Site2 Customers ...
0
votes
1answer
36 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
469 views

linq query for lookup list column error - query uses unsupported elements

I'm trying to return the list item ID (s.ID), and the ID of a lookup column (s.VendorID). I get the following error: The query uses unsupported elements, such as references to more than one list, ...
0
votes
3answers
289 views

How to design look up list for 20 sub-sites?

Say, I have 20 sub-sites under corporate sales. There are 3 lists that drives the look up columns. Country (USA, Mexico, Norway, Morocco, etc.) Regions (SW, NW, S, W, N, MW, etc) SalesArea (Service; ...
1
vote
2answers
533 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 ...
0
votes
1answer
149 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
1answer
683 views

SharePoint 2013 Search - Return Results Based on Lookup Column Value

We have a page on a public website where we're surfacing a list of Staff which is stored in a "Catalog". The staff catalog has a lookup column pointing at a Department catalog. The Lookup is joining ...
0
votes
0answers
391 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
49 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..