cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Need help with inserting Newline:

Jump to solution

Hi,

I have a multiline SharePoint column in custom list that I am updating via workflow.  I am adding text to the column that I want separated by lines.  I've tried entering in manual carriage returns, and have tried inserting the Newline from the Common tab when using insert reference.  Still the text shows up on a single run-on line.

There has to be something simple I'm missing?

Thanks!

Troy

Labels: (2)
0 Kudos
Reply
6 Replies
Workflow Hero

Re: Need help with inserting Newline:

Jump to solution

how do you have set that field,being plain text or RTF?

try to insert text there manually (eg in QuickEdit) and investigate how is it stored. then make your updates based on that.

Reply
Workflow Hero

Re: Need help with inserting Newline:

Jump to solution

Thanks for responding Marian. I have it set at Rich Text.  Maybe it should be plain text?   Was looking at manually editing but wondering how I'd even throw in the right combination of characters...further investigation..

0 Kudos
Reply
Workflow Hero

Re: Need help with inserting Newline:

Jump to solution

plain/rtf - depend on your needs

for rtf formatting - SP internally stores it in HTML format, so you may need to do something like this

0 Kudos
Reply
Workflow Hero

Re: Need help with inserting Newline:

Jump to solution

Hi Troy,

Try adding the '{Common:NewLine}' in 'Build String' action and then add your variable to the field. It has worked for me in past.

Please share your solution.

Hope this helps!

Mandeep

0 Kudos
Reply
Workflow Hero

Re: Need help with inserting Newline:

Jump to solution

HI all,

Marian set me off in the right direction :-).  I ended up putting in <BR>'s which worked within SharePoint.  Common: Newline didn't work in any scenario (using it in a build string, or directly in the Create Item action). 

However, the whole purpose of putting in the Newline is so that it looks "pretty" when we export the data to Excel for manipulation.  So it now looks great in a  SharePoint list, but when exported to excel, the <BR>'s don't translate.  Just FYI for anyone trying to do this in the future.   But this is something I'll look into..might have to throw in  <P> or something like that.

Thanks all for your input!

Cheers,

Troy

0 Kudos
Reply
Workflow Hero

Re: Need help with inserting Newline:

Jump to solution

Hi Troy

Did you work out how to export to excel without the <BR>s? 

Jo

0 Kudos
Reply