Repeating Section and Display Data in List View

Here is another post you may want to look at:
https://community.nintex.com/t5/Template-Gallery/Show-Repeating-Section-as-table-in-List-View/ta-p/85775

Hi Simon,

Thank you very much for your reply. I have reviewed this but I am not sure as to what I am suppose to do with the script as it doesn't include much detail on how to make this work. I created a page and added the list view and the script to the script editor. I replaced "inventory" with the name of my repeating section, but I am not seeing any changes.

Sorry I am very new to SharePoint development and Nintex. Any guidance you can provide would be much appreciated.

Thanks.

Devon

No problem. First off we need to install the UDA. Download it form the link above. This is basically a core workflow with paramaters that once uploaded, becomes available as an 'action' within another workflow. It saves you redoing a complicated section. Install it using the admin section of nintex on your central admin site. Ideally at collection level.

 

I've attached my workflow that uses the UDA. It simply takes fields from my repeating section, loops through each row in the repeating section, adds them to a collection and then updates another field with the summarized rows.

 

Actions to configure in the workflow...

 

UDA...

Make sure your repeating section has a name in the form and it matches the textrepeatingsectionname as shown below.

 

 

 

 

 

 

Query XML...

 

Depending on the number of fields in your repeating section, you will need to add an output for each as shown below. Simply replace the highlighted bits below with your field names. Each needs it's own variable.

 

 

 

 

 

 

 

 

 

 

 

Build String...

 

Here we are putting the fields together for each row. In my example I'm creating a url that you can click on but you could simply have a string of fields. Ie. OutPutVariable1 : OutPutVariable2 : OutPutVariable3.

 

 

 

 

 

 

 

Update Item

Now we update a summary field in your list. Simply replace the Linksummary field in my example with your multiple line field on your list. HTML enabled. There is also an email action that also pops out the summarized rows as well.

 

 

 

This is how it looks from the form view....

 

Repeating Section..

 

 

 

 

 

 

 

 

 

 

 

Into a summarized field for that item...

 

 

 

 

 

I hope that gets you close to what you're after.

 

Also here is a solution for extracting data from a repeating section into excel.

 

https://community.nintex.com/t5/Community-Blogs/Repeating-Section-How-to-Extract-and-Split-to-Excel/ba-p/77915

 

T.

Those variables come from the main workflow. If you install my example you should see them.

Instead of using UDA:

 

1. Simply create a MLT (with plain text) column in a list. Plain text type is very important since it's going to store XML code of your repeating section
2. On the form, connect your repeating section to MLT column you've created in step # 1. You can remove this MLT column from your views in the list.
3. Now, create a workflow and:
   1. Use Query XML and use the MLT column from step # 1 as a XML source
   2. Use collection variable to store all the different values of your controls you've put in repeating section
   3. Use one of the collection for "For Loop" and get the index also
   4. Use collection operation for other collections using index
   5. Then using build string you can create the HTML code as per your requirement
   6. Create another MLT column for showing this HTML code, make sure it allows Rich text for this

Let me know if this works for you.

 

- K

When I try to import your example it imports blank. I am using 2016 version. Not sure if that matters. But I very much am looking for whole workflow examples to use.