Update InfoPath field in a Repeating Table using Nintex

Requirement

A request from a customer: how to update a column/s in a InfoPath repeating table when a master list gets an update.

Solution:

They wanted to add several rows to a repeating table with three columns and after submitting the form the OPPNumber, Amount, Status etc. to be added to the info-path form.

The structure of the form is as follows:

The workflow has the following actions:

Add a Query XML and add the XPath path, store the results in a collection variable

Add an for each action that process the collection and a text variable.

An Update XML

XML source is current item

Create the following Xpath query

Select Update node value

Add the variable you want to set

Just a last few point:

  • This workflow doens’t do anything more than retrieving and updating, other options you have to add yourself
  • For more XPath see http://www.w3schools.com/xpath/default.asp
  • To get the Query I used Altova XMLSpy

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.