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