Protiviti / SharePoint Blog

SharePoint Blog

May 16
Nintex 365: How to Display a Repeating Section as a Table in a View

​Problem:

Nintex Forms has a functionality called "repeating sections" which allows users to dynamically add repeating data that is grouped to a form.


The issue is that when displaying this data in a view it looks like the following:



Not very user friendly.  Our goal is to get the view to look like the following:


The solution to this has been addressed for on-premise (see the links below), but not for Office 365. In this post, I have utilized the solutions below and resolved the problem for Office 365.

http://www.vadimtabakman.com/nintex-formsworkflow-parsing-repeating-section-data.aspx

https://community.nintex.com/community/tech-blog/blog/2015/08/04/displaying-repeating-section-data-in-list-views-the-easy-way

 

Resolution:


1.  Ensure you have a Multiple Lines of Text field and it using the Enhanced rich text parameter.



This way you can build a string in the workflow that contains a HTML Table.

2.  Utilize the Query XML action.  The key to this working is gathering information and putting it into a collection variable.   Configure it as follows:



XML Source – this is the Repeating Section output

XPath query – This is the key to this working.  In this case I wish to collect all the Names and put them into a collection.  I like collections because they are simple 0 based arrays.  The query collects all the names in the repeating section.

Query result in – this is the collection variable which will store all the names.

3.  Use the Count items in Collection.  This will give us a number with which we will use in a loop.


4. Use the Build String action to put the first part of the HTML table into the string variable with which you are using.

5. Set the Loop variable to 0.   In this case we are using the Loop action to parse through the collection.

6. Use the Loop N times actions and configure it.  We will loop using the variable from step 2.

7. Use the Get item from collection and configure it.




8. Build the name string with the Build String action.


9. Use the Do Calculation action to increment the variable for looping.

10. Use the Build String and append the end of the HTML table.

11. Use the Update List Item and update the multi-line field with the HTML variable that you just built.

Run the workflow and it will build a table as you saw in the beginning of the blog.

Quick Launch


© Protiviti 2019. All rights reserved.   |   Privacy Policy