Translate

Thursday, July 16, 2015

Read InfoPath Repeating Section Details using Nintex Workflow

Read InfoPath Repeating Section Details using Nintex Workflow

My InfoPath Form looks like below, where I have a repeating section which contains Project Name and Charge Code (Auto populated based on Project selection). The form is used by the PMs to request charge code for employees. After the form is submitted, Nintex Workflow has to execute and extract the values from the repeating section and send an email to coordinators. 

1. Add a Query XML activity and configure like below.
2. Create Two collection variables, one for Project and one for Charge Codes.
3. You can use XPath Builder to provide the field XPath or can copy it from the InfoPath field as well.
4. Add a ForEach activity and configure it like below.
5. Your target collection would be PrjNames and store the result in PrjName (a single line of text variable). PrjIndex is another number variable.
6. Add a Collection Action to extract the Project Names. Notice the target collection is PrjNames, GET, Index is PrjIndex and Storing the result in Single Line of text PrjName.
7. Similarly add another collection operation to get the Charge Codes
8. Add a Log to History activity to read the PrjName and ChargeCodeM field. 

That's it ! Your repeating section data is extracted.

I will talk about how to use these details, form a table and send an email on my next post.

Thanks !






No comments:

Post a Comment