AnsweredAssumed Answered

XML Query with Repeating Section

Question asked by sarasafari on Mar 3, 2018
Latest reply on Mar 5, 2018 by emha

Hi everyone,

 

I have a repeated section, with a few columns inside. the format of XML is like this:


<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><AssignedTo type="System.String">i:0#.w|nd\ssafari</AssignedTo><RequiredAction type="System.String">Make the plan </RequiredAction><TargetCompletionDate type="System.String"></TargetCompletionDate><Completed type="System.Boolean">False</Completed><CompletedBy type="System.String"></CompletedBy><ActionsCompletionStatusandComments type="System.String"></ActionsCompletionStatusandComments></Item><Item><AssignedTo type="System.String">i:0#.w|tf\pnick</AssignedTo><RequiredAction type="System.String">Review for release</RequiredAction><TargetCompletionDate type="System.String"></TargetCompletionDate><Completed type="System.Boolean">False</Completed><CompletedBy type="System.String"></CompletedBy><ActionsCompletionStatusandComments type="System.String"></ActionsCompletionStatusandComments></Item></Items></RepeaterData>

I need to assign a flexi task to each AssignedTo and include the required action in the task notification. In XML query I put the value of AssignedTo in a Collection variable(colAssignees) and the value of RequiredAction (colActions) in another collection.

 

I can do a foreach to get the value of each AssigneTo, but I cannot figure out how can I get Required action for each AssignedTo as well 

 

Really appreciated if someone can walk me through to solve this mystery.

 

Thanks

Outcomes