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
789 views

set or update multiple values cascading lookup field using client object model

I'm struggling since a couple of weeks with setting a multiple values cascading lookup field using a client object model, I could set the first value but then It show me an error of invalid lookup ...
2
votes
1answer
836 views

In a DVWP my Multilookup column is not returning IDs, only column values

I've added a DVWP to a page. The DVWP shows data from a list with a multi value lookup column. The value returned for this column is in the form: value1;value2;value3. Now I want to render this ...
2
votes
3answers
1k views

Binding lookup fields to document library template

I have features that define site content types and a document library template that uses these content types. Now, when I create a document library from the template, all the content types appear ...
2
votes
1answer
69 views

How to update a SharePoint Multi-value Lookup Column using a PowerApps Combobox?

I have a primary SharePoint list which is connected to a customised PowerApps form for data entry. Inside this form, I have added an additional multi-select Combo-box, which displays values from a ...
2
votes
0answers
149 views

Large Dropdown Lookup with Autocomplete

Wondering if anyone can point me in the right direction. Requirement is a drop-down field in a SharePoint Online list that references a customer table in SharePoint Online. Of course, the customer ...
2
votes
1answer
312 views

Lookup columns not visible in designer workflow

I have a massive 2013 list workflow build to handle projects on the SP Online platform. This workflow utilises a few lookup columns and people fields - but no more than 5! For some strange reason I ...
2
votes
1answer
59 views

How to set MultiLookupField in Workflow 2013 [duplicate]

I'm working on SharePoint 2016 OnPremise, Workflow 2013 and I'm trying to set a MultiLookupField with one ore more values. I tryied to set 1;#2;#3;#4 and 1;#;#2;#;#3;#;#4, or for one single item 1;#;# ...
2
votes
0answers
196 views

Filtered lookup based on lookup

My situation is this: I'm trying to set up a review site for the publishing house I'm working for. Basically, the editors should be able to pick reviewers for new books based on certain categories. ...
2
votes
0answers
109 views

Link to related documents in another list

I have two sharepoint lists. List 1 has a list of projects and includes a geolocation column. This allows me to view the projects on a map. List 2 is a document library where up to 3 documents are ...
2
votes
1answer
1k views

Changing the sort order in a lookup field

I'm in an Office 365 SharePoint environment using a custom list. I have a lookup field that displays the title of courses. I'd like to sort it by the date of the course, but it sorts only ...
2
votes
1answer
399 views

Sharepoint REST API empty value on expanded lookup columns causes error

I have a list with lookup columns. When I get an item from the list and expand the lookup columns, I get an error if any of the lookup column values are empty. For example if I have a list with the ...
2
votes
0answers
178 views

How to get the attachment files of an expanded lookup column

I am trying to get the attachments from a lookup column. A loose example: ListA has a column LookupColumnName and I am trying to do something like this: _api/web/lists/GetByTitle('ListA')/Items? $...
2
votes
0answers
64 views

Solution deployed to a web application errors when not using FQDN

EDIT: using SP2010, with Enterprise and Publishing features enabled at the WebApp and site where intend to use the feature. We have a 3rd party solution (Lookup with Picker [ilovesharpoint.fields....
2
votes
0answers
709 views

Online - Filter the options of a lookup column

I'm using SharePoint Online. In the "Contact" list have a calculated column with this formula: IF([Active],[Last Name]&" "&[First Name],"") This formula is working fine. In another list I ...
2
votes
0answers
123 views

Selecting nullable property of an expanded object

Symptoms I have a list, call it Questions, that has a multi-lookup to another list, call it Answers. To get a single question by Id with its Answers, my query would look something like this... $...
2
votes
0answers
499 views

Display Template lookup column additional fields

I have a search based solution where I work alot with Display Templates to render out results in a fancy way. It all works fine and dandy with Managed Properties mapped up etc. However, I've come ...
2
votes
2answers
4k views

List lookup to list column in other Site Collection

I have an existing SharePoint custom list with various columns. I require an additional column that is a lookup to a list in another site collection which I'm aware is not possible OOTB. How can I ...
2
votes
0answers
196 views

How to get lookup field in Search REST API? [duplicate]

How to retrieve the lookupId or lookupvalue in Search REST API results with other fields. http://server/_api/search/query?querytext='sharepoint'&selectproperties='Title,Age'
2
votes
0answers
265 views

SharePoint Designer Workflow create new item with lookup to current item

I have two lists, "customers" and "expense Sheets". The list "expense sheets" has a lookup column "related customer" to the "title" field of the "customer" list. I am trying to create a workflow for ...
2
votes
0answers
125 views

Filtering Lookup Column By Expiration Date [duplicate]

Scenario: I have created a lookup column with two columns. A department column and Expiration Date column. Each Department has a Expiration Date. For example see the image. When the Department ...
2
votes
1answer
2k views

If [LookUp] equals [String] doesn't always work. Sometimes I have to use [1;#String] instead, why?

I am using SharePoint Designer 2010. I created a workflow in which I needed to test the value of a lookup column. I (perhaps naively) simply tested if the lookup column equals the literal string I ...
2
votes
1answer
88 views

Library upload form Dropdown options order

I have a library to store files (obvious) with column "City" which is a lookup to list with two columns (CityName & Order). How to change ordering of options in dropdown field (which is in ...
2
votes
1answer
70 views

Restricting a lookup field in a list

I'm putting on SharePoint Lunch and Learn training for my company. I'm wanting them to sign up. In one list, I have title and date Lunch and Learn 1, January 15 Lunch and Learn 2, January 22 In ...
2
votes
0answers
68 views

Is cross-site lookup possible with a provider-hosted app?

I have following problem. I got two projects, one sharepoint-hosted app and another provider hosted app. Both contain a couple of lists. So far so good. Now I need the data from the sharepoint-hosted ...
2
votes
0answers
645 views

Adding fields to a list's existing lookup column won't add them to list's existing content types

I have created a custom list, in which I am not using any Site Columns or Site Content Types; I started with the OOTB Item content type and added various custom columns to the list using the "Create ...
2
votes
1answer
795 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
2
votes
0answers
175 views

Recurring Events in Calendar created from a template

Using SharePoint 2013 on-premise, I had a calendar working nicely in my test environment. I then Saved it to a template, moved it to another site collection and created a new calendar. It had lookup ...
2
votes
0answers
73 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
2
votes
1answer
501 views

SharePoint 2013 and O365: Lookup column Value ID missing

Okay, this is my first question so forgive me if this is long winded. TLDR: I cannot seem to be able to target or get the Value ID of the Category Column in a blog post rollup. Why is this? ...
2
votes
0answers
55 views

Lookups in SharePoint Workflow Emails

I've created a workflow that sends an email to all users when any new item is added to my "Payroll Processing" list. I want to be able to display the Client Name in the email that gets sent. The ...
2
votes
0answers
150 views

Multiple Criteria Lookup in Parent List

I have a list of projects (Project List) and another list of periodic status updates (Status Update List) related to each project (one-to-many). I need a lookup column in the Project List that ...
2
votes
2answers
5k views

Workflow Error: Coercion Failed: Input cannot be null for this coercion

I have a workflow that is assigning a task based on a lookup value. This workflow runs successfully the first time then fails on subsequent attempts. Here's how the data looks: Look Up Title ...
2
votes
2answers
3k views

Pull multiple values through a lookup

I am rather new with SP so I apologise if I cant express myself too well. Problem at hand: Two lists - Shops and Managers with a many-to-many relationship between them. I.E. in Shops there can be ...
2
votes
1answer
919 views

Lookup field is empty after List Item is added

Here is My Problem: I have a New Form in a list and I have added some custom JS code to it. In the form is a "Registration number" lookup field with more than 20 items in it. I need to populate it ...
2
votes
0answers
182 views

Join SPQuery in list

List 1 "Posts", fields Title body #comments modified in this list #comments fields is look up from another list Comments: List 2 "Comments", fields title body comments post ...
2
votes
1answer
573 views

Lookup column with no duplicates

I have a library containing documents, each one regarding a project. I also have a custom list with tasks (for monitoring) which has a column PROJECT. There are more than one tasks per project so this ...
2
votes
0answers
99 views

Sharepoint 2013 not displaying lookup field as input

I have a lookup column whose datasource has many items (2 000+) and when creating an item that references the source list, a dropdown is not very suited for the task. In SP2010 when there were more ...
2
votes
0answers
322 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 ...
2
votes
0answers
398 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 ...
2
votes
0answers
784 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 ...
2
votes
0answers
453 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 ...
2
votes
0answers
155 views

Best way to create a list with hidden columns with Data pulling from InfoPath form

So I have been working on this for a little bit here is what I am trying to accomplish: Using OOTB SharePoint 2010 Functionality I want to create an HR Referral System. Basically an InfoPath Form ...
2
votes
2answers
4k views

Lists with lookup columns aren't saving - read only?

I've got several list which have lookup fields, and I can't add new items to any of them. Every time I've clicked save, I get this error: "Invalid data has been used to update the list item. The ...
2
votes
1answer
2k views

Sharepoint - Creating lookup field to list on site collection scope

I've got a big problem with creating Lookup field between two lists which are deployed on site collection scope. I've got this field definition: <Field ID="{c80e8e3c-7124-4772-a39d-5b69f131d542}" ...
2
votes
2answers
1k views

How do I create custom control or action that works in a list's DataSheet view?

I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view. In datasheet view it is showing all the possible ...
2
votes
0answers
1k views

Inserting new item in list with EntityRef field to User Information List using Linq to SharePoint

I have a list with SPFieldUser field type in it. I try to insert new item in this list using Linq 2 SP. So, I generated data context class using the following configuration file: <List Name="User ...
2
votes
2answers
2k views

SharePoint 2010 difference with lookup columns

I recently upgraded my site from SharePoint 2007 to SharePoint 2010. The first issue I noticed was that the "lookup" columns in "Display view" showed up as the hyperlink instead of the string. ...
1
vote
2answers
5k 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 ...
1
vote
4answers
10k views

How do you connect a Calendar List to a Project Tasks list using Web Part Connections?

I created a Calendar List and a Project Tasks list. Then I added a lookup from the Tasks list to the Calendar list. However, when I try to connect the two with the related field visible on both List ...
1
vote
4answers
19k views

Get value from drop down using jQuery (lookup column)

I feel like this should be an easy one but am having trouble finding the answer here and via Google. Using jQuery, how do I retrieve the currently selected value from a dropdown in an EditForm/...

1 3 4 5 6 7 21