Skip to main content
Nintex Community Menu Bar

I have a Nintex form with a repeating table. There has been a change in requirements to start using some of the data in this repeating table in a workflow. So on my SharePoint Online list (where I have the form data being saved) I’ve created a new multi-line text field. In the forms designer, I’ve connected my repeating table to this new field, and re-published.

Now when I open a previously submitted form, this repeating section on the form is empty! Where did the data go?

If I disconnect this repeating table from the list field, and republish, then the data in the repeating table re-appears if I open a previously submitted form.

The form has been published to the SharePoint list, so it’s the default form when users to go to create a new SharePoint list item.

Hi ​@JeffOliverOtay,

Welcome to the community.

When submitting a Nintex Form in SharePoint, a hidden column named NFFormData is created.
This is where the data for the repeating section is stored.
By connecting the repeating section to the multiple lines of text column, you are breaking this link.
The NFFormData column can be accessed from your workflow, so there is no need to create a multiple lines of text column.

This column is in XML format and contains the data for all unbound columns, variables, and file attachment information, so you will need to extract the repeating section XML from within this data.

Thank you very much for that helpful information. There’s no way I would have ever known that, so super helpful.

So I was able to use the Query XML action to extract the repeating data from the NFFormData variable, but now the problem is the data is all encoded!!

It looks like this:

<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version></Version><Items><Item><_0e717ee834df4bb6bb79415eecf3933e type="System.String">14</_0e717ee834df4bb6bb79415eecf3933e><_3e0fb9af3b86442a9a872ea565a449fe

How do I decode this data so that I can use additional Query XML actions to extract the data I need from the repeating section? The fn-XmlDecode() function doesn’t work in NAC.

Hi ​@JeffOliverOtay,

Yes, you are correct, there is no XMLDecode function in Nintex Workflow.
This means you have two options.
 

  1. You can replace the text. I recommend doing it in this order.
    Entity Character
    &amp;lt; <
    &amp;gt; >
    &amp;quot; "
    &amp;amp; &
    &amp; &
  2. Or you can call a web service that will decode the string for you. You may need to call it twice as the string is double encoded.

Hi ​@JeffOliverOtay have your questions been answered? 

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings