Hi –
I am using Nintex with SharePoint 2019.
I created a repeating section in a list “Weekly Status Update” and placed five controls in it:
Major Accomplishments – MLT
Week Ending – Date
Team – Choice
Category – Choice
Priority – Choice
I have been able to use Query XML to parse the data and add each control to individual Collections.
For instance, I have: colMajorAccomplish, colWeekEnding, colTeam, colCategory, colPriority.
I created a For each loop and stored the Collections into variables. I have: varMajorAccomplish, varWeekEnding, varTeam, varCategory, varPriority. I also have an index configured for each collection.
I have a Math operation that loops through the variables.
I have created a separate list called “Weekly Report.”
Each of the collections has a “Create item” to add variable content to the “Report” list.
Where I’m stuck: The workflow runs, but it does not add all of the collection items to a single list item. If I do a save in my form, it will add a separate row/index for every collection. So, if I save one repeating section with the 5 controls, my list looks like:
Major Accomplishment |
|
|
|
|
| Team |
|
|
|
|
|
| Priority |
|
|
| Category |
|
|
|
|
|
| WeekEnding |
I’ve seen a number of solutions for getting things out of repeating sections and some on how to add to a list, but nothing for SharePoint or that explains how to add variables to one item / row.
Unfortunately, I have no good way to share my screen shots. Working in two separate environments.
Thanks,
Chris