Re: How to add item(s) to 2 Sharepoint Lists?

Gennady Vanin (Геннадий Ванин, Новосибирск) — Sat, 18 Aug 2012 09:16:56 GMT

esb1922:
On Submit I need not only to add an item to the Library but also to add one item to the List1 and multiple items to the List2
I use 2 CAMLs and 2 web service connections (having 2 fields on the form with lists' GUIDs). Something like this -
Dim batch1 As XPathNavigator = DataSources("CamlAddToItemDetails").CreateNavigator()batch1.SelectSingleNode("/Batch/Method/Field[@Name='ItemId']", NamespaceManager).SetValue(ItemId)batch1.SelectSingleNode("/Batch/Method/Field[@Name='Commodity']", NamespaceManager).SetValue(Commod)DataConnections("WebServiceSubmitToItemDetails").Execute() ‘Loop to Add multiple rows to the second list While (condition)'Get vars step, stepOrder, etcDim batch2 As XPathNavigator = DataSources("CamlAddToItemSteps").CreateNavigator()batch2.SelectSingleNode("/Batch/Method/Field[@Name='ItemId']", NamespaceManager).SetValue(ItemId)batch2.SelectSingleNode("/Batch/Method/Field[@Name='Step']", NamespaceManager).SetValue(step)batch2.SelectSingleNode("/Batch/Method/Field[@Name='StepOrder']", NamespaceManager).SetValue(stepOrder) MessageBox.Show(vars to add) DataConnections("WebServiceSubmitToItemSteps").Execute()End While

Items in the first list are created with no problem and the second CAML fails to add but I don't get any error messages. What could that be?

You have 2 webservice connections but execute in code only one...

How to add item(s) to 2 Sharepoint Lists?

esb1922 — Fri, 17 Aug 2012 15:53:21 GMT

On Submit I need not only to add an item to the Library but also to add one item to the List1 and multiple items to the List2
I use 2 CAMLs and 2 web service connections (having 2 fields on the form with lists' GUIDs). Something like this -

Dim batch1 As XPathNavigator = DataSources("CamlAddToItemDetails").CreateNavigator()batch1.SelectSingleNode("/Batch/Method/Field[@Name='ItemId']", NamespaceManager).SetValue(ItemId)batch1.SelectSingleNode("/Batch/Method/Field[@Name='Commodity']", NamespaceManager).SetValue(Commod)DataConnections("WebServiceSubmitToItemDetails").Execute() ‘Loop to Add multiple rows to the second list While (condition)'Get vars step, stepOrder, etcDim batch2 As XPathNavigator = DataSources("CamlAddToItemSteps").CreateNavigator()batch2.SelectSingleNode("/Batch/Method/Field[@Name='ItemId']", NamespaceManager).SetValue(ItemId)batch2.SelectSingleNode("/Batch/Method/Field[@Name='Step']", NamespaceManager).SetValue(step)batch2.SelectSingleNode("/Batch/Method/Field[@Name='StepOrder']", NamespaceManager).SetValue(stepOrder) MessageBox.Show(vars to add) DataConnections("WebServiceSubmitToItemSteps").Execute()End While

Items in the first list are created with no problem and the second CAML fails to add but I don't get any error messages. What could that be?

SharePoint Integration

Re: How to add item(s) to 2 Sharepoint Lists?

How to add item(s) to 2 Sharepoint Lists?