Vadim Tabakman

Nintex Forms/Workflow - Parsing Repeating Section Data

There is an interesting control that you can use in Nintex Forms called the Repeating Section. It gives users who are filling in the form, the ability to dynamically add extra entries.

One example of this, would be a dynamic Annual Leave request form.  Each entry in the Repeating Section would contain a Start Date, End Date and Description. This would save an employee from having to fill in the same form several times, and instead they just fill in the one form.

Although this is a great addition to Nintex Forms, there's no control in SharePoint that can really handle this data nicely.  You need to be able to parse the data that is filled in and do something with it.  In comes Nintex Workflow to the rescue.

Problem

A simple Nintex Form with a Repeating Section that is published to a List.

When a user fills in the form to create an item, they can fill in a number of records in the repeating section.  But once the form is submitting, we need to get the records and do something with them.

This is what the form looks like:

Solution

When a Nintex Form is submitted to a list, the item has a property called "Form Data". This is the XML representation of the entire form.  If we have a repeating section in the form, the form has a hidden ID and the Form Data will have a node with that ID.  So to make it easier for us, we will give our Repeating Section a name like (MyRepeatingSection).

The repeating section will have two Single Line of Text controls.  To make life easier, we will also give them names:

 

To get the value of the repeating section from the XML, we can now use the following XPath expression:

//MyRepeatingSection

The value of this XML node is an encoded XML document.  So we need to decode it using a Build String action and an fn-XmlDecode inline function call.  We now have an XML document that we can query using a Query XML action.

I won't go through example of the Query XML action or the Xml Decoding.  I'll leave this as an exercise for the reader. Instead, I thought that since this part is reusable, I'll create a User Defined Action that will do it for me.  There could be multiple records in my repeating section, so I will get the UDA to return the internal XML document and also the number of internal Items. then

So now that we have the XML and the number of items, we can then use a Loop action to iterate through each item and retrieve the item control values.

I'll leave it up to you to take a look at the UDA and the Workflow, since going through it here is probably super boring.

But what I will provide is a screenshot of calling the User Defined Action.

Office 365 version of this post.

Posted by Vadim Tabakman Sunday, July 22, 2012 9:26:00 AM Categories: Iterate Math Calculations Nintex Nintex Forms Nintex Workflow Query XML Repeating Section User Defined Actions
Copyright Vadim Tabakman
Rate this Content 8 Votes

Comments

Friday, August 31, 2012 3:01:06 AM
Brijesh

Nintex Forms - Publish using Code

Hi,

Do you have any idea about how to import/publish a Nintex Forms 2010 using a code ?

~Brijesh

Sunday, September 30, 2012 10:34:23 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Brijesh,

I'm afraid I don't know how to do that yet.

cheers,

Vadim

Wednesday, January 30, 2013 7:15:13 AM
Simon

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi

Hope you don't mind helping me with an issue I have regarding the above.

I have implemented your method above, more or less as is, on our test server.  It works fine, does what it is meant to but it takes ages to do it ... see below

I have 3 repeating sections, with two textboxes like yours.

can you think of any reason why it would run so slowly?  It appears to be taking ages to do the maths of adding 1 but perhaps that is misleading!

Action Start

Math operation 30/01/2013 12:05

Log in history list 30/01/2013 12:05

Query XML 30/01/2013 12:05

Math operation 30/01/2013 12:00

Log in history list 30/01/2013 12:00

Query XML 30/01/2013 12:00

Math operation 30/01/2013 11:57

Log in history list 30/01/2013 11:57

Query XML 30/01/2013 11:57

Loop 30/01/2013 11:57

Update item 30/01/2013 11:57

Log in history list 30/01/2013 11:57

Set variable 30/01/2013 11:57

Get Forms Repeating Section UDA 30/01/2013 11:57

-------------------------------------------------------------

30/01/2013 11:57 Workflow Comment 3  
30/01/2013 11:57 Workflow Comment frrrrr  
30/01/2013 12:00 Workflow Comment fjffjfjfjfj  
30/01/2013 12:05 Workflow Comment sgsgdsgsgs great

Thanks

Simon

 

 

Wednesday, January 30, 2013 7:32:19 AM
Simon

re: Nintex Forms/Workflow - Parsing Repeating Section Data

 

Not to worry, I found some info on Safe Looping which I'm sure is this problem.  about to switch it off

 

Simon

Wednesday, January 30, 2013 10:10:58 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Simon,

if you're using a Loop action, you hit the nail on the head - Safe Looping. :)

cheers,

Vadim

Monday, March 4, 2013 4:43:08 AM
unknown

re: Nintex Forms/Workflow - Parsing Repeating Section Data

thank you Vadim. nice article

Thursday, April 11, 2013 12:15:33 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim:

I got this working quite nicely, thank you much!  That being said, I have a situation where I need to do this for a hundred or more items.  Because of Safe Looping (a good thing) this takes forever to run.  So I want to combine this solution with this one:  http://connect.nintex.com/forums/thread/18429.aspx

The problem is, I'm not sure how to grab the XML from the Nintex Form to put it into a string in the first place.  I tried selecting "Form Data" from the "Item Properties"...no go.

Is it even possible to do what I'm trying to do?  Thanks!!

adam

Thursday, April 11, 2013 12:18:35 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

I should mention, when I choose "Form Data", it converts it to "{ItemProperty:_x0024_Resources_x003a_core_x002}" in the XML filed.

Thursday, April 11, 2013 12:53:48 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Adam,

use a Build String action and then click the Insert Reference.  Choose the Form Data property under Item Properties and store the result in a Text variable.

I think that should do it for you.  I'm not sure why the internal name looks like :_x0024_Resources_x003a_core_x002, but it should still work :).

cheers,

Vadim

Thursday, April 11, 2013 5:20:14 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Thanks Vadim:

I'll try that tomorrow morning.  I did manage to get it working by using the "connected to" field in the Repeater, and outputting that to a plain text field in my list.  This exposed the encoded XML, which I then decoded as per your instructions in the other post.  It works great, but I still would rather do it the way that you suggest, so I'll let you know how that goes.  Thanks again!

adam

Thursday, April 11, 2013 5:20:15 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Thanks Vadim:

I'll try that tomorrow morning.  I did manage to get it working by using the "connected to" field in the Repeater, and outputting that to a plain text field in my list.  This exposed the encoded XML, which I then decoded as per your instructions in the other post.  It works great, but I still would rather do it the way that you suggest, so I'll let you know how that goes.  Thanks again!

adam

Thursday, April 11, 2013 5:30:46 PM
Adam Pucek

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hello:

I just tried your way...didn't work.  Now that I recall, I actually did try that way, before.  It's OK, pulling it from the field is working fine, so I'll just stick with that for now.  Thanks!

adam

Thursday, April 11, 2013 9:56:16 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Adam,

I'm gld your have some solution to work with :)

chers,

Vadim

Wednesday, May 1, 2013 7:24:27 PM
Jarrad

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hey Vadim, (And those that are trying this but have issues with safe looping taking to long)

I just used this recently to develop a solution but I added in an extra step after the UDA (Query XML) to add the first column of data to a Collection then I used the "For Each" action instead of the "Loop" which is not bound by safe looping and then iterates through the collection for each item with no pause. So basically combined this solution with this one - http://connect.nintex.com/forums/thread/18429.aspx.

Thanks Again.

Wednesday, May 8, 2013 2:59:57 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

I've waited forever to have a requirement where I need to actually do something in the workflow related to the repeating section. Oddly enough this has never came up (until now!), even though I use repeating sections regularly. I can't wait to try this out, thanks for the tutorial Vadim! You rock!

Friday, May 10, 2013 7:49:25 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

This works wonderfully Vadim! Thanks so much for this solution. I used the UDA you provided combined with the proposed solution to the safe looping caveat, and was able to get this running in a For Each in no time.

It's working much better than I could have imagined, and was really easy to setup. We're creating line items, validating, and writing calculations back to the parent item from this. We're also able to run approvals on each individual line item and we're even storing everything in the same list (multiple CT's). I see so many potential uses for this.. I'm really happy to have added this to my arsenal!

Friday, May 10, 2013 8:25:32 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

That's awesome Josh.  I'm so glad it worked you and you got the solution done so quickly!!

Wednesday, May 29, 2013 3:16:33 AM
Anvar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim:

I just tried to download the user defined action from the above link(Download the Parse Repeating Section Use Defined Action) and import as user defined action, but I see its extension is nwf not uda.

Any help will be appreciated.

Thanks,

Anvar

Tuesday, July 9, 2013 2:33:02 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

If anyone is having difficulty with free-form text fields, I have a solution.

In my situation it is required that each section in the repeating section contains a text box (single or multi does not matter). Whenever a user enters a comma, the provided UDA will fail and will not create the child item. Commas are the only character I have tested that has caused the UDA to fail.

To be clear, it is not the UDA that is failing here, it is the fn-XmlDecode inline function that is failing.

As a work-around, open the UDA to modify it. Find the 3rd action titled "Decode XML". Replace the input text with fn-XmlDecode({TextStart}{WorkflowVariable:textRepeatingSectionEncodedXML}{TextEnd})

This will patch the UDA so it will run without error.

 

@Vadim - Are you aware of any repercussions of what I just recommended? May I ask why you did not include this? My guess is there's either a drawback I'm not seeing or this situation didn't pop up in your testing :)

As always, many thanks for your hard work and wonderful solutions Vadim!

Tuesday, July 9, 2013 2:52:29 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hey Josh,

Thanks for pointing that out.  I've updated the UDA on this post to include your fix.  It completely slipped my mind.  I don't see any ill effects in what you put in. In fact, I think it should have been there in the first place.

cheers,

Vadim

Wednesday, July 10, 2013 9:29:04 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Thanks Vadim.

Saturday, August 10, 2013 11:20:54 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim

I just tried with this example for one repeating section and it works great !.

But I have sub repeating section as a control inside main repeating section on Nintex Form. and When I tried to parse child repeating section using nintex workflow,Its unble to find child repeating section using UDA function.

Can you please provide any suggestion here.

Any help will be appreciated.

Thanks,

Monika

Wednesday, August 14, 2013 9:03:59 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi monika,

you need to give your child repeating section a name, so that in the XML the node will be that name.

Then when you get the parent repeating section XML, you'll need to get the inner repeating section, decode it using a Build String action, calling the fn-XmlDecode function.  That should give you back the inner repeating section XML and you should be able to parse that.

cheers,

Vadim

Monday, September 9, 2013 3:13:39 PM
June

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Thanks for another great tutorial! I followed it and it worked fine.

Do you know how can I display repeating section's data in a Edit form? When user saves data to the repeating section in a New form, the data gets saved to the list OK. When the person edit that list item, there is no data showing in the repeating section and once the edit form is saved. The previous repeating section's data are lost. Have you seen the same problem before? Help please

Many thanks

June 

Monday, September 9, 2013 3:29:44 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi June,

I haven't encountered this issue.  Repeating section data should appear in an edit form.  I'd recommend you shoot and email to support@nintex.com and they should be able to assist you with that.

cheers,

Vadim

Monday, September 9, 2013 5:35:31 PM
June

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Thanks for your quick reply. It was my fault. I tried again following Nintex's tutorial and it worked. The reason it didn't was because I created a multi-line text column and connected the repeating section.

Thanks Laughing

June

Tuesday, September 10, 2013 3:07:58 AM
Christian

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Thanks for the UDA. It is working perfectly. However, instead of using Text fields, I am using a Lookup in my repeating section. As a result, I only get the IDs of the lookuped items and not the texts. Any idea about?

Cheers,

Christian.

Wednesday, September 11, 2013 3:18:11 AM
Trish

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Great UDA, it works fine. How would you use it when you have more than one repeating section in a form?

Thanks in advance.

Trish

Wednesday, September 11, 2013 7:17:08 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Christian,

I think you'll need to find a way to pull the data out of SP based on those ID's.  I'd recommend using a Query List action to get the real data you need based on those ID's from the appropriate list.

Hi Trish,

Make sure you give your repeating section unique names, then adjust the XPath query in the Query XML action accordingly.

cheers,

Vadim

Thursday, September 12, 2013 2:01:34 AM
Christian

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Thanls for the advise. Working properly by using the Query List feature.

Regards,

Christian.

Thursday, September 12, 2013 3:23:03 AM
Trish

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Thank you for your answer. You mean set as many inputs and outputs in the UDA as I have repeating sections in my form?

Regards,

Trish

Monday, October 7, 2013 2:25:10 PM
Megan

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Thanks for this blog post - works great.

I have a followup question for you that I'm hoping you can answer or provide some guidance :)

I have 3 repeating sections with multiple drop downs and date selections for my Nintex Form (its a travel request) so that the user can book multiple flights, accommodation, rental cars per request.

Repeating Section 1 - Flights

Repeating Section 2 - Accommodation

Repeating Section 3 - Rental Car

Once the request has been approved by the Manager, I have added a Send Notification section to my workflow and want to construct an email with each of the repeating section details listed on separate rows of the email. At the moment, I can only get the last entry of the form to appear in the email, although I can see the correct "number of items" that the user has submitted per section and also the submitted data in the "repeating data" section.

 

Any ideas?

Thanks in advance.

Friday, November 1, 2013 9:01:23 AM
Greg Robinson

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Great post, thanks for publishing.  Your example includes a repeating section on the main list form to create an item.  However, I am using this on a data collection task.  So using your UDA I cannot point to the current item form data.  How would I get the form data for the associated workflow task?  So close yet so far...

Friday, November 1, 2013 9:08:49 AM
Greg Robinson

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Well go figure.. I googled and found your other post that addresses this:  http://www.vadimtabakman.com/nintex-formsworkflow-flexi-task-with-a-data-entry-nintex-form.aspx

 

Friday, March 21, 2014 3:04:09 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

I've tried parsing repeating section data in new form. It worked.

but, when i try it on approval form, appear error on your UDA like:

Error parsing value. Value '' is not compatible with the selected output variable type Number (double). Error
3/21/2014 12:41 AM Comment Failed to run User Defined Action. Value '' is not compatible with the selected output variable type Number (double). Error

 

I'm affraid the error is your UDA cannot read form data in approval form.

can you help me?

Friday, March 21, 2014 7:52:50 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Gilang,

I'm afraid I don't know what that could be.  I haven't had any issues with the UDA. 

Would you be able to add some Log actions into the UDA and help narrow down where this is happening in the UDA?

cheers,

Vadim

Thursday, April 3, 2014 8:56:31 AM
Avinassh Reddy
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

 

 Its is giving me exact  number of repeating sections. But, I have a control called quantity iniside repeating section, workflow gives me only the first value of it but doesn't give the values of quantity control in other repeating sections. Can you tell me where am I making a mistake ?

Thursday, April 3, 2014 9:23:25 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Avinassh,

it sounds like you have a bit of a logic error in the workflow.  You'll need to get the XML, take a look at it, and see how you need to modify the XPath to extract the Quantity field.

cheers,

Vadim

Thursday, May 8, 2014 8:57:46 AM
Jeff Patterson
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hello Vadim,

 

I'm getting the exact same error that Gilang is getting above.  Have you tested this with SP 2013?  Can I send you my workflow code to help me find the problem?

 

Thanks,

Jeff

Friday, May 9, 2014 9:34:57 AM
Jackey Stanely
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

I downloaded your workflow and UDA file but when i try to import the UDA it gives me the "access denied" error message.  What do I need to do to be able to import your UDA file?

Thanks for the help,

Jackey

Thursday, July 24, 2014 1:29:30 PM
Luiz Henrique
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hello Vadim,

I am supporting a customer that having 'Failed to Run' error in some workflows what use the same steps presented in this article to parsing repeating section data. I observed that when was inputed more than one row in repeating section the error occurs. 

Do you know whether there are a relation between this kind of error and using loop with repeating section? And do you know another way to extract data rows of a repeating section without loop? 

Thanks in advance.

Luiz Henrique

Friday, August 29, 2014 2:23:20 PM
May
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim!

I have a repeating section in a panel. I notice there is a huge white space right above the text for the repeating section, before the save buttons. How do I get rid of this white space?

Friday, August 29, 2014 8:29:15 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi May,

without seeing the form, I don't know what could cause that sorry.

Make sure you're on the latest build of Nintex Forms.

cheers,

Vadim

Tuesday, September 2, 2014 5:54:59 PM
anthony
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim - I am a nintex noob working my through an evaluation. We have a scenario where a user completes a request form with repeating section data. The request then gets routed to the manager for approval. I need to be able to display the repeating section data in the approval form so the manager can review request details.  

I have been able to parse the repeating section details into an email but can't work out how to do it in a form. Can you point me in the right direction?

 

Cheers

Friday, September 5, 2014 11:33:36 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Anthony,

I'm afraid I don't have any examples of doing this, since I've never tried it.  Are you using Nintex Forms to customize the task form?

Potentially, you could build up some HTML into a Nintex Workflow variable, then in your custom form, add a Rich Text control and into the Source, insert your Workflow variable.

Hope this helps.

cheers,

Vadim

Tuesday, September 9, 2014 4:15:43 PM
Anoopa
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

I'm new to Nintex workflow Office 365. How can I parse Repeating Section Data from Nintex form Office 365? How to get the count of items in a repeating section?

 

Cheers

Anoopa

Monday, September 15, 2014 3:26:28 AM
Artur
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hello Vadim,

I'm using your solution which is absolutely great. Today I wanted to change Data Type on my Single Line Textbox from "String"  to "Currency" or "Decimal". In both cases I have error in workflow when parsing XML:

Error saving the value in a variable. The resulting data type 'ArrayList' did not agree with a specific data type of the variable 'Double'.

Reason why I want to change this field type is that I want to place there an ammounts like: 123 000 (with thousand separator) or 234,90.

Thanks in advance

Artur

Monday, September 15, 2014 7:50:58 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Artur,

I'm not why or where this error is coming from.  You'd need to trace this to a specific action so that you can get to the bottom of this issue.

cheers,

Vadim

Monday, September 15, 2014 8:52:43 AM
Artur
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Workflow breaks at "Query XML (Get Item Values)" action from your example;) Process using: XPath
//Items/Item[{WorkflowVariable:numIndex}]/Value
Return results as: Text
Store result in: iValue (which is Number type)

Even if I'm trying to store error text in variable, I can't see any value there. Workflow ends with notification which I wrote above.

 

Monday, September 15, 2014 8:56:52 AM
Artur
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

One more word of explanation.

Today I wanted to change Data Type on my Single Line Textbox from "String" to "Currency" or "Decimal".

Above sentence concern Nintex Forms form, field which is part of Repeating Section.

Regards
Artur

Thursday, September 25, 2014 8:51:49 AM
Lou
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

The UDA has a build string step that decodes the form data in the repeating section and for some reason it needs to be decoded twice in order to result in the desired xml.  I am not sure why this is the case, but that should fix it.

Thursday, September 25, 2014 10:17:44 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

HI Lou,

thanks for sharing that.  I don't know what that is required.  IT wasn't before... but maybe something has changed.

cheers,

Vadim

Wednesday, October 15, 2014 2:46:25 AM
Ng
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Did you try on validate the duplication of the repeater section item? I have a case is to add multiple product using the repeater section but need to make sure there is no duplicate product selected by the user. The product field is a lookup list.

Thank you

Ng

Wednesday, October 15, 2014 2:53:26 AM
Ng
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

I have case to add multiple product using the repeater section. But the problem is i don't want to have duplicate product in the repeater section. The product field is a lookup list. Any idea to prompt user if the same product being selected?

Thank you

Ng

Wednesday, October 15, 2014 7:32:38 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Ng,

I'm afraid I haven't tried that. Right now, I'm travelling so probably won't have time to mess around with this for a couple of weeks.  I'll try to take a look then.

If in the meantime, you figure out a way, please share it as I'm sure others would find this interesting.

cheers,

Vadim

Monday, November 3, 2014 8:03:02 PM
Ng
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Have checked with Nintex Support and they provided me a custom javascript as below:

----------Copy at Form Setting Custom JavaScript section-----------
function allValuesUnique(Item)
{
var allValuesUnique = true;
debugger;
NWF$.each(Item, function (key1, value1) {
NWF$.each(Item, function (key2, value2) {
if (key2 != key1 && value2 == value1)
{
allValuesUnique = false;
}
});
});
return allValuesUnique;
}

-------------------------------------------------------------------

Select the Repeater Section control to create a new Rule.
Rule Type: Validation
Condition: !allValuesUnique(<Control Name>)

 

Thank You, Ng

Thursday, November 6, 2014 7:51:46 AM
Mark
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Guys,

How to manage problem with special characters. Let say "&" is being decode and displayed as "&amp;". I tried to replace it in workflow after XML is decoded but it isn't best solution....

 

Thursday, November 6, 2014 8:28:00 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Mark,

A build String with a fn-Replace inline function, or a Regular Expressions configured to do a Replace should replace the pieces of text with a regular ampersand.

Cheers,

VAdim

Wednesday, May 27, 2015 4:04:25 AM
christophe
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

 

thanks a lot for this tutorial,

I succeed to create item with the information of the repeating section, but i need to be able to synchronise modification from repeating section to item.

Is it possible ?

if not, is it possible to delete all row of repeating section in the form ?

 

Thanks a lot

Christophe

Wednesday, May 27, 2015 8:23:36 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Christophe,

There's no easy way of syncing repeating section data with data in another list.  You'd have to build that workflow logic out yourself.

As to deleting the repeating section data, it's possible, since the repeating section is XML and you should be able to modify that using the Update XML action.  But again, it's not out of the box, so the logic to that in a workflow, you'd need to build that out.

cheers,

Vadim

Thursday, May 28, 2015 7:08:43 AM
christophe
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

ok thanks,

I tried to replace the loop by "for each" but it asking for a site collection variable, i have create this one but how to set it whith the appropriate value is it in the UDA ?

thanks,

Christophe

Thursday, May 28, 2015 9:04:32 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Christophe,

the uda doesn't return a collection of data.  It returns XML. You will need to use the Query XML action to pull data out of the XML and store that in a Collection variable, before you can go through it with a For Each action.

cheers,

Vadim

Thursday, May 28, 2015 10:09:04 AM
christophe
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

thanks, Vadim

Where i need to place this Query xml to store that in a Collection variable.

I mean is it in workflow before the for each to have value int it ?

thanks,

Christophe

Thursday, May 28, 2015 12:25:49 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

You need the Query XML after the UDA call and before the For Each.

The Query XML fills the collection variable.

The For Each goes through the collection variable.

cheers,

Vadim

Friday, May 29, 2015 8:16:33 AM
christophe
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

thanks, Vadim

I try to build the collection varaible using Regex or Query xml, but i didn't find.

If i understand it could be ok if i succeed to build a collection like:

1;2;3;4;... numItems or

1;1;1;1;1... but numitems times

after i can do a for each and use the query xml of the loop.

but i didn't succeed to find a regex expression to do the collection, and i don't know about xml

 

I Appreciate your help

thanks a lot

Christophe

Monday, June 1, 2015 6:17:37 AM
christophe
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vaadim,

I didn't find the syntax for queryxml or  regular expression to populate value for collection variable, but i didn't succeed,

I will be very grateful  if you can help me

Christophe

Monday, June 1, 2015 8:05:03 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Christophe,

you could do somethinglike 1;1;1;1;1 etc and then put that into a Regular Expression action, configure it to do a Split and the expression pattern would be a single semi-colon  ;.

This would then split that text by the semi-colon and store the results into a collection variable.

cheers,

Vadim

Wednesday, June 3, 2015 7:29:22 AM
christophe
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

 

I finaly succeed to populate the collection variable.

I add a regular expression :

In pattern : /Item

Operation : extract

input text : {WorkflowVariable:textRepeatingSection}

Store result in : the site collection variable to populate

 

thanks

Christophe

Wednesday, June 3, 2015 7:47:47 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Great job mate.  Glad you got it working.

cheers,

Vadim

Tuesday, June 16, 2015 2:03:05 PM
Basanta
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hello Vladim,

 

How to use the url to xml file  instead of xml source to be current item. I tried everything , using relative url, full url nothing seems to happen. It does not throw error, but it does not get updated either.

Tuesday, June 16, 2015 10:02:50 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Basanta,

This should work.  I've done this before and it was never an issue.

If you put an XML file in a Document Library and put in the url to that XML, does it work?

If not, I don't know why this isn't working.

Maybe reach out to Nintex Support.

cheers,

Vadim

Friday, August 14, 2015 9:16:37 AM
Nicole
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

 Hi Vadim,

Thanks for your solution. My Question : Is there a possibility that the decoded XML values can be seen on the related SharePoint list?

My users would like to create views on the list and filter this information.

Let me know if you have touched on this yet.

Thanks

Nicole

Friday, August 14, 2015 9:32:41 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Nicole,

are you talking about having the repeating section data visible on the current list, or if you take that data and put it into another list, then have it visible in the parent list?

Unfortunately, if you connect the repeating section to a field, you just see XML.

You could look at this - https://community.nintex.com/community/tech-blog/blog/2015/08/04/displaying-repeating-section-data-in-list-views-the-easy-way

cheers,

Vadim

Wednesday, August 26, 2015 5:07:18 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

 

I'm trying to display the extracted values from the Repeating Section in an email,,

I'm using the Repeating Section to add Approved Orders with 2 fields Approved Order Number and Approved Order Value (both single line of text fields) instead of Firstname/Lastname.

In addition I've added a second repeating section with the same details for new orders requiring Approval - these again will have the same 2 fields Order Number and Order Value and I wanted these to be added to the Approved Orders Repeating Section once authorisation has been granted via a workfow already running.

 

Thanks

Chet

 

 

Thursday, October 15, 2015 5:44:56 AM
sumithra
Gravatar

Space

Hi,

 

I have a send mail action. I have inserted a variable containing html code to create a table. everything is working fine except that..

there is a big white space above my table. between the normal text and the table. How can I remove this space

Thursday, October 15, 2015 9:53:58 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Sumithra,

I don't know sorry.  I think that is a good one for Nintex Support.

vadim

Wednesday, October 28, 2015 4:10:33 PM
Terri
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

I'm not sure I was successful in downloading the "Get Forms Repeating Section UDA".  When I run my workflow using the UDA, I get the error "Failed to run User Defined Action. Expression must evaluate to a node-set."

Looking closer at the UDA, I see 2 Action Sets, but neither Action Set has any actions within them (Maximize does not expand to anything).  The 2 Action sets are "Retrieve and Decode Repeater Node" and "Count Number of Repeated Section child nodes". 

Can you provide me screenshots or detailed description of the details of these Action Sets? 

Thanks,

~ Terri

 

Wednesday, December 2, 2015 6:46:22 AM
Robert van Raamsdonk
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim, thanks for your great blog. I want to use your parse Repeating Section workflow on a repeating section that contains a people field and a lookup field. I'm having trouble mapping the 'internal lookup' format (e.g., 10;#europe\mkearn) that is returned by the XML query to a SP People/Group field. Same problem with the lookup. Can you offer any advice? Many thanks!

Wednesday, December 2, 2015 8:26:02 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Robert,

what exactly are you trying to do, once you have the people picker field value?

Emailing? Assigning a task?

That stuff should work. 

If you want other information about the user, then you may need to look at querying the User Profile or if you want to query AD (LDAP), you'll need to strip off the 10;#europe| and do a query based on the sAMAccountName.

cheers,

Vadim

Wednesday, December 9, 2015 2:06:00 AM
Robert van Raamsdonk
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim, thanks for your answer. I want to get the people picker field value(s) and then assign (a) task(s). If you say this should work, then I'm probably overlooking some workflow variable type mismatch. 

Thursday, December 10, 2015 2:39:56 AM
Robert van Raamsdonk
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

I've got your example workflow running fine, only when I start changing the field types in my repeating section do I get into trouble. 

So I think my exact question is as follows: 

  1. The repeating section in my list form contains two - unconnected - named fields, actionType (choice) and assignedTo (people picker)
  2. I want to have your workflow assign values from actionType and assignedTo to corresponding workflow variables varActionType and varAssignedTo, and then use these two workflow variables to assign (a) task(s).

How do i now configure my two workflow variables? Your XML query returns Text. So do I set both workflow variables to type Singe Line of Text? Or, do I set varActionType to Choice? Do I then leave the choices blank? Or do I replicate the exact choice configuration of the list field? 

Similar question for my workflow variable varAssignedTo. Do I make that of type People? Something else?

I have tried running your workflow with both my workflow variables both set to type Single Line of Text. The workflow completes without errors, but the entries in the history list are blank. 

Your help is much appreciated. Clearly the mapping from XML query output > variable > task field is failing somewhere.

Thursday, December 10, 2015 4:37:18 AM
Robert van Raamsdonk
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim. Probem solved. I THINK it had to do with me typing the list field name in the XML query editor instead of selecting it using Reference. Anyway, I am now able to correctly map the input in the repeating section to workflow variable fields. 

Thursday, December 10, 2015 7:27:30 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

That's great to hear.  Glad you got it working.

Vadim

Thursday, December 10, 2015 8:30:24 PM
Gus Rozycki
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi All,

It may have already been answered:

Error parsing value. Value '' is not compatible with the selected output variable type Number (double). Error
3/21/2014 12:41 AM Comment Failed to run User Defined Action. Value '' is not compatible with the selected output variable type Number (double). Error

I reset the variables to zero numIndex & numItems everytime I used the UDA with 2 Set Variables

regards

Gussy

P.S Vadim is the Best!

Thursday, December 10, 2015 8:30:29 PM
Gus Rozycki
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi All,

It may have already been answered:

Error parsing value. Value '' is not compatible with the selected output variable type Number (double). Error
3/21/2014 12:41 AM Comment Failed to run User Defined Action. Value '' is not compatible with the selected output variable type Number (double). Error

I reset the variables to zero numIndex & numItems everytime I used the UDA with 2 Set Variables

regards

Gussy

P.S Vadim is the Best!

Friday, December 11, 2015 9:56:26 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Oh great point!! Thanks for sharing that Gussy.

Tuesday, January 12, 2016 11:15:58 AM
Mary Farina
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hello Vadim,

Excellent help on this topic - I was able to use this information to create a workflow used by our Incident Managers to deliver emails to upper management while they are working current incidents.  I used your UDA to decode a repeating section in the form where they enter status every 20 minutes and the information is emailed to upper management. 

They have requested that the information from the repeating section be displayed in a descending order in the email - newest information on top. Could you provide any information that might help me to do that? 

Any help would be greatly appreciated,

Thanks!

Tuesday, January 12, 2016 11:18:56 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Mary,

Does each row have a date and time?  Or do you just need to flip the rows upside down?

If you simply need to go through the list backwards, I think that's fairly straight forward.  I think :).

If you need to order the list, then that presents some complications, but I believe it's still do-able.

Let me know which one you need and I'll see if I have some pointers.

Do you have an example of your XML for your repeating section?

cheers,

Vadim

Tuesday, January 12, 2016 2:23:58 PM
Mary Farina
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Yes - each repeating section does have a date box, then I used a Single Line Text box to get the current time.  That is followed by a Multi Line Textbox with another Single Line Textbox with a silly string in it I use to format the output.

I used your Parsing UDA (as is) with a For Each loop to iterate through each item.

But just going through the list backwards should work.

Regards,

Mary

 

Tuesday, January 12, 2016 10:00:01 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Mary,

So in the Loop action, you want to start number being the total number of items (minus 1) and you want to loop while that number is >= 0.

Then in the Math operation, you want to do a minus instead of a plus.

cheers,

Vadim

Wednesday, January 13, 2016 10:45:32 AM
Mary Farina
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

Thanks for the quick response.  I don't have the math operation in my For Each Loop - but the repeating section still works beautifully in my email.

Here is my workflow using your UDA (obviously the left side connects to the right.

And an example of the repeating section in my email:

01/11/2016 7:47 AM

The Telephony team advised that the issue is with the IVR not transferring calls to agents or to the IT Service Desk. This is a known issue that support teams had a change that was going to go in this evening to correct. Change CHG0120589 is being performed now to resolve this issue. The IVR will be down for part of this time so the support teams are moving all calls to the call centers as a work around at this time. Next update will be when new information is available.

01/11/2016 7:56 AM

The Telephony support team has implemented the change that expected to resolve the issue but the new session manager is still not transferring calls to agents when an insured wants to opt out of the IVR system. Support teams are actively working with the Avaya vendor to resolve this issue. Support teams have discussed potential options with the business and the calls will not be routed to the contact center since the IVR is still taking payments successfully at this time. Next update when there is new information available.

01/11/2016 8:43 AM

This call is being run with the highest priority until a resolution is found. The original fix from Avaya was implemented and has not resolved the issue. Support teams are working an escalated incident with Avaya. After speaking to the business it was determined that the contact center is not currently staffed to transfer all calls into the contact center. Approximately 20-25% of calls into the Billing IVR then use the Opt Out feature on average. The IT Service Desk calls have been rerouted to bypass the IVR and are now fully operational.

01/11/2016 9:30 AM

Support teams are currently working with Avaya to troubleshoot this issue. The Avaya support team is currently remoted into our system and actively troubleshooting. Support teams are working with the vendor on parallel efforts with the primary Session Manager in PDC. Next update will be sent as additional information becomes available.
 

Where would I put your solution?

With appreciation,

Mary

 


Wednesday, January 13, 2016 10:53:36 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Mary,

In the example in this post, I am using the UDA but then using a Loop action to go through each row in the repeating section.

This is what you need to use and tweak to go backwards, so that you get the order that you want.

Inside the Loop, you'll be using a Build String action to append the data to a Text variable. 

If you have this :

Row1

Row2

Row3

you're Text variable should end up with :

Row3

Row2

Row1

I hope this helps.  If you're still stuck, get the Repeating Section XML and email it to me : vadim@vadimtabakman.com

cheers,

Vadim

Thursday, March 3, 2016 9:44:35 AM
Nathan Wright
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Vadim--Amazing work. I enjoyed watching you present at InspireX last week.

Can I achieve similar parsing on the O365 platform? I obviously don't have access to the UDA as it's not supported on the platform.

 

Thursday, March 3, 2016 10:19:00 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Nathan,

Thanks for coming to my session at InspireX.  Hope it was a great event for you.

Here's a post on an O365 version in a workflow, since as you mentioned, UDA's aren't in NW4O365 yet.

http://vadimtabakman.com/nintex-workflow-parsing-nintex-forms-repeating-section-in-office-365.aspx

cheers,

Vadim

Friday, March 18, 2016 4:05:22 PM
amaresh lele
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

i gave my repeating section a name but i don't see that in the QueryXML action.Any reason for that you could think of?

Friday, March 18, 2016 5:14:17 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Amaresh,

you won't see a Repeating Section name in the Query XML action.

That name will be stored in the FormData field in the XML there.  That's what you need to query for.

Vadim

Tuesday, March 22, 2016 9:38:38 AM
Amaresh Lele
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Thanks for the reply... I figured that out and could get the details...

Anyways I downloaded the "Get Forms Repeating Section UDA".  When I run my workflow using the UDA, I get the error "Failed to run User Defined Action. Expression must evaluate to a node-set."

The UDA have 2 Action Sets, but neither Action Set has any actions within them The 2 Action sets are "Retrieve and Decode Repeater Node" and "Count Number of Repeated Section child nodes". Are they supposed to be empty?

Also how do I use the Get_Forms_Repeating_Section_UDA.nwf file? If I import it as workflow it says it's not a workflow and if i import it as UDA it says it's a workflow.

 

 

Tuesday, March 22, 2016 11:18:01 AM
brad
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

It seems that the UDA does not work if the repeating section is connected to a multi-text field to dump the xml.   I get the same error that others got:  Error parsing value. Value '' is not compatible with the selected output variable type Number (double). Error.   When I remove the Connection to the field it works.

Tuesday, March 22, 2016 11:44:23 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Brad,

that is correct and is expected behavior.  If you connect a repeating section to a field, then the XML data will not get stored in the FormData field.

 

Vadim

Tuesday, March 22, 2016 12:08:44 PM
Amaresh Lele
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hey Vadim,

Do you have inputs for my doubts.. is it something stupid I'm doing or not doing?

Tuesday, March 22, 2016 3:28:50 PM
Amaresh Lele
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

as I said i was doing something stupid. :-) didn't click the maximize option. All good now...thanks,

Wednesday, March 23, 2016 7:37:43 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

hhaha I'm glad you figured it out and got it working :)

Wednesday, March 23, 2016 11:42:03 AM
Amaresh Lele
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Loop is running too slow. I turned off the safe looping in CA but it's still run really slow. It takes 5 minutes for each loop. Is there another setting somewhere I need to check?

 

 

Wednesday, March 23, 2016 12:10:55 PM
Amaresh Lele
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

My gosh the moment i ask you a question i find the answer... After you make the change in CA it almost takes 30 minutes to replicate it even after you do IIS reset.

Wednesday, March 23, 2016 1:19:22 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Amaresh,

 

that's right.  Or, you could do an IISRESET and that reloads the Nintex products global settings.

cheers,

Vadim

Thursday, April 21, 2016 4:04:12 AM
Andreas
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

we use the international Nintex Forms (german in detail) and the Form Data (in German: Formulardaten) are empty. What are we doing wrong?

Thanks and best Regards,

Andreas

Thursday, April 21, 2016 8:24:54 AM
Andreas
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hey Vadim,

i found the solution: I have all my data stored in Panels and so Form Data is empty.
I just used the second part of your UDA to Count the rows. I didn't use Form Data, instead i used the NamedControl with the Repeating Data in it (i connected the repeating section to any multiple Text Field)

Maybe it helps someone! Regards,

Andreas

Thursday, April 21, 2016 8:46:54 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Oh interesting.  I didn't think Panels would do that.  Thanks for sharing this Andreas.

I really appreciate it.

Vadim

Friday, June 17, 2016 8:58:32 AM
Steve
Gravatar

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim, is there a version of this for Infopath 2010?

thanks

Steve

Friday, June 17, 2016 2:34:51 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Steve,

have a look at this : http://dataqueen.unlimitedviz.com/2013/05/exporting-infopath-repeating-table-data-with-nintex-workflow/

cheers,

Vadim

Friday, September 9, 2016 4:33:44 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

I seem to be having nothing but failures even when using the .uda and .nwf files provided. Does this only work to pull only the fields in the repeating section? And can it pull the text from a lookup field in the repeating section?

I have a form that users fill in their basic info for marketing items for their location and then enter in the products they want for the coming year. After running the workflow I get the same number for all the fields in the three sections of the repeating section. 10011, 20012, and 5022 for all 6 fields in the repeating section. I have Nintex looking into this but they haven't been able to figure this out but maybe someone here has had this issue and has an idea of what I am doing wrong?

Thanks

Friday, December 16, 2016 3:23:36 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hello, Vadim.

I have a question for you similar to this, but not exact. I want to parse the data from an HTML table in the body of an email. We have an email enabled SharePoint library. The SQL database generates an email with a table of data. That email will come into the library and I want the workflow to parse the table apart and populate a list. I have done this before with CSV .txt files, but not with an HTML table.

Surely this must be possible. Is it? Or is it easier on everyone to ask my SQL team to just create a CSV .txt file and send that instead?

Monday, November 27, 2017 1:31:35 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

We are using the XML data to add a new item into a daughter list.  Unfortunately, every time we edit the repeating section, it adds any existing repeating section again.  How can we only write a new item with any new repeating section?  Is there a way to only use the new XML added from each new repeating section?  Can the loop only loop through new added repeating sections?  Thank you Ren NAt

Monday, November 27, 2017 1:35:17 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

So you want your workflow to only process newly created rows in the repeating section?

Monday, November 27, 2017 6:24:04 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Correct! We have a "create new item" in the workflow, which uses the XML data. We are using the  same workflow template that you provided in this page.  It works well, However the loop keeps re-writing a new item in the daughter list each time we edit the item.  We only want it to write a new item in the daughter with each new repeating section. 

If it helps to visualize it, the repeating section is used to add call notes to a case (has a date, time and a call note).  Every time we edit to add a new call note, let's say note # 3, we end up with a repeat of #1 and #2 call notes.

Thank you

RNat

Monday, November 27, 2017 9:44:26 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi RNat,

somehow, you will have to store something somewhere to keep track of which ones are new and which are old items in the repeating section.

Maybe look at this : http://vadimtabakman.com/nintex-workflow-order-and-order-items-relationship.aspx 

Vadim

Thursday, March 15, 2018 2:59:57 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hi Vadim,

I have been using this UDA with success but something happened.I attempted to create a new workflow and the UDA does not work.

After I add it and try to configure it I get a pop up stating Sorry, something went wrong. 

 

I redownloaded the UDA and tried it. Samething. It is dated 10/18/2017. The previous was dated sometime in 2016.

So I checked my other workflows. I am not able to configure those either.

They seem to run without error but the loop has a yellow exclamation sign. 

When I mouse over it the UDA turns red with a warning stating the following fields must be configured. 3 fields in the old and 4 in the new. 

The only thing I can think of is I recently upgraded Nintex Forms and workflows.

What else should I check?

 

Thank you.

 

 

Thursday, March 15, 2018 11:24:12 PM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Hey Sonoma,

I don't know what would cause this.  Can you try to open the UDA design, and republish it and see if that helps?

What version of SharePoint and Nintex Workflow are you using?

Vadim

Friday, March 16, 2018 6:54:23 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Thank you for the reply. It is actually working this morning. Odd. I tried it on a few systems including the SharePoint server. All the same. The server does not appear to have rebooted but there are a quite a few MSI install events and a few Timer errors which have resolved themselves. Not sure if that is it or not. I even looked for the web iis restart. Nothing. 

Server: SP 2013 onprem

Workflow Version: Nintex Workflow 2013 (3.2.5.0) - English

I was getting a little worried there. Still a little.

 

Thank you.

Friday, March 16, 2018 8:22:55 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

How weird.  I've never seen that issue before.  I'm glad it's working now though, Sonoma.

Vadim

Friday, March 16, 2018 8:41:51 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Thanks.

I may have spoke too soon. I created a new workflow and setting it up goes fine. Now when I publish or save it I get this error.

This sites says...

soap:ServerServer was unable to process request ---> Could not find stored procedure 'GetPublishedUserDefineActions'.

I have tested my old workflows and they give the same error. Luckily the workflow kicks off as a record is added and it puts the data in the child list properly. 

 

I am still new to Nintex and Workflows. If I am unable to use this to get populate my child list what are some other techniques?

 

 

 

 

Friday, March 16, 2018 8:58:09 AM

re: Nintex Forms/Workflow - Parsing Repeating Section Data

Adding to my reply. I really like the simplicity and do not want to change a good thing if possible. :)

 

-Update - It seems after my last Nintex Update I lost my stored procedures. Since that was my first and only I have no clue if I just did it wrong. But I know what to look for now. Thank you again for this UDA.

You must sign in to this site to post comments.
Already Registered?
Sign In
Not Yet Registered?
Register





 

Statistics

  • Entries (276)
  • Comments (1769)

Categories