.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

SharePoint List Lookup Not Showing All Column's From List Identified

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :SharePoint
In SharePoint 2010 I"m using a lookup column and I have the option to "Add a column to show each of these additional fields:".  The problem is that these additional fields listed are not all the fields in the target list.  How do I get the field I need to show up on that list? 

View Complete Post

More Related Resource Links

Create Lookup Site Column based on External List (SharePoint 2010)


I've got an External List and I want to create a Site Column, which is Lookup to a column in my external list. If I tick any of the columns in 'Add a column to show each of these additional fields' and click OK i get the following error message:

[NullReferenceException: Object reference not set to an instance of an object.]
  Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() +58
  Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) +809
  Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) +315
  Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) +240
  Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) +759
  Microsoft.SharePoint.SPFieldCollection.Add(SPField field) +61
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() +513
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) +46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +139

How to remove the group ID of a lookup column when exporting SharePoint list to Excel?


I am exporting my SharePoint list with a people/group column and another lookup column to Excel spreadsheet. The problem is, in addition to the content of these two column, the group ID (from the lookup lists) of these two columns show after like "Jack Smith #45". I really need remove these numbers. I tried to use Excel formulas, but i found it very difficult since both of these two columns allow multiple choice. Any ways?


Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Filter items with a date column with parameters start date and end date on a sharepoint list?

If I have alist with a view that has the columns Title, Status and Status Date and the view has some items. How Can I add a filter with two parameters, start date and end date, to only show records with status date equal to or greater than parameter start date and status date is less than or equal to parameter end date? This is a sharepoint online site and I can't create and deploy custom code, can use SPD though. Do I need to use SPD or is this something I can do in the list settings? Thanks in advance.   Edit: I had a look here http://www.endusersharepoint.com/2009/09/29/sharepoint-date-filter-filtering-a-list-by-greater-than-or-equal-to-date/ but I don't have the Date Filter web part.

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

scrollbar is not showing for sharepoint list with group by view

Hi, have created a Share point 2007 list having a huge data. I have created a group by view by grouping the data with category. My requirement is to show the data as web part on a page. When i did so, while expanding the group inside the web part, the web part is expanding. I want to keep the height and width of the web part fixed so that the layout of the page will not be ugly looking. But though I am putting the option for fixed height and width in the web part setting but I am not able to see the scroll bars. Where as I can see the height and width are fixed but could see a few data instead of all the data with scroll bar.   Please advice me if there is any solution or workaround.Deeptyranjan

Best way to display data of a single column from a Sharepoint Custom List

I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

MOSS 2007: list column that lookup to multiple documents stored in doc library

Hi All, I'm trying to understand how to customise MOSS to achieve the following: I need to lookup from a list to multiple documents stored in a documetn library. Example: - List item 1 --------> Lookup to Doc 2                   --------> Lookup to Doc 5 - List item 2 --------> Lookup to Doc 3                   --------> Lookup to Doc 5                   --------> Lookup to Doc 8 - List item 3 --------> Lookup to Doc 1 How can I achieve this? is it possible that in the lookup I have a "search" option? Thanks all Vit

Lookup column in the list

I have one list on SharePoint. I want to create another list and one of the columns should pick up values from the other list. However, when I create a new column and select the type as "Lookup (information already on this site) and select my old list in "Get Information from" , I don't see all the columns of the old list but a selected few. Why is that and how can I make sure that in my lookup column in the new list, I see all the columns as I need information from the other columns?

get sharepoint list item column choices using caml

basicallly the title says it all, is there a way to get a sharepoint list's column's choices using CAML query? i'm trying to get the choices using the sharepoint web service

How to get sum of a column from sharepoint list into SSRS(2005)

Hi, I have a about 100 columns created for survey questions. I need to get the sum of each column into SSRS. Can it be done in dataset instead of adding the aggregate expression in the footer of ssrs table. Some research that I have done so far.......Under the sharepoint list there is an option for Total for each columns. I can select the sum option and it appears in the list, but how can I access this sum in SSRS.

Lookup columns in a SharePoint Custom list

Hi, I would like to know the maximum lookup columns we can create in a SharePoint Custom list. Thanks and regards, Usha   

List lookup to document library not showing folder names

Hi all, I've got a Sharepoint List, which has a lookup field to a Document Library on the same site. That document library library is populated with several folders, each with several Word documents within. I want my lookup (in the List) to only display the top level folders in the document library. I managed to do that in my test environment. But in my production environment doesn't list the folder names. I've compared the settings in the two and they look identical. What could be wrong, and how to I fix it so that the folder names appear? I'm using SharePoint 2007. Thanks in advance for the help.

Insert an item in a Lookup column's source List from the NewForm


When Lookup Column of a List does not contain a value in the DropDown menu can it be added/inserted into the source Lookup List from the NewForm without leaving the NewForm? 

Is there code or example how to insert the Item in the source List, then refresh/repopulate the Lookup Column's DropDown menu (in the NewForm)?


Auto Populating SharePoint List Columns based on value in one column

   I have a SharePoint List where I want to auto populate the value of some of the columns from another List based on a field "Title" which is primary & unique....
   I want to auto populate them when clicking "New Item"  and entering data... you put the "Title" value and it should match the Title value from another List and auto-populate some the columns...

   Please any idea would be highly appreciated....

Thanks in advance

its showing weird binary data from the BDC data column in list

Hello Gentlemen,

Here I am experimenting the BDC with a simple example of pulling distinct data from a sql server 2005 to a sharepoint list column "SELECT distinct Color FROM Product" .


when i configured the bdc using Business Data List the data showing correct. But when I use this it in a list column with bdc data type its returnig me the binary type of data.
No exact match was found.

However in the bdc picker the data is displaying properly. The data type in sql is nvarchar. I tried changing different data types but its showing the same kind of it.

Here is the BDC:

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