Special characters in repeater table are replaced by junk values

  • 2 September 2019
  • 2 replies
  • 36 views
H
Badge +6

Hi All,

 

I have a repeater control on my form and through workfow i am creating table using the repeater XML.

If i enter any special characters in repeater it is replaced by junk vlues in the Table.

Column connected to repeater is Multiline of text (Plain)

Column storing the Table is Multiline of text (Enhanced rich text )

Below are my form and workflow.

Inside workflow i am querying the XML and storing it to collection varible. and then setting the shrepoint column with the collection variable.

4224i043DAB64D68B9CE6.png4223i8EF8F261215FA9A7.png

 

 

Result is s below.

4225i173AAB2D9B5F719A.png

in third row i entered ;tets" but it is replaced as show above.

 

Please help me fixing this issue.

 

Regards,

Hema

2 replies

SimonMuntz
Userlevel 6
Badge +22

Hi,
This is expected behavior.
The characters are encoded so that the XML output of the repeating section is not messed up.
Add a build string action to your workflow and put the xml from the Multi Lines of text(plain) column through an fn-XmlDecode() inline function.
e.g
fn-XmlDecode({ItemProperty:RepeatingSectionColumn})


Save that output into a Multi Lines of Text variable and then use that variable in your Query XML action.
If the issue persists, copy the build string action and paste it under the first as this will put the XML through the decoder twice.

Cool Nintex courses: https://learn.nintex.com/
H
Badge +6

Thank you much Simon. It worked!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings