.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Content Type or Lists Lookup Column can't show additional fields which are Choice or lookup columns

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :SharePoint

I am trying to create some content types, but this also happens when creating new columns in a list.

Ok, here is my setup (which is the most basic way to replicate the issue):

List 1: Department List
Columns: Department Name (Single Line of Text)

List 2: Document Owners
Columns: Document Owner (single line of text), Department (Choice or Lookup from Department List), Email (single line of text), Lookup Field (Calculated).

Content Type: Quality Document
Columns: File Name, Title, Document Owners (Lookup from Document Owners List), Email (pulled in with Document Owner), Then i want to also pull in Department from the Document Owners list.

That is where my problem is.  When i select the Document Owners List as the list to get the information from, there isn't the option under "Add a column to show each of these additional fields" to pull in the Department column.  This occurs if i use a Choice in the Document Owners list, or if i do a lookup from the Department List.

My preferred method of implementing this system would be to have a multi-value lookup field in the Department List for Document Owners so that the Owners are attached to the Department, and if the owners change for the department they also change for the document that is for said department.  But, i run into the same issue that i c

View Complete Post

More Related Resource Links

restrictions on additional columns available for addition with Lookup column?

Can a choice column be added as an additional field when creating a Lookup column? I was able to do this in the beta version but have been unable to in RTM. The column does not appear in the list of availabe columns to add as additional fields.

supported column types that can be used as additional fields with a Lookup column?

Can anyone tell me which types of columns can be used as additional fields for a Lookup column? Are they the same as the column types that can be used to create Lookup columns? Choice columns are currently not available (known issue) but I think they are officially supported. What about Managed Metadata columns? Thanks

Choice/person columns in extra columns for a lookup column



Image this scenario:
I have a list of projects, containing general info for a project.
I have a list of tasks, and every tasks is linked to a project using a lookup column towards the projects list (using the title field).

In SharePoint 2010 I can select additional columns of the projects list when adding the lookup column.
I want to filter the list of tasks based on the project manager (person column in the projects list) or on the project status (choice column in the projects list) or on the project year (a number column in the projects list).

When adding the lookup field, I can select the Title column as main reference column, I can add the project year column as additional column, but I cannot select the project manager or the project status columns as additional fields.

How can I add these columns as well in order to filter my tasks list on these fields?

Thanks in advance for any help on this!

How can Word use the additional fields of a lookup column?


Hi everybody,

Like the title asks, I'm trying to use multiple data from a list in a document as fields but I can't figure out how to add fields for the additional columns in a lookup column.  For example,  I have a list with clients and I want to use the lists information to populate information within a document; such as their first name, last name, and address information.

Any help would be appreciated. Thanks,

Anthony Conrad.

EDIT:  I am using SharePoint Foundation 2010 and Word 2007/2010

Not all content type columns show up in DisplayForm.aspx


I have a list that when displaying the DisplayForm.asp does not show all the columns of my content type.  I double checked that the column Status was Optional( not Hidden), so I don't understand why they don't show up.  Can anyone advise please?  For site visitors that only have View rights, DisplayForm is the logical way to view the list item, so they need to see all columns.


Edit - I was able to get the missing elements to display by switching the column to Required rather than Optional.  While I think this will work in my case because the new items are coming from a webservice that provides this data, it doesn't seem like this should be required.  I thought by default ALL columns/fields displayed on the forms UNLESS marked as hidden.

There are no mistakes; every result tells you something of value about what your are trying to accomplish.

Custom Columns - Fill values based on value selected in a lookup column



I am working with Sharepoint 2007. I have a list of 130 buildings located in six different cities and three different provinces. I imported this list from an Excel spreadsheet. I also have a document library that contains various files associated with these buildings. I've added a custom column to the document library that contains a lookup field to the name of each building. I also have two additional custom columns that have the city and province. What I would like to accomplish is to have the city and province columns automatically be set based on the name of the building selected, such that these values are taken from the same row of this list as the building name.

Hopefully my question makes sense.

Thank you, James

fx Controls instead of Drop Down Lists for Lookup fields in InfoPath Secondary Data Connections


I have a secondary data connection with a lookup field into another list. To display the fields text value instead of the index, I am using a drop down list which gets its choices from the linked list. This information is read-only so I disabled the control via formatting rule.

A calculated value control might be better suited, but my XPath skills are not very "developed". Has anyone done this before? Taken the index from the bound field and extracted the text value from a second data connection? Thx


Lookup column across site collection that are in different content DB

Is there any solution to create a custom look up column that get the data from lists in different site collection that are different content DB?

Search to lookup fields show id


Hi all,

I have several fields in document libraries which is a lookup to another lists.

When I try to search to that fields it show the id not the title.

How can I get the title instead of item id?


Thank you all..

Best regards,
-- Pingkan --

SharePoint 2010 SPSiteDataQuery with Lookup additional columns.



I am trying to use SPSiteDataQuery to collect data across different sites. The query seems to fail when I add Lookup additional data columns. I mean when we create a lookup column, sharepoint 2010 allows us to get data from additional columns from the lookup list. When I try to include these columns SPSiteDataQuery is failing. This is the viewfields that I am using.

"<FieldRef Name='ID' Nullable='True'/><FieldRef Name='Lookup' /><FieldRef Name='Lookup_x003a_Title'/><FieldRef Name='LinkTitle' Nullable='True'/><FieldRef Name='Created' Nullable='True'/><FieldRef Name='Modified' Nullable='True'/><FieldRef Name='ID' Nullable='True'/>"

In here the Lookup_x003a_Title (displayname : Lookup:Title) is the column that bring data from the Title column ofthe lookup list.

Any help is greatly appreciated. The query works fine without Lookup:Title column.



Calculated column based on other columns in Lookup list selection


.. if that makes any sense.

I have a list with with lookup column to another list. that list has other columns.

I want to add a calculated column on the parent list, that set it's value to column from another list, but based on my selection in the lookup column of the parent.

Possible? presuming the calculated column  gets set when I submit and not interactively? what if edit the data and change my selection?


SharePoint lookup site columns and Word Content Controls

I discovered that when you bind lookup columns in SharePoint to a Content Type that in turn pushed these properties to the document, the value actually stored is the ID and not the text that is displayed. What is the correct way to use such site columns to enable users to select the data they want to be associated with a document and then to have the display values be populated in the Content Controls?

Using Additional Fields from External Content Type in InfoPath 2010 External Item Picker


Hello, we've created an external content type for our store locations. Each location in the content type has a name, id, manager, region and so on. When we use this BCS content type as a field in a list, we are given the option to "Add a column to show each of these additional fields"

What would the equivalent be in an InfoPath form? When we add an External Item Picker to a form a number of fields are included in the form's data source, including a repeating group called BDCEntity with the following fields:

  • EntityDisplayName
  • EntityInstanceReference
  • EntityId1
  • EntityId2
  • EntityId3
  • EntityId4
  • EntityId5

Entity display name appears to be what we configure as the Display Field Name in the picker properties, and the EntityId1 is the location ID, which is the identifier on the external content type. EntityId2-5 are all blank.

We use region and other location attributes in workflows so how can we access all these other fields?

Thanks for your time.

Peter Newhook SharePoint posts on my blog

BDC Entity as a Data Source for a Lookup column

Is it possible to create a custom lookup field type to have a BDC entity as the data source?

wss2.0 update/delete/hide lookup column that does not display any values


Hi All,

I have a document library that contains a Category column that is a lookup field. This is a default column that is a required field when uploading documents to the document library. The Category column is empty and I am unable to amend, hide, make it not required or delete it.

I have gone to Modify settings and columns -> clicked on the Category field to edit, but there is no option to amend the content or delete it. I am only able to amend the Column name and Description.

Since then, I have amended the column name to eg. Category1 and created a new Category field as a lookup and linked it to the correct list.

The problem I am facing now, is that I cannot hide, delete or make the Category1 (old Category) field NOT required. Either I would like to update the original field to display the correct values or alternately hide, delete or make the column not required.

Please help.

Datasheet view lookup column issue


When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.


Any ideas how to get this resolved?

DVWP connections with multi-select lookup columns

I have a question concerning the Data View Web Part using SharePoint Designer 2007.   I have two list (A and B). List A has a lookup column (called B-items) with multiple selections to items in List B(using the Title column from B).   I create a web part page and insert a data view of using List A. I create another data view with data from List B. Next, I make a Web Part Connection between the two data views with A passing B-items column as parameter to List B data view. I then create a filter on the List B data view with a comparison of List B’s Title column equal to the parameter of List A’s B-items value when a user selects an item from List A data view. The problem is nothing appears in List B’s data view.   When I try the reverse of the above scenario it works fine.     I understand that this is properly functionality, but is there a way to achieve my first scenario? If so, how can it be accomplished?   I have looked through the web for help and found the answer here http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/749b7477-f37f-4724-94b3-b6ace770e73a seems to be what I’m looking for. However, I am unsure how to implement his code into the web part page.   I am a worse than a novice with xsl so if anyone gives an example I would greatly appreciate step by step on what code is needed a
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend