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.

348 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
75 views

Find all lists that look up a Contacts list

I have a Contacts list in my site collection, and it is used in lookup columns by multiple other lists. Is there an easy way to get all the lists that have a lookup column pointing to the Contacts ...
1
vote
0answers
211 views

Lookup column automatic selection in list form upon adding new item

I have a site page with two related lists, this relation being established via the webpart option "insert related list", and I'm using ID column in my child list as the lookup column. The child list ...
1
vote
0answers
507 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 ...
1
vote
0answers
286 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 ...
1
vote
0answers
689 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 ...
1
vote
0answers
516 views

How to copy Assigned to field from list A to List B on creation of item in List B?

Trying to solve a problem with moving data from one list to another. I have 2 lists. 1) a project list that contains Project info (project ID which is text, name, lots of details, and an "Assigned to"...
1
vote
0answers
411 views

How to get Dependant LookUp Column Values in Sharepoint 2010

I am trying to get the Dependant Lookup column values in sharepoint 2010 but unable to get the value so how can we read the values from Dependant LookUp Column. thanks in advance
1
vote
0answers
157 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
321 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
1answer
216 views

Displaying text in a Look-up column

Apologies for not being clear. I'm try to display a "multiple lines of text" column as a look-up field in a new view of the parent list. I have tried SP Designer and most of the standard webparts. ...
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
1answer
1k views

Get value automatically similar to Excel's vlookup function

I want to get data from another list automatically based on a column from this list. Let's say the source list shows the ID A, B, C and the related values 1, 2, 3. In my list I show in a column one of ...
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
1answer
266 views

Document library forces check-in upon adding custom lookup column

SharePoint 2007 Team Site Add a Document Library with the Word 2003 template Add a new item, save, close document, no problems Add a (required) custom lookup field to the document library Add a new ...
1
vote
1answer
393 views

I need to have the data from a list in another site at the same level to be available as a lookup in sharepoint 2010

I have a parent team site (Services) that contains multiple sub sites. One of the sub Teamsites is Call Inventory Containing our Stock List. Another Teamsite is called Purchasing containing a purchase ...
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
396 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 ...
1
vote
1answer
1k views

SP 2013 REST API retrieve values from lookup library

I have a custom list 'MyList', containing a (single value) lookup field 'MyLookupField', which points to a library 'MyLibrary'. I now want to retrieve all items from 'MyList', including the Link to ...
0
votes
0answers
7 views

Lookup Via Sharepoint Designer

I have two list. One List (EMP) Where i have EMP ID and EMP Name, another list(EMP Details) where i have EMP Details (Like, EMP ID, EMP Name and etc). I want when any new item add in EMP list, based ...
0
votes
0answers
14 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
29 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
2answers
33 views

Lookup Column Value through Rest API

i have a small requirement, where in i am pulling in a lot of data from List A to List B through Rest API. but i am stuck at one place where in i am not able to pull in lookup value in List B. Hope ...
0
votes
0answers
31 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
38 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
27 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
14 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
1answer
98 views

Update another field with an id of a lookup column

I have a list with around 1000 columns and I need to be a able to prepopulate another field with a lookupid of another lookup field on the same list I am getting error when I use: var ...
0
votes
0answers
14 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
33 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
1answer
23 views

Pull mulitple fields when getting dropdown choices from external data source

I've tried searching for this as I'm sure others have had the question but can't find a way to word it to find a result. I have two lists setup - one with a list of people and their data (IDs, First, ...
0
votes
0answers
56 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
2answers
175 views

Lookup column agains list with more than 5000 posts

I am new to SP online. This is about a lookup column that displays data from another list which is currently exceeds the 5000 items limit? Any easy solution as I dont have much programming ...
0
votes
0answers
76 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
1answer
59 views

Show all the lookup column data

I have 2 lists: House and Room. House list has lookup column call Room(Room1,Room2,Room3). When I add a record for house list, I choose Room1 which is hyperlink to lookup column. Is there any way, ...
0
votes
2answers
510 views

Add column (lookup field) to another site

I create a column "LookUpValues" of type LookUp in Site A but I'm trying to add from existing site columns in Site B but it doesn´t show up. Is it possible to do it? Any ideas?
0
votes
1answer
102 views

how to change lookup reference between sharepoint lists?

I have simple Sharepoint list named Alist with lookup value column. the lookup value column returns fields from other list named Blist. accidentally I have deleted this Blist and in Alist all lookup ...
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
50 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
31 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
35 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
1answer
39 views

SharePoint filter lookup field, based on another field in the list

I am using SharePoint online and am having trouble with the formulas since they are not exactly like Excel or InfoPath. This custom list I am creating has a lookup column for office locations and I ...
0
votes
1answer
69 views

Fetching Data based on Look up value from another List

I have a small requirement , where in i have 2 lists say List A and List B. In List B, i have a lookup column which is looking up to List A column. Now on selection of Lookup column value in List B i ...
0
votes
1answer
37 views

Sharepoint Online- out of the box solution

Never used SharePoint before and have been given the task of setting up SharePoint Online and migrating list from SharePoint 2001. I set up subsites, however I now know that I cannot create lookups ...