cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

parse xml to sharepoint list

Jump to solution

I have a Nintex Form (2013) with a Repeating Section "Milestones" in a SharePoint List that has two field "MSDate", "MSDetail".

I want to extract those records from the XML and add them to a separate SharePoint List.

I have found lots of references to parsing XML but nothing that is simple or works!

Can anyone direct me to a step by step guide to extracting the XML data and adding to a sharepoint list.

Tags (1)
Reply
9 Replies
Highlighted
Automation Master
Automation Master

Re: parse xml to sharepoint list

Jump to solution

see this blog  

Reply
Highlighted
Nintex Newbie

Re: parse xml to sharepoint list

Jump to solution

The problem is that none of these posts show exactly what I should be configuring in the acitons, and switching between the various posts....I can see what actions I need but now how to configure them. All I am looking for is a very simple step by step process, explaining how each task should be configured.Vadiims has lots of screen shots and no details and the other post skips the starting tasks....

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: parse xml to sharepoint list

Jump to solution

you will hardly find an example that would exactly fit to your specific case, since nobody knows your specifics, setup naming, etc.

if you are not able to make it working out of example here on forum, then you have to provide details what exactly you are trying to achieve, how do you proceed, how do you have set up single actions, what's working, what's not, what errors you get, etc.

based on those information we might navigate you how to make it working.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: parse xml to sharepoint list

Jump to solution

1. I have a list which has a XML from a repeating section of a Nintex Form. The XML has two fields MSDate and MSDetail

2. I want to extract each of the repeating section lines into a new SharePoint List as separate itmes

e.g. ID   Milestone Date      Milestone Details

       1    30/06/2017            Milestone number 1

       2    01/07/2017            Milestone number two

3. I created the XML query  

3. But then I am not sure of the next steps to get each of the line items and insert them into a new sharepoint list

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: parse xml to sharepoint list

Jump to solution

ok, that's a good start

first, just for sure, is ValMsDate variable a collection variable? if not then make it collection. only collection variable will be able to capture all the repeater rows. with scalar variable you will get just first row.

do likewise for MSDetail result set

next steps you need to perform

- configure for each loop over one one collections (doesn't matter which one), eg.

within the action save value of current collection element and current index into scalar variables

- next use collection operation to similarly get value of MsDetail, eg

an element in the other collection at the same index position will hold the value of Detail field from the same repeater row.

- now once you stored single row values in scalar variables you need to use create item action.

I'm not sure about setup of your list, so hopefully you will manage to configure it on your own.

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: parse xml to sharepoint list

Jump to solution

Thank you so much for this Marian....this is exactly what I was trying to achieve. I might document it all in step by step a repost on Nintex for other users. REgards

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: parse xml to sharepoint list

Jump to solution

Great!

If that answered your question please mark a correct answer

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: parse xml to sharepoint list

Jump to solution

Could you please export and send the workflow and form to me? I am struggling with parsing the XML. I referred to many post but I am not able to successfully parse the XML. Thank you!

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: parse xml to sharepoint list

Jump to solution

Hi @michael_campbel , would you be able to document the entire process? I'm struggling here cannot seem to figure it out. 

0 Kudos
Reply