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.

383 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
2k 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 --> ...
1
vote
0answers
347 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
398 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 ...
1
vote
0answers
591 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
1
vote
1answer
445 views

Include additional fields with Person Site Column

When I create a column of type Lookup, there is a section at the bottom labeled "Add a column to show each of these additional fields:" I want to do this same thing with a Person column. It seems ...
1
vote
1answer
466 views

Filter a parent list by a particular child list item's lookup field value

I have two lists, Activities and Objectives. The Activities list has a multi-value lookup field that references the Objectives list. I am trying to create a filtered view on the Objectives list that, ...
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
220 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
509 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
289 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
718 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
521 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
418 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
158 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
332 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
219 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
300 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
152 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
2k 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
269 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
395 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
625 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
117 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
140 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
401 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
300 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
591 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
10 views

Column Default Value Based on Root URL

I have a tab in an MS Teams team where users can view our upcoming corporate training sessions (i.e. modern Events). In each event description, I am putting a link to a sign up form. The sign up form ...
0
votes
0answers
18 views

SharePoint Lookup Column - break connection from source

When choosing an item in a lookup column, how do I break the connection of the item in this web part from the source in the other web part? So that when the item is deleted from the source list, it ...
0
votes
0answers
5 views

Creating Upload Document button - upload hangs and never closes

Trying to create an upload document button for a SharePoint 2013 library. I have some metadata that is necessary for user to enter upon upload. When I grab the URL for the UploadEx.aspx and link to ...
0
votes
0answers
19 views

Unable to set User SharePoint group column (lookup) value

Would like to request for some assistance in SharePoint. I have a SharePoint group called Users and SharePoint List called Role and Department. I have added Role and Department to Users column as ...
0
votes
2answers
280 views

getURLParameter(ID)

Lots of great posts on using the getURLParameter(ID) to populate a lookup column in a NewForm.aspx when coming from a list view web part on another page. Here is my problem, the source url that I am ...
0
votes
0answers
6 views

Workflow Error message - add lookup

Creating a workflow that sends an email. Click Add Lookup to retrieve value [%Current Item:Assigned To%].Get error message: Using the brace character in an email that also contains a workflow lookup ...
0
votes
1answer
21 views

SharePoint Online List Lookup within the Same List

I have only One SharePoint Online List. I want to use a Lookup using "ID" and "Prior ID" columns, in order get a Date added to the "Prior Date" Field. I want it to look like the table below. But ...
0
votes
0answers
18 views

While in an Item the Lookup Field Opens the Lookup List instad of the Related Item

I have a lookup field that references another list and I'd like to be able to click on the one of the lookup results and then be taken to that item on the other list. This works fine in the standard ...
0
votes
0answers
7 views

automated solution to consolidate real time files in multiple Sharepoint folders in one excel sheet

I have a scenario :We have 60 folders in one of the parent folder in Sharepoint on premise site. Each folder has an excel file uploaded.I need to consolidate the data in the excel file in one of the ...
0
votes
1answer
16 views

Lookup doc library column showing options based on List other column's value

I am currently setting up a document management system in our SP Online system. A column of the Doc Library is called "Project Name". I created a List ("Project List") containing the Project Name ...
0
votes
1answer
38 views

How to update the people and group column with multiple values in SharePoint

I have a person or group column in SharePoint 2013 I want to set the multiple values I have set its value like 1;#pallavi it's working but when done for multiple values like 1;#pall;#2;#shee it's not ...
0
votes
0answers
7 views

Lag in workflow detecting updates from lookup column

We have moved our internal newsletter to run through sharepoint, We have one list (Dates List) which contains the dates and workflow of emails and reminders, and another list which contains the ...
0
votes
1answer
17 views

After creating the first list with choice fields I cannot lookup those fields - how do I keep data integrity and still link?

I have seen older answers that I can have a calculated field for the lookup but that seems silly and redundant. I have 3 choice fields I would have to do that for for 100s of records. Is that really ...
0
votes
0answers
5 views

Lookup field in Infopath (answer filtered on another dropdown) is returning text as designed, but field error says integer required

I have two dropdowns in a repeating section of an Infopath List Form. When LeaveCategory is selected, the lookup, LeaveDetails, returns a list of options from a SP list based on a filter where ...
0
votes
1answer
19 views

Filtering by date isn't working properly

I have some struggle viewing lists with a Group By. The list contains documents that belong to a certain event. Therefore, we added a lookup field which points to the date + start time from the ...
0
votes
1answer
79 views

Lookup values invisible on QuickEdit (JSON formatted)

I hope you can help. SharePoint Online: Values on a Choice column appear colour formatted on QuickEdit view.  However values in a Lookup column (values taken from a lookup list) are invisible on ...
0
votes
2answers
32 views

Update Item Choice selection based on other List

I'm relatively new to all this, so I apologize if this is simply not possible or incredibly easy. I have two lists, the first is 'Projects' which is a list of various projects being worked on, and ...
0
votes
0answers
27 views

Lookup Column in SharePoint 2013

I have two lists. One is the 'Product' list and the other is the 'product description' list. There is a unique productId in the product list. Using jquery I have modified the Title column of the '...
0
votes
0answers
25 views

Creating a “Self-Healing” list that updates when a different list updates

I have a list that uses the People/Group Field. I am able to use the "Create an Item in another site" function with a workflow to "copy" that field to another list, but I am unable to update the field ...
0
votes
1answer
25 views

Grouping lookup select option

I am new to SharePoint. So I would like to ask if it is possible to "group" these drop-down selections together? My lookup table has a "user" and timestamp columns. So, whenever I add a new entry in ...

1 2 3
4
5
8