SharePoint News & Development Resources
DevSharePoint.com provides the latest SharePoint news and resources. Stay up to date with SharePoint 2010, MOSS 2007, WSS, SharePoint Designer (2007/2010), InfoPath.

InfoPath & SharePoint Development Tutorials, Resources & How To’s
InfoPathSharePoint.net provides the latest InfoPath development tutorials, InfoPath Form Services administration tips, tricks and how to’s. InfoPath SharePoint Integration: Integrate InfoPath Forms with SharePoint lists, libraries & workflow.

SharePoint & InfoPath News & Resources
SharePoint Administration, Development, Design & Customization Resources from around the internet. SharePoint & InfoPath News. InfoPath SharePoint Integration. InfoPath Form Template Design. InfoPath Form layouts, design tips & techniques.

SharePoint InfoPath Forms

InfoPath forms can be a powerful tool for collecting organising, processing and submitting data of various types. Data Connections allow an infoPath Form to pull data from multiple data sources, including sharePoint. SharePoint InfoPath Forms can provide a rich interface and additional functionality when manipulating data in SharePoint lists and libraries than when using OOB browser forms.

When using InfoPath to open and complete forms, complex priocessing can be performed without impacting on performance of the SharePoint server as the procing is done by the client. Using SharePoint InfoPath Forms as an Interface to control workflow can provide greater functionality and control over the workflow process. Using an infoPath form to submit data to SharePoint lists can allows data from multiple lists to be updated once processed.

SharePoint InfoPath Forms

InfoPath SharePoint Integration

InfoPath – Update Existing SharePoint List Item Programmatically Using CAML

This article demonstrates how to set up secondary data connections in an InfoPath form to connect to the Lists web service to update an existing item in a SharePoint list. An XML document containing a Collaborative Application Markup Language (CAML) query is sent containing data which will map to specific fields in the specified SharePoint list.

Integrate InfoPath Form with SharePoint Workflow

How to integrate InfoPath forms with workflow in SharePoint to give greater control over the functionality and user interface.

When an InfoPath form is set up to submit to a SharePoint library, fields in the form can be mapped to columns/fields in the SharePoint library, or a content type which is associated with a document library. See Submit InfoPath form to SharePoint List or Library using Content Type for details and an example of how to submit an InfoPath form to a SharePoint document library.

InfoPath – CAML Date Time format in when submitting to a SharePoint list via a Web Service

http://blog-sharepoint.blogspot.com/

InfoPath SharePoint Integration

InfoPath Programming

InfoPath – Programming Tips – InfoPath Form Development

Forum Discussion:

Replicate / Migrate data into sharepoint lists from an external sql database

Solutions for integrating data from an external SQL database in SharePoint. Migrate data from an external database into Sharepoint Lists and libraries, or configure data connections to retreive data directly from the external database to be displayed on pages or stored in SharePoint.

Replicate / Migrate data into sharepoint lists from an external sql database

In an InfoPath Form, I had a Data Connection to a SharePoint list which has almost 500 items.

When I open or preview the form, only 100 items are being returned from the SharePoint list using the Secondary Data Source of the SharePoint data connection.

InfoPath loads items from SharePoint which appear in the default view of the specified list or library. By default, SharePoint limits the total results of a view to 100, which can be changed by modifying the default view.

See InfoPath data connection not returning all results from a SharePoint list for details.

How to integrate InfoPath forms with workflow in SharePoint to give greater control over the functionality and user interface.

Use an InfoPath form as the interface for a workflow in SharePoint to allow greater control over the user interface and functionality. Code can be used in the form which is processed by the client if completing a form using Microsoft InfoPath, or in a browser based InfoPath form supplied using SharePoint Forms Server. This reduces processing requirements of the SharePoint server(s), as well as allowing processing using code without worrying about code blocks in SharePoint.

Integrate InfoPath Form with SharePoint Workflow

Create secondary data connections in an InfoPath form to retrieve the CAML template from an XML file, then submit using a second data connection to the Lists web service on the SharePoint site containing the list being updated.  The CAML template uses the UpdateListItem function from the web service to update an existing item in a SharePoint list.

This article demonstrates how to programmatically update a SharePoint list item from an InfoPath form using a CAML query to the Lists web service of the SharePoint site. The example uses secondary data connections to retrieve the CAML template from an XML file and another to submit the CAML template to a SharePoint web service using the UpdateListItem function.

The process is broken down into the following components, which are explained in detail in the article linked above.

1. Create Initial InfoPath Form
2. Set up the CAML query
3. Set up InfoPath Data Connections
4. Set up the Form Template and Required Code

Optional Steps and additional information:
- Update Repeating Field elements in the CAML Template Programmatically
- How to Submit using a Secondary Data Connection in InfoPath

Update Existing SharePoint List Item

Programmatically loop through each node in an xml data source to find a specific element/node by the attribute value.  This may be required to populate a CAML template before submitting to SharePoint via a web service.  Post comments discuss a scenario where the function provided in the article can be used.

See also InfoPath Code – Loop through items in a secondary data source from a SharePoint List for the details of a solution which implements the function provided in the article, as well as a modified version.