Happy Holidays! I'm hoping someone is still around to help with my latest little issue keeping me up at night :-)
This option of submitting with the SubmitTrigger, XML and dataconnection to create new SharePoint list items is working great for me. Now I'm taking the next step of having a user request changes on the orginal form that can then "update" the existing SharePoint list items that were created using this method.
The process is; When the user saves potential changes, someone is notified via workflow that changes have been submitted. The admin can then approve the changes by clicking a button that will follow the same steps i used to create the list items, but the XML File uses the " Cmd="Update" instead of "New" for this process to update the existing list items instead of create new.
The issue that I'm having is that the ID won't change for each line in the repeating table...so if I have 3 items that need to be updated, it updates the Item with ID=225 3 times (with information from each row in the repeating table), instead of updating ID=225 with it's data, 226 with it's data and 227 with it's data. The XML for every other field is set to the value expected from the current line in the repeating table except for ID.
The rule looks like this when the "SubmitChanges" field changes (the button sets it to "1" - I couldn't upload an image):
Set a field's value: Field[@Name = "ID"] = ID
Set a field's value: Field[@Name = "ProjectName"] = ProjectName
Set a field's value: Field[@Name = "ProjectManager"] = concat("-1;#", AccountId)
Submit using a data connection: UpdateDataConnection
The next rule updates the "SubmitChanges" field to +1.
The XML in Fiddler shows me that the ID stays the same for each row...the rest of the fields change to the correct values for their corresponding rows. So my question is "How do I get the ID Field to change for each update so that the correct list item is updated, instead of the same one getting overwritten 3 times?"
I've tried a filter where ServerName of the datasource that displays the ListItemID = ServerName of Current row, but that did nothing. Any suggestions would be greatly appreciated!!!!