I have a form with repeating sections, which allows the submitter to enter details for multiple products, and multiple markets related to those products (e.g. details for Product Name A - Argentina , Product Name A - Chile, etc.). I've managed to clean up the form XML (using the Regular Expression actions) and dump into a column, and now I'm left with a block of XML - see screengrab.
What I want to do now is separate out this data to update different fields in different lists - e.g. for Product Name A, I want to create a line item in the Argentina list called, "Product Name A" and update all the appropriate #'s (e.g. Retail, Wholesale, etc.), and then do the same for the Chile list, then repeat for "Product Name B", etc.
How do I go about locating and extracting just the data for a specific product in a specific market from the XML to update a specific list?
Thanks Simon. I totally have this working, but it's working using the cleaned up XML in my screengrab. Above, v-tmasenko is saying there's no need to do this, but I couldn't get it to work by just pointing to NFFormData. I'd prefer to not clean the XML, but it sounds like maybe v-tmasenko's referring to Nintex On Prem? (Note: I wasn't sure whether to post to "SharePoint" or "Office365": is "SharePoint" specifically for On Prem SharePoint?).