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:

"nsr1"

The workflow has the following actions:

"nsr2"

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

"nsr3"

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

"nsr4"

Notes:

  • 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