cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How to parse XML and place values in single columns

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.Image of 3 columns with append

Tags (1)
0 Kudos
Reply
5 Replies
Workflow Hero

Re: How to parse XML and place values in single columns

can you a sample of your XML?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: How to parse XML and place values in single columns

Attached is the Query Action XML and the XML.  Each time the item is updated, the user wants to have a log of the changes.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: How to parse XML and place values in single columns

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?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: How to parse XML and place values in single columns

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 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

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: How to parse XML and place values in single columns

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

https://community.nintex.com/message/55360-re-extract-last-update-from-versioned-multi-line-text-fie... 

0 Kudos
Accept as Solution Reply