There are several article about parsing XML and putting in a table format or creating a child list. I need to parse the XML and put each of the 3 columns in 3 separate columns in order to show history and export to Excel. I have the workflow working and putting the 3 columns in 3 separate columns. What I cant figure out is how to keep the history and it to export correctly. I tried using append on the columns but it will only export the last entry.
How to parse XML and place values in single columns
+3
+3Attached is the Query Action XML and the XML. Each time the item is updated, the user wants to have a log of the changes.
so. to clarify
- is that repeating section (posted XML) your change history log which you want turn into a table? but you get just last repeating section's row stored into a separate list and its columns?
- or do you mean it you have a repeating section with 3 controls and you want to get change history log for each control independently and store it in a separate list, but you get just last/actual value for each control?
+3Have a repeating section with 3 controls and you want to get change history log for each control independently and store it in a separate column, but you get just last/actual value for each control
Thanks,
Sandy
Sandy Koch, BB&T Vice President
Enterprise Data Office
Wilson, NC
252-373-9293
skoch@bbandt.com<mailto:skoch@bbandt.com>
#WeCreateWOW, #AWSIY
well, that will be challenging task...
there is no OOTB way that would keep change history in this way. only change history for whole multiline text list field which the repeating section is connected to is maintained by sharepoint.
so you will have get list field change history, parse it on your own and identify what were changes in single fields.
here you can find an example how you could get version history for multiline text field
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.