Re: Update Existing SharePoint List Item via Web Service & CAML from InfoPath

Hilary Stoupa — Tue, 18 Jul 2017 14:53:13 GMT

You are 100% sure you have the right field names in your CAML? Perhaps try just setting the Title field to start, comment out the other fields, and see what that gets you.

Re: Update Existing SharePoint List Item via Web Service & CAML from InfoPath

Ligia1982 — Tue, 18 Jul 2017 01:31:01 GMT

Hi, I have followed all the steps carefully, however the data connection is not submitting data to my SharePoint site, even though no error is shown. CALM is verified, GUID is correct, connection is well set up. Have you come across a case like this? I am using SharePoint 2013 and InfoPath 2013. Regards,

Re: Update Existing SharePoint List Item via Web Service & CAML from InfoPath

gins1 — Wed, 30 Oct 2013 15:37:49 GMT

Thank you for these posts, they have been very helpful to address a need for my client. I have this working perfectly in the Preview mode on my desktop, however, when published, the browser form does not update the SP list & provides no errors. Any ideas on why? Thank you in advance.

Re: Update Existing SharePoint List Item via Web Service & CAML from InfoPath

Hilary Stoupa — Thu, 06 Aug 2009 16:30:01 GMT

Thanks for the outline!

Update Existing SharePoint List Item via Web Service & CAML from InfoPath

Daniels — Wed, 05 Aug 2009 02:10:45 GMT

How to Update an Existing SharePoint list item using a CAML Query to the SharePoint Lists web service from an InfoPath form.

The major steps involved are:
1. Create Initial InfoPath Form
Create the initial form template, main data source and retrieve the required details from the SharePoint list

2. Set up the CAML query
Create the CAML query using U2U for assistance with field identifiers. Additional information is provided about column identifiers for SharePoint lists in CAML queries in the post InfoPath CAML - SharePoint column identifiers. If you are updating Date/Time fields (or others which require a specific format) in the SharePoint list, you may find that the CAML query is not updating the SharePoint list item. If the format of a date/time value in a CAML template is incorrect, the update will not take place and any reamining updates will also be ignored. For details about the required date/time format when updating the time component in a SharePoint date/time field, see InfoPath - CAML Date Time format in when submitting to a SharePoint list via a Web Service.

3. Set up InfoPath Data Connections
Set up the data connections required to retrieve the blank CAML template from an XML file and another to subit the data back to SharePoint to update the existing SharePoint list item.

4. Set up the Form Template and Required Code
Set up the template to populate the CAML template with the required values, the submit programmatically using the secondary data connection.

Optional Steps and additional information:

Update Repeating Field elements in the CAML Template Programmatically
This can be useful when you need to set values in the CAML template without displaying a full repeating table with controls. As the CAML template has a repeating "Field" element for eacch field in the SharePoint list that requires updating, you can loop through each element to find the one where the name attribute matches the required.

How to Submit using a Secondary Data Connection in InfoPath
Submitting using Secondary data connections can be useful when you need to submit to multiple locations, or only submit to specific data sources based on form criteria and rules. To do this, secondary data connections can be set up for each required destination, which can then be executed individually using rules attached to form fields and controlls or programmatically.

For full details and additional notes/troubleshooting, see InfoPath - Update Existing SharePoint List Item Programmatically Using CAML.

SharePoint Integration

Re: Update Existing SharePoint List Item via Web Service & CAML from InfoPath

Re: Update Existing SharePoint List Item via Web Service & CAML from InfoPath

Re: Update Existing SharePoint List Item via Web Service & CAML from InfoPath

Re: Update Existing SharePoint List Item via Web Service & CAML from InfoPath

Update Existing SharePoint List Item via Web Service & CAML from InfoPath