Hi All, I've managed to create a responsive form with a repeating section which has two columns called "action" and "action owner" linked to it. A sample of the XML output is below:
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><ActionOwner type="System.String">i:0#.w|<<Domain>>\432XXXXX</ActionOwner><Action type="System.String">This is the first action.</Action></Item><Item><ActionOwner type="System.String">i:0#.w|<<Domain>>\432XXXXX</ActionOwner><Action type="System.String">This is the second action.</Action></Item><Item><ActionOwner type="System.String">i:0#.w|<<Domain>>\byrXXXX</ActionOwner><Action type="System.String">This is the 3rd action.</Action></Item></Items></RepeaterData>
I've created a workflow to query the XML and the results I get are as follows:
Output 1
i:0#.w|<<Domain>>\432XXXXX
i:0#.w|<<Domain>>\432XXXXX
i:0#.w|<<Domain>>\byXXXX
Output 2
This is the first action.
This is the second action.
This is the 3rd action.
I then use a "For Each" loop to extract the collection data from "Action Owner" in to a variable and I do the same for the "Action" column also in to a separate variable. However, this is where I think I'm going wrong and require some assistance please.
I would like to create 3 new items on a separate list. Essentially this list will allow me to track actions from meeting minutes that have been assigned. So far I've been able to use the "Create Items" functionality to create 3 separate items against the three different Action Owners but the action associated to these three items is always showing as the last one in the list (for example):
ID Action Owner Action
Item 1 Name 1 This is the 3rd action.
Item 2 Name 2 This is the 3rd action.
Item 3 Name 3 This is the 3rd action.
I've looked at collections, loops, regex etc but I can't seem to figure out how to do this next bit. Any help / guidance would be most appreciated.
Thanks in advance
Sean