.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

Re: InfoPath 2010 dataconnection to SPList (LookUP field return id)

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


I designed a form in infopath 2010, created a dataconnection to Sharepoint 2010 List, query and data fields include lookup field.

When i expand field tree (Secondry), i can see following data on mouse hover of the field.

MyXYZField (Field)

DataType (Lookup)

Default Type (None)

I then added a dropdown control on the form , using dropdown properties wizard configure MYXYZField as the source.

When i preview the form i only see dropdown filled with LookupID (1,2,3 etc) instead of the text of the dropdown.


I must be missing something here, please help.










View Complete Post

More Related Resource Links

WSS Lists - Lookup field information missing in Excel 2010

Hi, I've got this xls workbook which contains a two-way synchronized SharePoint list. This WSS list contains columns which are related to other lists: for instance the list we're using is a list of assignments, where an assignment is related to an accounting period. Our server also has another list with all accounting periods. Both lists are related since the assignment list as an accounting period column of lookup type which uses the accounting period list as a source. In previous versions of Excel, the output is that the accounting period field is a combobox populated with all availalble accounting periods. Thanks to that, the user can easily link an assignment to an accounting period by selecting a value in this combobox and synchronizing. This works great with Excel 2003 and 2007, however in 2010 (same workbook, consuming the same lists) related information doesn't appear. The combobox is empty and as a consequence the user gets a data validation error since the value in the cell isn't among available values. Is there something special I should do to enable this feature in Excel 2010? Regards, Carl 

dynamic field in infopath 2010



I want to use dynamic field in info path 2010. Imagine for example i have textbox  that user can input desire data.depent on this textbox i want to create dynamic field.

user input below data:

How many books do you need?   3

then i want had been created this table:(I mean this table had been created with 3 row that user input this value, and user can fill ID,Name,Author & Year)

ID     Name        Author      Year

1        book1     Author1     2005

2        book2     Author2     2009

3        book3    Author3      2010

 Anybody can help me?!

thanx alot.

How to use Managed MetaData field (TaxonomyFieldType) in Infopath 2010?


I created a custom list with Managed Metadata field. Then I have to customize the display/edit forms of this list using Infopath 2010. When I click on the Customize Form button, I received this error : the following fields is not support in infopath sharepoint designer.

can anyone let me know whether there is a workaround for this?

Thank you



Infopath 2010 form library - add new field to template

I have a new form library - made some changes used quickpublish and all is good.  I then added a new field (Group) using person/group picker - save form and create a new one - the new field does not show in the Form Library columns - how do I refresh the fields I want to show in my sharepoint form library.  Thank you

How to improve the performance of multiple selection field in Infopath 2010 ?


Hi Infopath experts

I am developing an infopath form that has 4 big multiple selection fields (each field has more than 50 choices). Each time the users select a choice from the muiti-selection field, the form takes a lot of time to response. This only happened with IEs (I am using IE8 now). When I tried it with other browsers (firefox, chrome, safari), the performance increased drastically.

I have seen other people saying that IE has issues with Infopath and IE9 might solve the issues. However, our company won't upgrade to IE9 anytime soon. If anyone has workarounds for this issue, please help me with it

Thank you,



InfoPath 2010 Set field values of multi checkbox based on drop down selection



I have a drop down with e.g values "Fruit", "Veg".I also have checkboxes - "Apple", "Pear", "Orange" ,"Tomato", "Potato". On selection of Fruit i want the checboxes applicable to fruit to be checked. I have a rule at the moment but can only get one checkbox to be ticked. How do i do multiple.

Thanks in advance.




Infopath field promotion issue with lookup


Can anyone help.


I have code which generates a site (libraries, lists and data) and attaches a form library with my form on it.

Everything is working great form opens and saves at each stage of the process etc.

A note due to installing this form and lists etc in a subsite I create the lookup I need in code so I can link the relevent lists etc to each other.

I am now in the final stages of the development and want to promote out some of the form fields to sharepoint however when I do this and then try it on a different site collection to see if the whole solution will install the infopath promoted fields for lookup are always not clickable when viewing the content type.


This is really annoying and I can't be the first to run into this but I can't seem to find a solution to fix it.


Small edit,


The fields I am guessing are grey because I can't edit them as they are read only?

But my lookup on my deployed site are showing as Text fields rather than the Lookup I need so are only displaying the Id of the Lookup value instead of the name...


This is annoying.

Bind Infopath 2010 Form Control to another List Field


Hi, I am having Sharepoint 2010 RTM Enterprise Trial on Windows Server 2008 SP2.

I have Two Lists (List1 and List2) and List2 has a lookup field for List1 ID.

I want to bind some of the controls on infopath form of List1 to List2 fields such that when the user enters the values, these values would be saved in List2 and when the user want to edit the data of List1, the values can be retrieved from List2 on Form Load.

can it be done ?

can it be possible without having a field in List1 (direct binding to List2 field) ?


InfoPath 2010 - decimal field (2digit) converting large number to scientific notation


Hi Everyone,

I hope there is a simple solution to this issue.

We have built an InfoPath form for the web. Data from the form is mapped and written to SQL Server 2008 tables. The values are retrieved when the form is reopened. The form is accessed world wide and uses various currency types. Some of the values that we need in the decimal fields are quite large, e.g. 999,999,999,999,999.00. (we don't use currency sign because different curencies use different signs.)

When the amount shown is entered and saved an error occurs and the values have been converted to scientific notation. The field lengths are long enough for the value but still the scientific notation appears. The largest number that I've been able to enter without it converting is 9,999,999,999.00.

Any thoughts on how this conversion to scientific numbers can be prevented. This only occurs on a web based form.

Thanks in advance for your assistance.



Richard D. Lucky Quatier

SharePoint 2010 SPSiteDataQuery - Get data for Lookup Field



I am trying to get Lookup field using SPDataQuery. But it doesn't retrive data for that column.

query.ViewFields = "<FieldRef Name=Title' /><FieldRef Name=IssueProgress' Type='Lookup' Nullable='true'/>",

I went through the following post


Is there any tweek to get the data from lookup field?

Thanks, Rocky Fernandes

InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

how to add vailidation between library field and infopath


 i have a browser enable form with filed mails ids and cost i am promoting these filed, and it's saving in library  but i need a vailidation when if any when to submit  requets using mail and cost , at  time i need availidation that your mail id is already  exit , i create a receiving connection for mail id fields it received fileds how to i compare it


Infopath form return XMl code during workflow task


1.     Review 7777.xml.

2.     Perform the specific activities required for this task.

Use the Edit this task button to mark the task as completed. (If you cannot update this task, you might not have access to it. Click here to request access.

While Printing an Infopath Form it Prints lot of Blank Spaces Before RichText Field


I had an infopath form with few rich text field. When i copy some content from somewhere and paste in the richtext Box then while Printing the form I get Lot of Blank Spaces Infront of the rich text box.

I tried creating teh print view too but still i get bunch of empty pages printed before by richtext box control.

Is there a way we can remove those blank spaces.....

I am not able to find out what is going wrong here....

Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverlight 3

Learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Video: Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverli

Watch the video that accompanies the MSDN article and learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Video: Field and List Item Validation in SharePoint 2010

SharePoint supports the ability to create Excel-like field validation formulas to validate field data in a list, which greatly reduces the amount of custom code that a developer must create and deploy. (Length: 1:44)
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