I am no stranger to FormData. I have parsed many a repeating section. However ... for whatever reason .... the FormData in my current item is just.. nothing. Something is wacky. I have connected FormData to a multi-line column, I have added that column to the view ... nothing.
It's also no longer giving me back XML, it's giving me this kind of thing BEFORE it goes into the Forms Repeating Section UDA ( via Vadim Tabakman ) .... ("variablename" in place of all variables for censoring)
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><VariableNametype="System.Double">2222</VariableName><VariableName type="System.Double">2359</VariableName><VariableNametype="System.Double">6.1</VariableName><d3a775e7-2f2f-45f4-9b69-5c081ad273d0 /><VariableNametype="System.String">98.1</VariableName><VariableNametype="System.Double">20</VariableName><VariableNametype="System.Double">2265</VariableName><VariableNametype="System.Double">0.2</PercentOversizeDecimal><VariableNamewtype="System.Double">6.8</VariableName><VariableNametype="System.String">true</VariableName><VariableNametype="System.Int32">1</VariableName><VariableNametype="System.String">98</VariableName></Item></Items></RepeaterData>Sample ID: ID-123
And this kind of nonsense AFTER it comes back from the UDA... (SEE FURTHER COMMENTS FOR MORE DETAILS & UPDATES)
The repeating section is named the same as it always has been
.. and it used to work. Nothing has really changed, I've checked variable names against this.. everything comes back blank or 0.
I feel like I must be missing something REALLY stupid. What should I check?? Am I crazy, this SHOULD come back LOOKING like XML, right??
Solved! Go to Solution.
this doesn't seem to be whole FormData XML, it looks like you already picked just repeater part out of it.
"Sample ID: ID-123" at the end of your sample doesn't belong to repeater data. it breaks validity of XML so that's likely the reason UDA do not provide expected results.
btw, it's better to create multiline text field(s) in list dedicated to (each) repeating section on list form...
Hi Marian - thank you - I do have a dedicated column ("FormData" - multiline) which I've connected the repeating section to. ...But nothing is there. Completely blank.
And, I agree with what you're saying in that it doesn't look like the whole FormData XML ... but that's what it's giving me before going into the UDA
Hi Rhia Wieclawek,
first of all I would rename the column! (deleted & created new one to be extra sure column's internal name is not preserved)
there is already existing hidden FormData column. so it might happen sometime is updated one column and sometimes the other. that would explain those broken data.
You can't connect the form data to a column. But you can update the column with FormData using workflow. So It should be the repeater control data that is connected to the column. Make the multiline column as plain text and try. Something went wrong with the QueryXMLData control.
Okay I'm kind of working out loud here..
This is the fail point:
NWF.FormFiller.Functions.GetValue(&amp;amp;#39;382522f3-e8e8-43a1-94cb-13c03e961a07&amp;amp;#39;, sourceContext, &amp;amp;#39;string&amp;amp;#39&lt;/beada732-0784-4577-97fd-467e31954290
Now I just have to figure out what ^ that is.