cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

I am currently working on a workflow where sellers from my company can request to loan out items to other companies.

I've created a nintex form and placed some fields inside the repeating section box, the data from the fields inside the repeating section are displayed as xml format in the column connected to the repeating section in the list, is there any way I can display the data as a html table?

The next step is create a workflow for the loan request to be reviewed and approved. I am trying  to design the initial email sent out for approval so that the approver will be able to see what and when will be loaned out and the approver will be able to use lazy approval to approve or reject the request. The challenge I am facing right now is that the fields in the repeating section cannot be connected to any columns in the list and when I choose the "Item Properties" to show in the initial email it can't display the data inside the repeating section.

I was thinking If I can display the xml data as a html table I can select the Item properties of the column connected to the repeating section to be displayed in the initial email sent out for approval.

Really appreciate if anyone can help me with this!

Thank you in advance for any help provided!!!

Chen Zhen

Reply
11 Replies
mapeacock
Nintex Newbie

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Hi,

You should be able to use the Query XML action to massage the data from XML to HTML. Have you repeating section detail as your input (in my case I was populating into a column) and create some xslt code to do the conversion, storing the result in a multiline text variable.

To give you an idea, here is the setup on my Query XML action:

The associated xslt is attached. I am not a code guru, so I apologise if any aficionados of code take offence at my attempts! It does the job!

It should be a matter of changing all the references from my field names to your own.

Cheers,

Mark

Reply
Not applicable

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Hi Mark,

I appreciate the effort you've put in to reply this question.

Sorry if I didn't make it clear the last time but I am using Nintex for O365. Is the solution above only for Nintex on Premise? From what I am seeing it looks like Nintex for O365 does not have some of the features like the output 1 & 2 and the process using XSLT feature.

Thanks in advance!

Chen Zhen

0 Kudos
Reply
mapeacock
Nintex Newbie

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Sorry Chen Zhen,

I dont have any exposure to the O365 product, so my solution is based on the on prem version. Hopefully someone else can assist you with this in the online environment.

Cheers,

Mark

0 Kudos
Reply
Not applicable

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Thanks a lot any way I appreciate your effort!

Reply
nfarrin
Nintex Newbie

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Hi Mark

I am not sure what you mean by 'Repeating Section Detail'? My repeating section has several fields within it but there is not a singular {item property} that represents the repeating section only the individual fields within it.

Thanks

Nick

0 Kudos
Reply
mapeacock
Nintex Newbie

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Hi Nick,

My repeating section has multiple fields too. When setting up the form I connect the repeating section to a multiple Line plain text column on the list. So when the form is submitted, the detail of the repeating section is populated, as xml, into the list column and is available as an Item property. From there you can use the Query above to manipulate the data for display.

Cheers,

Mark

Reply
nfarrin
Nintex Newbie

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Hi Mark

Thanks for the reply. I figured this bit out and I had a Multiple line (plain text box) with the desired XML output within. I could not get the XML query to convert it though!

Luckily I found a simpler way to satisfy our requirement's.

Good post.

Thanks

Nick

Reply
Not applicable

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Hi Chen,

I kind of got this to work for one of my workflows but didn't actually need it in the end.

I used a Query XML to query each column of the panel to a collection as this link (didn't use the RegEx part of it): Nintex Workflow - Parsing Nintex Forms Repeating Section in Office 365 - Vadim Tabakman

I then used a For Each to build the variables..(Quant is the name of my column)

Screen Shot 2016-07-07 at 2.38.02 PM.png

And then a build string to build an HTML table for that column..

Screen Shot 2016-07-07 at 2.38.55 PM.png

I didn't try to replicate the entire panel in a table, as I actually needed one specific column in an email, but I imagine you could just add the additional columns into Build String.

I also didn't worry about table headers as the data in the tables was obvious to the person looking at it.

Hope this helps you on your way.

Reply
Not applicable

Re: Hi, How can i display xml data from repeating section in nintex form as a html table in the list?

Hi Aaron!

Thank you so much for the information! I am going to try it tomorrow.

Reply