I have a multiple line text field in sharepoint list, its value is very long. I was trying to copy the first 50 letters from the multiple line field into a single line text field.
I created a simple workflow and have an action called Set Field in Current Item and it just doesn't work. It never pass that action.
Any idea on this issue.
Thank you in advance.
Solved! Go to Solution.
You need a Regular Expression Action followed by a Extract Substring from Start of String action and finally a Set Field in Current Item action.
1. Regular Expression to Remove HTML Tags contained in the Multiple Line text: Source
The pattern is: <[^>]*>
2. Extract Substring from Start of String to get 50 first characters from Multipel Line
3. Set Field in Current Item to set Single Line Text: Target
Hope it helps