How to allow SP 0365 Repeating section to accept double /single quote and new line?

  • 11 October 2021
  • 2 replies
  • 4 views

Hi All, 

Need your help please, using SharePoint 0365 my form has repeating section with multiple line of text. I have a workflow that has Query XML to get my multiple line text data, then inside my for each loop, I also have Regular expression action with my collection variable and I replace with this pattern 

[^a-zA-Z0-9-_ _;_._%_(_)_/_-_=_#_$_:_?_ ]

But when the user enter " or ' it will convert to html hashtags like &quot.

How to allow SP 0365 Repeating section to accept double /single quote and new line?


2 replies

Hello,


 


Try and insert a Build String action after you first query your XML.


I usually insert this before my loop.


In the Build String action, insert the following function,


fn-XmlDecode({ItemProperty:RepeatingSection})


(Where ItemProperty:RepeatingSection is the connected field to your Repeating Section/SharePoint column).


Output the result to a SLT or MLT variable.


 

Hi AJcrow,
Thank you so much for speedy response, the XML decode function is not working in SharePoint Online (0365). I tried to type "Testing" and I got this "Testing" Only

Reply