-
Okay - so you need to change your code so you aren't trying to get something not in the main data source. Try my suggestion above.
-
Or perhaps you are trying to access data in the main data source? Is that the case? In which case you would use something like:
Dim Nav As XPathNavigator = Me.MainDataSource.CreateNavigator()
-
The error is:
An item with the following index does not exist in the collection: PartsListUpdate
This indicates you are referencing a data source incorrectly.
It would appear that this line is throwing the error:
Dim Nav As XPathNavigator = Me.DataSources("PartsListUpdate").CreateNavigator()
Do you see how you are trying to ...
-
That error message tells you this line is wrong:
Dim Nav As XPathNavigator = Me.DataSources("PartsListUpdate").CreateNavigator()
Bolded the issue - what is the actual name of the data source?
Do you know how to run your code in debug so you can walk through this while it is running?
-
My guess would be that starting from here:
If Selecta = "True" Then
You'd need to change your XPaths and your namespace. What have you tried?
-
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 ...
-
Actually, SharePoint stores the data as a decimal type. There are display options in a view to allow you to not display the decimals, but they are there.... And InfoPath is just brining back the data.
So - generally, if the decimals are making a mess for me, I use substring-before to get rid of everything before the "." if I am using ...
-
Well - wouldn't the code be similar? I don't really understand what the issue is. You are currently successfully copying data from one data source to another with your code? But you can't modify the code to copy to the main data source?
-
Hi - so your screenshot shows that you now have the Case Id in the data source - does that contain the info that you need? Is Case Id going to be "GEN-000002" and so on? Can you just attach your template so I can help w/ the formula? If not, can you copy the XPath for the new field of Case Id in your secondary data source and paste ...
-
Wonderful! Glad you got it figured out!