SharePoint Development & Administration + InfoPath

InfoPath provides a rich set of capabilities for integrating with SharePoint.  This includes the ability to easily configure data connections to retrieve or submit data to SharePoint without the use of code.  When the lists and libraries being queried from InfoPath become large, the InfoPath form can become slow when working with the results from data connections.  This is more apparent if the form is being displayed in a browser using InfoPath Form Services, at the results of the query must be rendered into HTML, sent to the client and updated in the browser. Many of the solutions that I have built in the past required variation to the process depending on if data exists in SharePoint, or if the data falls within specific ranges or explicit values.  To do this, code was used to loop through the results of the secondary data sources to find the required records.  This can become slow very quickly once there are a large number of documents of items in the Share...

The following article demonstrates how to integrate an InfoPath form with a SharePoint form library, using a centralised template stored in a SharePoint document library and linked to a site Content Type. The form is set up to submit to a SharePoint form library Overview: Set up SharePoint libraries Design the form template Publish form template to SharePoint Content Type Configure the form's primary data connection to submit to the SharePoint library Secondary Data Connections to receive or submit data to a SharePoint list Setting up SharePoint to store the Form template and receive Submitted forms: If InfoPath Form services are available on your SharePoint server, you have the option to store the form template using Central Administration's managed templates list. To make the form available using this method it must uploaded to the Managed Templates List, the activated for the required site collection. In this example I publish the form template to a ...