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
2answers
869 views

lookup another lookup

I've 3 lists. List B looks up List A and then I need to create a lookup in List C that lookups List B but also get values in List B that are lookups of List A. How is this achievable? Thanks
1
vote
1answer
546 views

Getting “404 NOT FOUND” when clicking on lookup link

In the past, when clicking on a lookup item on a list, it would show a popup with the data of that lookup item, but now I get a "404 NOT FOUND". I tried creating a new list and adding a lookup from ...
1
vote
1answer
4k views

Sort By Descending upon lookup column

I have a lookup column in multiple lists that points to a list of dates. These dates go in ascending order, and since the list posts are sequential, the older dates start to become irrelavent, forcing ...
1
vote
4answers
1k views

Add existing list as a lookup column in User Profiles

I'd like to extend my user profile properties in my SSP by adding a new property which would render as a dropdownlist via a lookup column. Is it possible to reference a sharepoint list using a ...
1
vote
1answer
102 views

Lookup Column of a List Column

I have a requirement for a project site in SharePoint. The Site will have: 1st List: a Stakeholders List with the names of people involved (people/group type) in the project and their Project Role (...
1
vote
2answers
2k views

lookup between two lists programmatically

i have two lists. the first list name is "cases" and the second list name is "issues". in the cases list i have a text column that holds a case number. in the issues list i have lookup column name "...
1
vote
1answer
518 views

Fix a lookup type site column when website is provisioned

The site column "Related Task" is lookup type. I would like to fix this column's "Get information from" table. The get information table is within the same site. Is it possible to fix this using using ...
1
vote
1answer
1k views

Lookup with a custom field type as target

I want to create a lookup field with the sharepoint ui which points to a field with a custom field type (parent field type is number). In visual studio with the object model this is not a problem but ...
1
vote
1answer
3k views

Get related items from a parent list item through lookup

I've got 2 lists: Companies and Employees. In Companies I have a text field called Name and in Employees I have a lookup to Companies based on the company Name. What I'm trying to achieve is to get ...
1
vote
1answer
207 views

Insert LookUp column in list using Sharepoint PNP PowerShell

I've this code bellow OfertaParticulares Connect-PnPOnline -Url https://test.sharepoint.com/sites/test/Negocio/OfertaParticulares -Credentials (Get-Credential) $listName="Páginas" $fieldName="...
0
votes
2answers
2k views

How to get count related Lookup value programmatically?

Another day, another question ;) So, I have two custom Lists, "Attendees" and "Events". In the Events-List there's a Lookupfield "Registrations" which I want to fill programmatically on page_load. In ...
0
votes
1answer
436 views

Sharepoint online lookup field hyperlinks not working

We are using SharePoint Online and we have noticed the hyperlinks on lookup fields in a list are not working. These are the links that appear in the list view when you have a lookup field that points ...
0
votes
2answers
63 views

Calculated Column Formula to hide blank values

So this is a follow up from my question yesterday as I believe I have found a work around or at least a potential one. To cut a long story short I have a list called "Team Information" this contains ...
0
votes
1answer
5k views

How do I update a lookup column from a dropdownlist?

I'm creating a custom web part in asp.net for SharePoint 2010 programmatically. When a user presses an Add button, the selected item from the dropdownlist is supposed to then be added to the Groups ...
0
votes
1answer
3k views

Autofill column values of a list based on another list column value

I am an newbie to JS, SP Services and JQuery. I am on SharePoint Online environment. I have a List A with columns Title (Text Field), Location (Choice field) and Event Date (Date field). I have a ...
0
votes
2answers
2k views

How to add a from lookup field value to the text

I think about how to add a from lookup value to the text ? How can I write it to another colum ? In the same list.
0
votes
2answers
1k views

Choose Username column in Content-Type

In my portal I have two lists. One (we'll call it the people-list) is a list of people's first and last names and their username (person column) if they have one. I have created a content type that ...
0
votes
3answers
5k views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field through PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl $...
0
votes
2answers
394 views

Lookup from list column?

Is it possible to look-up anything but single line text values when creating a lookup column? E.g. I have a list with some general data ind it, one of the columns contains numbers. They should form ...
0
votes
1answer
8k views

How do I retrieve the value of a lookup-field in a workflow?

I'm very new to SharePoint, and I'm working through understanding lists, workflows, and relationships between the two. I'm working on a SharePoint page to keep track of tasks completed in a timeframe. ...
0
votes
1answer
526 views

Version History does not update when lookup changes - how to fix?

The problem: I create a document library and a custom list, then use the custom list as the source for a lookup column in the library. Now I add a document to the library and set the value of the ...