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
1
vote
5answers
3k views

Automatically populating a list column with department of user filling in the list

I have a list that needs to contain the department of the user filling in the list item. How do I automatically fill in the department for the current user filling in the list item? Is this even ...
0
votes
1answer
55 views

FieldLookupValue[] next assignment always replacing all previous positions - SharePoint Online

I have a ; separated string BusinessCategories. These values should be found as List Items in a custom list BusinessCategoryList, and I want to create a link to them in a multi value lookup field and ...
0
votes
1answer
124 views

Lookup links not opening associated record from List form in Sharepoint 2016

I have set up a list that has a lookup field on Documents. This works nicely except for one thing. If I open a record (by double clicking on the record), a panel pops out showing a form populated ...
0
votes
1answer
90 views

Disable 1 time firing double click event from Multiple Choice Lookup column using jQuery/javascript

I have a multiple choice column of potential attendees that are to be enrolled in a course. After the number of available spots is filled, I disable the column along with the "Add" button, yet one ...
1
vote
0answers
78 views

how i can create a site column of type lookup with empty source list (Get information from), and modify the “Get information from” at list level

I am working on an on-premise sharepoint server 2013 farm. i have the following:- 1) i have a team site collection which contain 5 sub-sites. 2) under each sub-site i have a custom list named "...
0
votes
1answer
284 views

Lookup Column Keeps Returning as Undefined

I am getting a TypeError that I cannot figure out for the life of me. I am unable to debug as my company forces IE11, and I do not understand its interface [I use Chrome, which I don't have access to]...
0
votes
1answer
196 views

Sort lookup column to show Active = Yes category on top in on edit form

We are on SharePoint 2016 on premise. We have one document library in which we have added look up column (Category) of existing list(Allow multiple selection). We We want to sort by Active column (yes/...
0
votes
1answer
32 views

Manipulate a value in a webpart and use it somewhere else

I hope you can help. We have two lists : countries and customers Countries fields : Country Name + Language Customers fields : Customer Name + Country Name In the dispform of customer, I need to ...
0
votes
1answer
57 views

Filtered Lookup on Created By

I have two lists. First one is a Projects List and Second List has a lookup column to the First list. I want the lookup column on Second list to show only the Projects filtered by the column "Created ...
0
votes
1answer
38 views

Where does the Discussion Board 'Posted By' data come from?

We have an email that is sent out when there is a new post to the discussion board via SharePoint Designer workflow. In the email, it shows the user who posted the message or reply using 'Current Item:...
0
votes
1answer
1k views

Rest API not returning lookup field value

I want to get the Approver(people field) value from list item using REST API where Country(lookup field) equals to 'ABC' and Cluster(lookup field) is equals to 'XYZ' I have written below REST API it ...
0
votes
1answer
971 views

REST API get lookup additional column

I am trying to get the data from an additional lookup column with REST API. I have two lists. The main list is "OIE Alerts" and the second list is Countries. The main list has the field "Country" ...
0
votes
1answer
1k views

How can i filter the items in a lookup column within a document library based on values in another column

I want to know if it is possible to restrict the items in a lookup column of a document library based on another, related field in a separate table. We have a document library for each job site. We ...
0
votes
1answer
39 views

SharePoint Online - Get a list of (Figure out) all non selected choices in a list view

SharePoint Online environment - I am trying to find a logic for a scenario. I have a Product list and a Product document library. In this list, every list item (Product) is automatically assigned a ...
1
vote
2answers
1k views

Making SharePoint lookup field auto complete

Can we make a SharePoint field which is a lookup drop down box on the editform.aspx. have the functionality so that user can type in and select from the options based on the values of the types?
1
vote
1answer
81 views

SharePoint Online - Restrict users to select not more than one value for a look up field

How to restrict users to select only one value in a look up column. Scenario: I have a look up column and i want users to select only one value Example: For Opportunity ID (originally a number ...
1
vote
1answer
236 views

SharePoint Designer: Email Workflow based on names in lookup columns

I am trying to create a workflow in SharePoint Designer where in List A it will email the people in Columns: OCR PM, BSC, Pri DBA, Sec DBA, and Tech Mgr only if someone updates/appends changes in the ...
0
votes
1answer
68 views

Looking for some good alternatives to SP Lookup

I have a SharePoint list where one of the columns is a lookup to a different list. This works fine as long as the other list does not crosses its 5000 item limit. Also, a dropdown list with ~5000 ...
6
votes
1answer
316 views

Office 365 Security & Compliance Content Search not finding Keyword if among multi-selected Lookup column

Setup: I created the following: a list (named Category) at the top-level site, a Lookup site column (SC) (named Category) on Category, which allows multiple selections, and a Document-based content ...
1
vote
1answer
47 views

List Of Companies Based On Expertise

I have two list which is Company and Expertise. In the Company list I have 4 lookups to the Expertise list. I want to have a list of expertise which have links that can show the list of companies ...
2
votes
1answer
1k views

Calculating on Lookup column without the use of SharePoint Designer?

Trying to find a way to join values in two separate columns into a third however one of these is a lookup field to a second list and as I understand you cannot do calculations on lookups without using ...
0
votes
1answer
799 views

Find all lookup fields that point to a List

I have List X which needs simplifying. List X has 70 fields and I will split out about a third of the fields from List X and recreate them in List Y. After I can link the two lists, List Y will ...
0
votes
1answer
1k views

InfoPath and SharePoint - Filtering lookups

I have three SharePoint lists based on the below examples:- ListCountry CountryName : Single Line of Text ListCity CityName : Single Line of Text RelatedCountry : Lookup [ListCountry:CoutnryName] ...
3
votes
1answer
251 views

Lookup column to task list, display only top-level items

I'm trying to create a lookup column to a task list, but I only want to display top-level task names in the lookup, not all the subtasks. Is there any way to do this?
3
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 ...
1
vote
1answer
669 views

Export sharepoint list with lookup values using powershell

I need to export the SharePoint list in CSV format for which I am using following code. It works fine except the "Project Name" Field which gives "microsoft.sharepoint.client.fieldlookupvalue" output ...
1
vote
1answer
58 views

SP2013 - How many values can be stored in multivalue lookup columns?

as I am currently designing a tool for one of our customers, we want to use multivalued lookup columns. As there is no real limititation set for the amount of source data we fear it could reach for a ...
1
vote
2answers
97 views

TryGetList damages view with Lookup field

We've recently run into very strange issue: Calling spWeb.Lists.TryGetList("blaBlaBLa"); from DelegateControl code is causing the view containing cross site lookup field to crash. More details: We ...
0
votes
1answer
143 views

Advice on SP2013 Contact list with over 5000 items to work as Lookup for document information panel

Disclaimer: I am completely new to Sharepoint and web design. Sharepoint 2013, on-premises. The company needs to have multiple document libraries and it is necessary to be able to tag documents with ...
1
vote
0answers
114 views

How to group multiple variables on lookup column?

I want to separate multiple rows. How can i do this with another web part listview or programmatically?
3
votes
1answer
929 views

Can i group documents by using lookup column with multiple value?

One document belongs to many row. It is allowed . But I want to group them and show the document on each group. Is it possible ?
0
votes
1answer
29 views

How can i compare two different columns from different document libraries?

I got two list called List A , List B. List A has got columns called "Number" And "Title".. List B will reach the "Number" and compare , if it is the same number will show List A 's "Title". List A ...
0
votes
1answer
47 views

How to add 2 element from list “A” to list “B” by choosing only 1 of them

I am using Sharepoint 2013. I have an "A" list with a lot of data in 2 column. Column "A1" is the name of the item and "A2" is the ID of the item. In the list "B" there are a lot of columns and the ...
1
vote
0answers
30 views

Lookup column to Page library with versioning remains empty after search crawl

We have a content type (named: Tiles) of 7 lookup site columns that point to the ID field of the Pages library on the same site. The Pages library has versioning (Create major and minor (draft) ...
3
votes
1answer
1k views

Calculated Column checking against a multi-selection lookup

FieldA is a lookup (to another SP list) with the option to select more than one choice from 9 options: let's call them 1 thru 9. FieldB needs to be a calculated field that evaluates FieldA. Certain ...
0
votes
1answer
33 views

How can I show matched items view between two list using a lookup column?

I have got two document libraries in which I created a lookup column to relate them, but I want to show the results as a list.
0
votes
1answer
46 views

How can i add linked data source to website?

I got two lists. And I want to join , merge them and select the same IDs.But i don't want to do this on Sharepoint Designer. I only use browser.
1
vote
1answer
678 views

“Failed to cache field with id” unexpected error on list item edit

Some of our users are receiving "Unexpected errors" when modifying list items. They are third party, but have access to our internal SharePoint site. Our site admin sees "Failed to cache field with id"...
1
vote
2answers
23k views

How can i create cascading dropdown Lists in SharePoint?

I have created a list on my SharePoint page with multiple dropdown menus when a new list is created. However, I was wondering that when an option is selected in the first drop down menu, if there was ...
2
votes
1answer
2k views

Sharepoint Rest API How to Expand Multiple Lines of Text Lookup Field

I have a list that has a lookup field on a documents library. I can get and expand fields no problem only if they are single line of text fields (FieldTypeKind = 2). But when I have a multiple lines ...
2
votes
1answer
512 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
191 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? $...
1
vote
0answers
155 views

How to copy the value in a lookup field to a related item in the same lookup column?

I'm looking to fill out a lookup column. I have a couple of Sharepoint Designer Workflows to set a lookup column field in list A to a related ID from another list B when an item is created in list C. ...
1
vote
0answers
140 views

Display Childs in Parent list possible? (Parent-Child relationship list)

I know how to create a Parent-Child relationship between 2 lists and display the Childs in the parent form or on a Webpart near my parent list but what I would like to do is actually display the ...
1
vote
2answers
419 views

Item Level Permissions and Lookup Columns

I'm trying to build a simple Garage Management System to see what spot someone is assigned. So I have the following lists: Garages Levels Spots Spots has a lookup column to Levels, Levels has a ...
4
votes
1answer
1k views

Rest API Refinement Filter on Lookup Column

I am able to use the refinementfilters with the search api to refine a search for documents in a document library with this: /_api/search/query?querytext='(Search Term)+AND+(path:https://mysite....
1
vote
1answer
159 views

Can't Enable Cascade Delete, Large List (Office 365, SharePoint Online)

I have a large list, over 5000 items (~6000). I need to enable cascade delete on a lookup column SharePoint errors out and tells me the action exceeds the list view threshold. Note: This feature is ...
2
votes
1answer
1k views

Including a link to a SharePoint list item in an email

I have two lists. In one list a user enters system details which then kicks off a Workflow which then sends an email to an approver. The email has a link to the second list where the approver ticks on ...
1
vote
0answers
54 views

Lookup data updates in Content Search Web Part / Search Results

I am using a content search web part to serve up text content and hyperlinks from a list (We will call this the main list). Everything is displaying as expected. One of my fields is a lookup column, ...
2
votes
0answers
70 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....

1
3 4
5
6 7
21