I have multiple line string with content
I want to convert this string that it looks like this:
Can I use the replace string object for this? Or should I use regular expression?
What is the "new line command"? I already tried "\n" and "<br>"
Please check out Vadim Tabakman blog post on using using the Regular Expression Action.
Basically what you will need to do is do a SPLIT on the --- using the Regular Expression Action and then save your results into a Collection Variable, then Loop through your collection to do something or use the collection actions to get a certain index at a certain time. Let us know if you need more help with this.
I had seen the post from Vadim Tabakman, but unfortunately it doesn't work here.
I have a comment (within task list in column "Comment") like
I did a query list and wrote the content into a collection variable.
First I tried this:
I also tried this:
So neither split nor replace gave me the desired result.
Hi Michael Weiß,
Can you use 'Regular Expression' action and in the replace text use 'Enter' from keyboard.
It worked in SharePoint 2013, try it in Office 365.
This makes things so much easier - I used a set variable instead of a query list action to retrieve the data.
With that the comment is directly written into a text variable and not into a collection. Within the text variable the format is automatically correct.
PS: I cannot mark your answer as correct because the question itself is still not answered. But I do not have a problem anymore!