Special characters in repeater table are replaced by junk values

[hema2930]

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.

Result is s below.

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

Please help me fixing this issue.

Regards,

Hema

[SimonMuntz · Accepted solution]

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.

[hema2930]

Thank you much Simon. It worked!