I need some help figuring out how to populate a blank repeating section on a form with rows of data I have pulled form SQL via a workflow.
Two columns of the repeating section will be from the SQL data and another 2 will just be tick boxes.
In the workflow I have used 2 'execute SQL' actions to pull through 'client name' and 'client ref'.
For each 'client name' and 'client ref' collection variable I pull a record out and put into a single line text variable ready to put into the repeating table. What are the next steps within the 'for each' loop? How do I go about populating the variables into the repeating table?
I have pulled rows from repeating section before and put each row into a secondary list, I just can't seem to get my head round the other way.
I managed to follow this Nintex post - https://community.nintex.com/community/tech-blog/blog/2015/08/17/populating-repeating-section-controls-with-list-data
I have created the XML and set the repeating section value.
However when I open an existing form I cannot see the data in the repeating section.
Why might this be?
I also notice using a collection variable to push data into a column adds a semi column between items. Would this effect it?