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.

1
vote
0answers
156 views

Related Item View - refered from child list

I'm working on a 2010 site at the moment and is asked to display all images to a news item (custom list). The problem is that the news don't have any reference to the Picture library, instead the ...
1
vote
0answers
320 views

Getting Error Access Denied when creating Filtered Lookup in SP2007 List

Using WSS SP2007 as a site curator. List A is a new list. List B is a resource list with a view showing active Project Managers. When I go to create a filtered lookup column in List A I immediately ...
1
vote
0answers
297 views

Change column type from “Lookup (information already on this site)” to Person or Group

I have an issue after migration SharePoint 2007 to 2010. We had “Person or Group” which now somehow has transformed to “Lookup (information already on this site)”. This creates lots of troubles for ...
1
vote
0answers
142 views

Getting user's AD groups as lookup

I'm trying to make a simple reservation site, containing two lists: resources and reservations. Users are making reservations by creating a new item on Reservations list, specifying which resource ...
1
vote
0answers
1k views

How do I create a lookup field for a hyperlink field and display the URL?

I have a regular, out of the box, list of type "Links". I have created a custom list that includes a lookup field to the URL field of the "Links" list. I have created a custom xsl template file for ...
1
vote
0answers
621 views

How to get lookup field text column to display as an image in a view?

Wonder if anyone can help. I want to add a category choice field to a SP2010 Announcements list. The category choice is a lookup field to another list. The other list contains the categories and a ...
1
vote
0answers
116 views

Lookup columns into document template

I've a DocLib with the lookup field Field01 and I want to display the associated lookup columns as Field01:FieldA, Field01:FieldB... I already have them on the view, now I want the exact same ...
1
vote
0answers
139 views

How do I create a linked keyword index?

We have a 2000-document library that we use as a knowledge base. We're trying to create a hyperlinked index of keywords. In this simplified example, consider the following metadata for a document ...
1
vote
0answers
395 views

Content Organizer rule based on a Lookup Column with more than 20 selectable values

Does anybody have any experience making content organizer rule based on a Lookup column with more than 20 values in the list? (When you have more than 20 values, the view of the Lookup field changes. ...
1
vote
0answers
1k views

How to take a value from a single line of text field in one list and set it as a lookup field in another list?

I have SP 2010 and SPD 2010. I have list A that has a single line of text column named Res ID #. This provides the source for List B as a lookup column. I want to create a WF that will put the info ...
1
vote
0answers
281 views

My custom form isn't saving lookup fields

I have a list with two content types. I've created two custom forms for creating new items (because one field I don't want until the 'edit' form). One works great. The other one doesn't. What's ...
1
vote
0answers
590 views

Why does SPMetal ignore lookup columns in Farm Solution

I have content types and related lists (via lookup columns) in a Sandbox solution(.wsp). All my lookup column relationships come up fine in the SPMetal generated entity classes. I now have a ...
0
votes
0answers
10 views

Indexing lookup column in SP2019

I am working on a project where a document library is about to exceed threshold and lookup column is one of the metadata columns being used in the library, I am working with SP2019 on prem. The ...
0
votes
0answers
25 views

Can I lookup what a lookup column looks up?

To explain the concept, let's pretend I wanted to make lists of cocktails and ingredients. First off, we have a list of ingredients (gin, rum, campari etc.) and columns of relevant information (cost, ...
0
votes
0answers
29 views

Lookup to populate Text Box or Dropdown

I was following this to pull Additional Fields to appear on the form using calculated field and it is worked perfectly. However, when I try changing the calculated field to text box, it won't load in ...
0
votes
0answers
28 views

Cascading lookups/filtered choice columns in modern sharepoint

We are using modern sharepoint pages. I currently have a document library with a column that indicates the subject of the document. there's a 2nd column that has the sub subjects. I'm looking to set ...
0
votes
0answers
26 views

SharePoint - Infopath - Lookup Field - Filtering Out Items

I'm working with a SharePoint List (we'll call it List A) that has a lookup field to a second list (List B). List B has two fields: REPORT_NAME & RETIRED. RETIRED will either be blank or have an '...
0
votes
0answers
13 views

Adding a sum column which uses data from lookup

I have a list with employee names and a lookup column from another list, which has the training names and training duration. The training duration is added as an "additional field" from the lookup ...
0
votes
0answers
13 views

Required lookup field being submitted with no value

We have a list form which users can use sign up to work induction sessions with. The induction session dates are stored on a separate list. Sometimes if a user doesn't have the correct permissions, ...
0
votes
0answers
28 views

Sharepoint Multilookup Empty Field

I'm facing an issue with a multi lookup field while doing a REST API call using pnp-js. So I have this list (let's call it A) that looks up into another list (let's call it B) using a lookup field (...
0
votes
0answers
55 views

How to retain previous lookup values when initial lookup value is no longer available?

On parent site, have an Employee list with employees who are available/unavailable during different periods. There are several subsite Project lists using Employee list as a look-up for available ...
0
votes
0answers
73 views

List people picker graph

I am pulling a list via the graph api. I would like to be able to filter on a people picker field. However I do I use the lookup field id to equate to a user/member i.e the id 18 person joe blogs.
0
votes
0answers
92 views

Filtering view and workflows for lookup columns

I have 2 lists with the following columns: List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)" List B - "StatusNameReq"(Lookupcolumn based on the columns in List A) Now, I want to ...
0
votes
0answers
34 views

Filtered lookup displaying html in view

I created a filtered lookup column to pull in values from another list in my site based on a view. The drop down works great but when I see the item in my default view it is no longer a plain text. ...
0
votes
0answers
47 views

how to insert multiple values to lookup field in Sharepoint list?

I have Assignee field which accepts multiple values and its lookup column but whenever i try to post multiple values I am getting the below error "Cannot convert a primitive value to the expected ...
0
votes
0answers
29 views

Document opens in tiny window

I have a list, in the list is a look-up column referencing a document library. (n.b. the Lookup column is actually a 3rd party column a Sparqube Lookup Tracker, but is a look-up column). Is there a ...
0
votes
0answers
34 views

Multiple choice lookup field does not render on edit form

I have, for the last few years, used a field called "Enabled" and a calculated field which returns the value of the Title field if Enabled is true. If Enabled is false, it returns an empty string ("")....
0
votes
0answers
219 views

Add Field List Instance to List Content Type using PNP Provisioning

I'm using PNP provisioning templates. I have created a template for the root site that creates columns and content types. In the subweb, I have another template that creates 2 list instances. One ...
0
votes
0answers
47 views

Change Sort Order of Lookup Column

With the introduction of JSON Formatting for columns, is it possible to edit the sort order of a lookup column? Or is it just in the list view? Any good way to do this? Thanks.
0
votes
0answers
74 views

SP 2013 error while reading a document property.

I am getting this error intermittently for certain users. From ULS Logs i found these entries.. |No zip central directory found Unable to open Lookup list '{2e69av2aa-60R1-1d1g-s37k-77e666a56zc6}'.[...
0
votes
0answers
65 views

How to filter CSWP on lookup columns

I have a suspicion that this is not an OOTB feature, without requiring some dev customization, but here goes. Is it possible to specify the query on a Content Search Web Part to filter on data that ...
0
votes
0answers
100 views

jquery to get value from parent list

I have a list that uses a LookupField. I am trying to display the ParentID when I add a new item to this list. Here is my jquery code: <script src="/sites/SWR000744/SiteAssets/Scripts/jquery-3.2.1....
0
votes
0answers
49 views

Dates from lookup fields that are set using a workflow carry over dates that are a day behind the source date. Why is that?

I have dates pulled from lookup fields from a list and set to new fields on a different list but the dates are one day behind. I checked to see if they are indeed both just Date and not Date and Time,...
0
votes
0answers
133 views

Lookup Between two Lists - Workflow or Lookup Columns?

I have two lists (A and B) that are used to manage sensitive customer questions. Questions are entered into list A and the data is copied into list B via workflows. List B is used by a small group of ...
0
votes
0answers
87 views

An error occured while enumerating through a collection : Exception has been thrown by the target of an invocation

I was stuck with a SharePoint 2010 site column that I couldn't remove from the site collection because it was supposedly used in other subsites or content type. Usual error. After checking that the ...
0
votes
0answers
250 views

Workflow - Copy lookup field to another field without getting the lookup id infront

I've got a workflow that I want to combine a lookup field and a regular field into another field. This because both list can contain the same company and I want to group the list based on company name....
0
votes
0answers
47 views

How to use a SOAP data service as the source for a lookup list?

I have created a SOAP data source using SP Designer 2010. Now I am trying to figure out how to use that data source as the source for a lookup field in a list? Is that possible?
0
votes
0answers
46 views

What is the best way to Manage meeting attendees in custom list?

I am trying to manage a custom list for a large meeting in SharePoint 2013 . I already have a contact list with all information, this will be my basic invitation list. The person who call for ...
0
votes
0answers
29 views

make lookup option only available if status not completed

I'm creating a way to tag documents against projects, so I've created a list for the projects and numerous libraries that access the list as a lookup for tagging purpose. The list also has a status ...
0
votes
0answers
230 views

lookup displaying (None)

I have a library with a lookup column, when I add a document a edit form is presented and the lookup is available however the first item in the lookup is (none). If I then try to make this a required ...
0
votes
0answers
88 views

Show only chosen options from multi choice column in another colum as choices

I have column 1, multichoice column and from that column I choose few choices which I want to be seen in another column 2 (choice field also) (it can be in same list or in different, doesn't matter). ...
0
votes
0answers
38 views

Move sharepoint library to another site

I want to move a SharePoint library (2010) to another sitecollection. The problem is that this document library has lookups to other lists, has fields/contenttypes (some were deployed in a solution, ...
0
votes
0answers
243 views

My Deployed Site Column Lookup Isn't Referencing the List

I have a SharePoint list that was created through the SharePoint UI (i.e. not through code/features/packages). I'm trying to define a site column in my feature/package that is a lookup to this table. ...
0
votes
0answers
879 views

Filtered lookup using SPServices

I have 3 lists: Schools, Interactions, Contacts In the new form for a Interaction item I have a lookup field displaying a long list of contacts, however I need to filter this list to only display ...
0
votes
0answers
328 views

Can a content type item inherit sibling column values from lookup column item?

Here is how I have my lists structured - in case it matters, List A does not currently utilize Content Types. The problem is in the List B view of Site Column B. Since Content Type Y doesn't ...
0
votes
0answers
135 views

Lookups are empty

I have a rule set with two content types A and B. Both content types have the same parent content type and nothing else more. They are identical except for their name and ID. I'm adding files to the ...
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
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
0answers
250 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
28 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}...