AnsweredAssumed Answered

Can I include details from a nintex form in an email, including repeating sections

Question asked by iamwedgie on Mar 13, 2015
Latest reply on Mar 19, 2015 by iamwedgie

I've been working on a fairly simple Form & Workflow solution to address a Travel Request Approval & Booking process. Having overcome my early issues with the initial user interaction on the Approval process I am now faced with a challenge that I need to overcome in order for this process to work. which is as follow.

 

Once a Travel Request has been approved, the details of the request need to be emailed to a 3rd party travel company. On the face of it this would seem to be an easy thing to do. The workflow tool allows the outbound emails to be configured with lots of detail from the Item. However, because the form has been built with Repeating Sections which include the crucial details of the booking request it doesn't appear to me to be possible to include that detail in the email. I tried to embed the Item Property {Current Item:NFFormData}, thinking that this would give me all of the data from the form in a format which would be easily readable. What I actually see in the email which is generated is what appears to be an XML document, as shown below. I can see that the data from the 3 Repeating Sections is contained within this document, but have not identified how I can pull this out separately, am I just not spotting the appropriate Item Properties to use?

 

<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version
/><Items><Item><DeptCity
type="System.String">LHR</DeptCity><f7329c77-d5df-4349-b5e0-e1522e0e230d
type="System.DateTime">03/17/2015 09:00:00</f7329c77-d5df-4349-b5e0-e1522e0e230d><a2a3a6e7-3016-4e17-9c1e-caaf6f5f4bf5
type="System.String">Hong
Kong</a2a3a6e7-3016-4e17-9c1e-caaf6f5f4bf5><_x0038_e159159-0755-4ef8-a9ec-052a6ff22a89
type="System.DateTime">03/18/2015
01:00:00</_x0038_e159159-0755-4ef8-a9ec-052a6ff22a89><_x0031_49801de-d768-4dc5-a872-971a3505f041
type="System.String">Standard</_x0031_49801de-d768-4dc5-a872-971a3505f041><_x0035_48308ca-909e-4e83-b27f-17001263baec
type="System.String">QA123</_x0035_48308ca-909e-4e83-b27f-17001263baec></Item><Item><DeptCity
type="System.String">Hong
Kong</DeptCity><f7329c77-d5df-4349-b5e0-e1522e0e230d
type="System.DateTime">03/24/2015
12:00:00</f7329c77-d5df-4349-b5e0-e1522e0e230d><a2a3a6e7-3016-4e17-9c1e-caaf6f5f4bf5
type="System.String">LHR</a2a3a6e7-3016-4e17-9c1e-caaf6f5f4bf5><_x0038_e159159-0755-4ef8-a9ec-052a6ff22a89
type="System.DateTime">03/24/2015
17:00:00</_x0038_e159159-0755-4ef8-a9ec-052a6ff22a89><_x0031_49801de-d768-4dc5-a872-971a3505f041
type="System.String">Standard</_x0031_49801de-d768-4dc5-a872-971a3505f041><_x0035_48308ca-909e-4e83-b27f-17001263baec
type=&quot;System.String&quot;&gt;QA234&lt;/_x0035_48308ca-909e-4e83-b27f-17001263baec&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;<_x0039_2ec4e8c-8f2e-47ff-bb62-03e9727d2b24
type="System.String">&lt;?xml version=&quot;1.0&quot;
encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version
/&gt;&lt;Items&gt;&lt;Item&gt;&lt;c8f15100-b525-4345-945d-31f55ad5cde5
type=&quot;System.String&quot;&gt;Tuk Tuk&lt;/c8f15100-b525-4345-945d-31f55ad5cde5&gt;&lt;_x0032_2e6565d-142f-439f-bc5c-baa5985caabf
type=&quot;System.String&quot;&gt;Airport&lt;/_x0032_2e6565d-142f-439f-bc5c-baa5985caabf&gt;&lt;_x0039_56f2800-630b-44b5-a5e1-26d4b0160347
type=&quot;System.String&quot;&gt;Hotel&lt;/_x0039_56f2800-630b-44b5-a5e1-26d4b0160347&gt;&lt;fc08afcc-7266-47e6-8630-2da56747763a
type=&quot;System.DateTime&quot;&gt;03/17/2015
00:00:00&lt;/fc08afcc-7266-47e6-8630-2da56747763a&gt;&lt;_x0036_8cfd40c-38b8-4c3e-84d4-18fd95866b58
type=&quot;System.DateTime&quot;&gt;03/17/2015
00:00:00&lt;/_x0036_8cfd40c-38b8-4c3e-84d4-18fd95866b58&gt;&lt;d2d4fdd5-53ed-4a0a-b548-589dc95ffa47
type=&quot;System.Decimal&quot;&gt;5&lt;/d2d4fdd5-53ed-4a0a-b548-589dc95ffa47&gt;&lt;/Item&gt;&lt;Item&gt;&lt;c8f15100-b525-4345-945d-31f55ad5cde5
type=&quot;System.String&quot;&gt;Tuk Tuk&lt;/c8f15100-b525-4345-945d-31f55ad5cde5&gt;&lt;_x0032_2e6565d-142f-439f-bc5c-baa5985caabf
type=&quot;System.String&quot;&gt;Hotel&lt;/_x0032_2e6565d-142f-439f-bc5c-baa5985caabf&gt;&lt;_x0039_56f2800-630b-44b5-a5e1-26d4b0160347
type=&quot;System.String&quot;&gt;Airport&lt;/_x0039_56f2800-630b-44b5-a5e1-26d4b0160347&gt;&lt;fc08afcc-7266-47e6-8630-2da56747763a
type=&quot;System.DateTime&quot;&gt;03/24/2015
00:00:00&lt;/fc08afcc-7266-47e6-8630-2da56747763a&gt;&lt;_x0036_8cfd40c-38b8-4c3e-84d4-18fd95866b58
type=&quot;System.DateTime&quot;&gt;03/24/2015
00:00:00&lt;/_x0036_8cfd40c-38b8-4c3e-84d4-18fd95866b58&gt;&lt;d2d4fdd5-53ed-4a0a-b548-589dc95ffa47
type=&quot;System.Decimal&quot;&gt;5&lt;/d2d4fdd5-53ed-4a0a-b548-589dc95ffa47&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;<_x0035_9d02b67-6b4c-4d2b-a561-05482223e7f5
type="System.String">&lt;?xml version=&quot;1.0&quot;
encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version
/&gt;&lt;Items&gt;&lt;Item&gt;&lt;_x0038_6ac4191-0447-4011-9b21-0fdf3bd778b2
type=&quot;System.String&quot;&gt;Hong
Kong&lt;/_x0038_6ac4191-0447-4011-9b21-0fdf3bd778b2&gt;&lt;aee37b04-e85d-413a-829c-b097eb5f911d
type=&quot;System.String&quot;&gt;Kow Loon
Hilton&lt;/aee37b04-e85d-413a-829c-b097eb5f911d&gt;&lt;_x0032_57d1867-bdd1-4d86-905a-e036a02347ac
type=&quot;System.String&quot;&gt;Large&lt;/_x0032_57d1867-bdd1-4d86-905a-e036a02347ac&gt;&lt;aaac66aa-e9d7-42f6-8759-cba35246d765
type=&quot;System.DateTime&quot;&gt;03/17/2015
00:00:00&lt;/aaac66aa-e9d7-42f6-8759-cba35246d765&gt;&lt;ebb440c4-65cb-4d8c-bc20-26a6b0f4a475
type=&quot;System.Int32&quot;&gt;6&lt;/ebb440c4-65cb-4d8c-bc20-26a6b0f4a475&gt;&lt;f4dd1054-7660-4f14-8ec7-6b512a5a8475
type=&quot;System.Decimal&quot;&gt;80&lt;/f4dd1054-7660-4f14-8ec7-6b512a5a8475&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt

Outcomes