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

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.

This article provides details, instructions and a function to convert date/time field values into ISO 8601 format when updating date/time fields in a SharePoint list using a CAML query from an InfoPath form.  When updating a SharePoint list item using a CAML query, the date/time field must be in the correct format or the field in the SharePoint list item will not be updated.  Any XML elements in the CAML template after the element containing the incorrectly formatted date/time value will not have an affect on the SharePoint list item either.

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