Nintex Workflow - Update Multiple Lines of Text
Over a year ago, I had a need to have a workflow update/append text to a Multiple Lines of Text field. I figured out one way to do it, based on having a MLoT field that was set to Enhanced rich text. Then I completely forgot to blog about it. This came up again in a question I had recently. After trying to figure it out, I found my solution from last year. Better late than never right? Speaking of which, if you haven't seen this, check it out.. it's great - Better Late than Never.
I do want preempt this, that because we are dealing with Enhanced rich text, the structure of it may be different when you have entered data into your field.
[Image unavailable: MLoT-Settings.png]
Here's an example of an item with text in that field:
[Image unavailable: Item.png]
When running the workflow I have, the first thing I do is log the value of that field to the workflow history.
This is what the data looks like in that field:
[Image unavailable: InternalMLoTStructure.png]
As you can see, the internal structure is HTML (xml). So adding new rows, is as simple as adding a <p> node with the data in it.
We can start off with storing the current value of a MLoT field into a MLoT variable.
[Image unavailable: SetAVariable.png]
Next, we want to add one piece of text and append it to the end, but on a new line.
[Image unavailable: UpdateXML.png]
Here, we are using an Update XML action, and performing an Add child node, and adding a <p> html node.
Finally, the result is stored in a Multiple Lines of Text variable and then we use an Update Item action to update that MLoT field.
[Image unavailable: UpdateItem.png]
I hope this helps some of you. I don't have a download for this example, because I believe that everyone will have slightly different data in their MLoT field, so you'll need to tweak the workflow to cater for that.
But this will at least give you an idea of what to look for if you need this.