Skip to main content

Hi,

 

I am hoping someone will be able to assist.

 

We currently have a form that is held in Nintex Forms for Office 365 which has Multiple (many) repeating sections in it. At current, we have a Nintex Workflow for Office 365 which handles the multiple repeating sections and then uses Document Generation to, well, generate a document.

 

I am currently trying to upgrade our workflow to Nintex Automation cloud using the Start Event - Update SharePoint List item. 

 

The issue I am having is trying to convert the xml of the repeating sections that are captured in SharePoint into a collection that can then be tagged in the template we have for the document generation. 

Previously, with Nintex Workflow for Office 365, you were able to build tables in the Document Generation action from the queried XML data (done earlier in the workflow) and then use those tables to tag in the template, but on Nintex Automation Cloud, this feature has been removed.

 

We still want to create a table repeating data format for each repeating section for the template, but I can’t find a way to build a collection that The Document Generation action will like with the XML we have. I have tried building a table, but the Document Generation action won’t accept a data table as an option for the repeating data.

 

Please see below an example of the XML we have for this:

<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version>1.0</Version><Items><Item><_963571c5ced468e73e23547ec38ede51 type="System.String">Toxic substances</_963571c5ced468e73e23547ec38ede51><_27e9142d4b15c3940fdefdfd120cdfea type="System.String">Not Known 2590</_27e9142d4b15c3940fdefdfd120cdfea><_ae1c100f6397f035e2f810b64f38c0b1 type="System.String">Roof Sheets</_ae1c100f6397f035e2f810b64f38c0b1><_a3210a3533e9f4926992a90c7b0d6a88 type="System.String">Numerous on site</_a3210a3533e9f4926992a90c7b0d6a88><_37cb9c2f881584facfe1578571ffc5ec type="System.String">Used as roofing material</_37cb9c2f881584facfe1578571ffc5ec></Item><Item><_963571c5ced468e73e23547ec38ede51 type="System.String">Gasses</_963571c5ced468e73e23547ec38ede51><_27e9142d4b15c3940fdefdfd120cdfea type="System.String">Propane UN 1011</_27e9142d4b15c3940fdefdfd120cdfea><_ae1c100f6397f035e2f810b64f38c0b1 type="System.String">Clyinder</_ae1c100f6397f035e2f810b64f38c0b1><_a3210a3533e9f4926992a90c7b0d6a88 type="System.String">100KG</_a3210a3533e9f4926992a90c7b0d6a88><_37cb9c2f881584facfe1578571ffc5ec type="System.String">Shed on right hand side</_37cb9c2f881584facfe1578571ffc5ec></Item></Items></RepeaterData>

 

I want this to then be formatted into a collection that can be output in the following template:

(Ignore <<ItemProperty_OnSiteHazMat>>, this is a separate property)

 

Any help would be appreciated.

 

Thanks,

 

 

Hi @ConradWilkie20,

Each row of your table section needs to have its own collection variable.
This means you must use 4 Query XML actions to collect each cell.
This image shows how to collect the Type:. You need to do the same for the storage quantity and location.
 


This section of the help files shows you how to repeat tables.
https://help.nintex.com/en-US/nwc/Content/Designer/Actions/GenerateDocument-RepeatDataMSWord.htm#Tables

Hi @ConradWilkie20 have you resolved this question? 

Hi @SimonMuntz,

 

Thank you for your reply!

I have done something similar in my workflow already, See below:

But when trying to tag the document, that is where the main difficulty is!

 

Previously, in Nintex Workflow For Office 365, after using the Query XML action to extract all the text values needed, when configuring the Document Generation action, you were able to build the tables using the variables of extracted data, which made tagging the document much easier! See image below:

 

 

With the new Document Generation Action in Nintex Automation Cloud, this feature isn’t available, so I have no way of building the tables of data needed for my document template.

 

Are you able to provide some guidance on how to achieve the above to replicate the tables in Nintex Workflow for Office 365?

 

Thanks,

 

ConradWilkie

Hi @ConradWilkie20,

Once you have the 4 collections, you then use the merge collection action to merge them into an object.
My Object is called MyTableData

In the Document Generation Action, add Repeating data. Use the “result” collection from the Merge collection action output and repeat by Table.
 

Selecting Table in your tagger will give you your tags.
 

Tag your template like this:
 

And that’s it really.
My test resulted in the following:
(I may not have things in the correct rows but you get the idea).

I hope this helps.

@SimonMuntz Thank you so much! This is exactly what I need. 

 

You’re a legend!

 

All the best!

ConradWilkie20

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings