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
Advertisements

About Joseph Velliah
As a SharePoint Developer my professional interests tend to be technical and SharePoint focused. I run a blog at "SP RIDER" where you can expect to read HOW TOs and scenarios that I run into during my day to day job. I hope my posts will give back a little to the community that is helped me.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: