achilles.aditya

Creating and Updating repeating control columns in another list

Blog Post created by achilles.aditya on Aug 1, 2016

Hi All,

This is my first blog and I hope it will help the beginners who are working on repeating control

 

Scenario:

List A and List B are two Lists with columns ColumnA,ColumnB in repeating control and depending upon some condition you want to create/modify the item in ListB

Example:

  • List Asia has  columns  "Country" and "City" in the repeating section hence we can add multiple rows for the values "Country" and "City" .List "Asia" also has "Count" column which is not present in the repeating section
  • Suppose we want to update the  item of list named "Events" which will also have "Country" and "City"  in the repeating section with the values of "Country" and "City" in the repeating section of list Asia.
  • List "Events" will also have "Count" column which will be updated with the value of "Count" of the item in List "Asia"

Issue:

Repeating control columns appear blank in the list view by default and if we write a simple workflow to create item in ListB by specifying ColumnA and ColumnB it wont work

Example:

We write a simple workflow to update the item in List "Events" with the values "Country","City" and"Count"  of the item in List Asia then only the value "Count" will appear in List "Events"  values for "Country" and "City" will appear blank when we open the Nintex form in Edit/View mode

 

Solution:

 

    • Create a MultiLine text column of plain type example a column named  "ReadXml" in both lists
    • Open the Nintex form of the boths the lists to edit and Connect "ReadXml" column  to the repeating controls  of both the Lists
    • Now in the workflow to  create/update item in List "Events" specify the value of "ReadXml"of List "Events" equals to "ReadXml"of List "Asia"
    • Data will be updated on modify and create condition and values for "Country" and "City" will appear in the Nintex form in Edit/View mode

Outcomes