.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

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

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

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


View Complete Post

More Related Resource Links

External Lists and Infopath forms issue with Secondary Data Sources

I've followed this tutorial for creating and customising forms for external data (http://blogs.msdn.com/infopath/archive/2010/03/11/customize-an-external-list-form-in-infopath-2010.aspx).  The only difference being that my seconday data source is not an XML file (I've tried database connection and existing sharepoint lists both internal and external) When running the design checker I get the message "Additional Data connections not supported" and my form won't publish.  Any ideas?

xml secondary data source used for drop down selection how do I return additional fields to form bas


I received some much needed assistance from this forum in the past. My current situation is that I have a xml data connection to a sharepoint list over an employee database that works fine. It allow me to connect to a view on the sharepoint list correctly and display the info which is a drop down on a last name field. I now need to be able to select a last name such as Doe and have other fields such as job code be populated on the form from the same sharepoing list I have already connected to. Any direction is greatly appreciated.



Projected Fields not available in InfoPath data connections


Projected fields are a nice way to join lists and show fields from related lists in the same view without physically duplicating fields. Unfortunately, these projected fields are not available in InfoPath data connections. I am now tempted to duplicate data and to maintain physical copies of fields in multiple lists to overcome this limitation, but it makes me uneasy ;-) 

I must add, the InfoPath form is a list based form without code behind. 

If you guys have a better idea, please let me know. thanks.


InfoPath: Copying values from a multiple-selection lookup (secondary data connection) to a multiple-

Trying to use "Set Field Value" action in InfoPath to set values in a multiple selection lookup field. Does not not seem to be possible. Has anyone achieved this?

wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on


Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

Infopath Data Connections and Submit

We are in the process of shifting our draft system from SP 2007 to SP 2010 and we are re-visiting our Infopath forms service. Admin approved IP forms,  the templates emailed to our 12 remote 'offices' 12 Site collections -identical structure for remote locations 12 Remote user locations, never connected! ,fills in the form, selects own site, and emails back to office Custom button on form with rules reads 'selected site' and uses appropiate data connection to submit to correct Site Collection/Form Library. We are only using 1 site at the moment but obviously with 12 sites it becomes unmanagable, my thoughts;- Can we use a web service to act as an intermediary to point to correct library? Would a dataconnection library help?, or is the amount of work the same? ??? casey  

InfoPath 2010, Multiple Repeating Sections have same name, Diff data connections using same SQL Serv

I've created an InfoPath 2010 form that has three Repeating sections and each one uses a different data connection but all three connections use the same table in SQL Server... "Accounts".  Now you might ask why I would do this? Well I need different sets of data in each section and it all resides in the same table in the repository. Also, sometimes one section will not have information and I do not want a bunch of blank fields displaying in the repeating section. So I split the data into separate sections. Now here is the challenge for you guru's out there. :) I want to use one column in the 3rd repeating section  to refer back to another column in the first repeating section.(for referential integrity) Unfortunately since they both use the same table in the database they possess the same name under advanced view:  myFields/dataFields "d_:Accounts". In fact all three of my repeating sections have the same name based upon the database table used in the data connection. In the SQL statement I attempted to rename each of the connections via the statement. I have not tried to give the table an alias in the statement yet. Will try that one next. 1. Is there a simple way to rename the repeating Section from "d_:Accounts" to something else so that  they are each unique? (Without using backend code as I've only used InfoPath/SP/S

SharePoint 2010 External Content Type and InfoPath 2010 - Numeric data type fields missing in InfoPa


Connected SQL data table to SP 2010 ECT from SQL table.  The SQL table has several fields that have a type of "numeric(3,0)".  The SP 2010 list shows all fields form SQL.  When we open up InfoPath Designer and reference the SP List data (from SQL) all of our numer fields are missing from the available fields list.

I amd going to try another data type but that hardly feels like a solution.  If anyone has any ideas please let me know!

Infopath form updating from secondary data connection initally, then not!


Let me set up what I am doing...

I have a table with multiple text boxes. Each of these text boxes pulls a total for it's corresponding item from a SharePoint List. Each item has 3 boxes that return three different totals.(Filters correctly into This week, This month, and Year to date).

When I open the InfoPath form initially all the columns return the correct totals. Now If I edit the date created on an item; so that it was created last month. Nothing changes on my infopath form. The created this month total remains the same.

I have my data connection set to update everytime a form is opened.

What am i missing?


Sorting or Grouping by "External Data" columns secondary fields - only possible for certain value ty


I have a BCS connection to an external system that provides various external data types.

I'm now adding an "External Data" column to a SharePoint list, selecting multiple fields of an external data type to be added as list columns. These fields have different data types, in my case string, DataTime and Boolean.

Editing the list view settings, I can only select the external entity as a whole, or it's Boolean fields for either "Sort By" or "Group By". The other fields are not offered for selection.

Is there any restrictions on which secondary fields of an external data type are supported for either sorting or grouping? Or is there something wrong in the definition of some of the external data type fields?

Thanks in advance for any help on this issue...

Data Connections Stopped Working In Infopath 2010


I have an Infopath 2007 web enabled form that I converted to Infopath 2010.  I also converted the data connection to 2010.  The server is also SP2010.  Now when the form is accessed via the browser the following error occurs.

"You do not have permissions to access a SharePoint list that contains data required for this form to function correctly."

It works ok in preview mode.  And nothing else has changed.  The production 2007 Infopath version of this form still works.  Security is set to "Domain".  And there is no issue with access to the data connection list.  What am I missing? 

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


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

Best way to get anonymous InfoPath data into multiple lists/libraries?


I'm trying to figure out the best way to create a solution for the situation I have.  I'm still pretty new to SharePoint, and very new to InfoPath.  I'm working with MOSS 2007 and I've created a browser-enabled InfoPath 2007 form that I need to make available to both anonymous users at the top level of my site, and AD authenticated users from within a secured site collection.  It will be important for me to be able to determine whether the form is being submitted by an anonymous or authenticated user, as it will have some fields that need to be handled differently in each case.  Once the forms are submitted, I need to be able to store them in a forms library in the secured site collection, and also create a list item in the top level site with some of the basic info from the form.  That list will be visible and searchable for the anonymous users.

After searching through this forum, I've found at least 2 possible ways for anonymous users to submit forms to a form library.  Right now I'm leaning towards having it submit to a web service which would handle the task of moving/copying the data to the proper places.  Would that be the best solution in this case, or am I missing something?

The next thing I'm not sure about is what my options are for presenting the form 

Infopath will not allow to customize list forms if the list contains lookup fields with "link to ite


I am posting this here, because the error message is a little misleading: It will say that you may have an incompatible field types, corrupt fields, or fields are mandatory and should not be. As a remedy it's suggested to either make them non-mandatory fields or to delete them and recreate them.

Solution: Just lookup to your field without the "link to item" option. 


Programatically add data connections to the infopath form



I have 5 data connections in infopath form and performing some sharepoint list filtering in the browser based form using "owssvr.dll" in xml format  and set as data source for respective controls on the form. Is there anyway to chaneg the data connections (i.e. xml path) at run time? Because everytime I move from development to test and production, need to change the data source xml path as well filed's data sources on the form. Hope you guys understand my problem. Thanks in advance to all.

How to remove data connections dependancy from infopath forms?


Hi All,

In my Infopath forms there are hard coded data connections.

For example GetUserProfileByName data connection has url http://site_url:port/_vti_bin//UserProfileService.asmx?WSDL. Every time I want to publish the form to different site url, port, I have to modify such data connections. Is there any way to remove this dependacy or make it configurable from some central location.


Rahul Babar

Dot Net, Sharepoint, Infopath Developer

InfoPath 2003 - Populate Data Field based on text field from secondary/different data source.


I have a form where the main fields are populated based on the results of a query field.
Ex, Main Data (SQL) Source: 

Fruit         Color
Apple       Red
Orange     Orange
Pear         Green
Banana     Yellow

Secondary Data Source (Sharepoint List)
Fruit         Code
Apple        1001
Orange     1002
Pear         1003
Banana     1004

What I would like to do is create form fields that will automatically populate based on the contents of the text field.
Ex,  (text field)   Please enter your fruit of choice:   [ Apple ]

(Field 2 - from main SQL data source)          The color of your fruit is [ RED ]

(Field 3 - from secondary Sharepoint List data source)  Your fruits code is  [ 1001 ]


Any suggestions would be greatly appreciated.

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