Data Connections

Re: Submit Connection to SharePoint List

Hilary Stoupa — Tue, 28 May 2013 15:44:22 GMT

Do you only need to update a single item? You can do this with CAML and a submit data connection to the Lists web service. This blog pretty much covers the steps: http://sharepointknowledgebase.blogspot.com/2011/10/updating-sharepoint-list-by-using.html

However, you want to update an existing item, right? So you'll need:

The ID of the item you want to update
Slightly modified CAML
A way to set the correct CAML field in your 2DS to the value you need so that you can submit as an update

Do you already know the item ID of the item you wish to update?

Re: Submit Connection to SharePoint List

cheason — Tue, 28 May 2013 08:26:34 GMT

Hi Ernesto,

Thanks for that solution - I found the link from that page to be an exact copy (more or less) of this one on the Microsoft pages:

http://msdn.microsoft.com/en-us/library/office/cc162745(v=office.12).aspx#ip2007SubmitDataSPList_AddingaConnectiontotheListsWebServiceandSpecifyingtheParametersoftheUpdateListItemsWebMethod

I'd prefer to have a no-code solution if possible, to avoid the grief of having to go through the loop of publishing an administrator approved form. Do you know if this is possible at all?

All I'm basically looking to do is increment a number in a list each time a form is submitted. Maybe InfoPath isn't exactly the best solution for this?

Thanks, your advice is much appreciated.

Jason.

Note: the code examples required in the solution from your linked page are missing : http://pravahaminfo.blogspot.co.uk/2010/10/submitting-data-from-infopath-2007-to.html

Re: Submit Connection to SharePoint List

ErnestoM — Fri, 24 May 2013 21:18:52 GMT

Hi-

Yes, this is a pretty common question. Here's a blog post covering possible solutions:

http://forums.qdabra.com/2013/05/map-infopath-form-data-to-a-sharepoint-list/

Good luck!

Submit Connection to SharePoint List

cheason — Fri, 24 May 2013 14:25:05 GMT

Hi,

Sorry if this has been asked many times before (I'm sure it has) but are there some simple instructions on how to configure a data connection to update an item in a list?

I've basically got to increment a number in a list on an action within a form and I've just realised I've never really done this before in an InfoPath form.

Thanks,
Jason.