I have a flow that populates the content of a ContentNote record. i use a formula that combines values from various variables in the flow and concatenate it.This concatenated text is displayed in the body of the contentNote record.

I am facing issues in adding linebreaks between the two concatenated formulas.I have tried everything BR(),
, /n,/r,

,Substitute((text),"~","").Nothing seems to work.

Plz help!

enter image description here

enter image description here

  • I don't know if this will work, but have tried using a Text template instead of a formula? They are meant to hold formatted data. ( help.salesforce.com/… )
    – Kasper
    Aug 18 '17 at 19:49
  • You mean text template with the br tag?
    – Meena
    Aug 19 '17 at 10:38

Just tried this and the following works :). Create a Text template variable and in it put your first variable, than <br> (no slash) and than your second variable. If you use that as the Content of your ContentNote you get a line break in between the two varialbes

If you do use <br/> the flow will crash when you run it. I hope your variables don't contain anything to exotic or the flow may crash as well.

This solution also works for formula variables. (Text templates don't allow formula expressions, so we can't make the break conditional using those.) So if you want to do this just use this in a formula and assign it to the Content of the ContentNote:

FormulaBaseBusiness &
IF(ISBLANK(FormulaSalestarget), '', '<br>') &
  • Just one small doubt..The flow fetches the value to be displayed, from fields of a customobj and displays the data in the content of the contentnote .So if user doesn't edit one of the four fields used in the flow the flow adds linebreaks anyway! So it makes my content look a bit uneven. Any suggestions?
    – Meena
    Aug 19 '17 at 19:16
  • @Meena I edited the answer a bit. I think that should solve it. Happy to have helped. –
    – Kasper
    Aug 20 '17 at 6:54
  • The edited answer works just fine as well!!:)
    – Meena
    Aug 20 '17 at 7:30
  • Hi Meena. I found your new question, and answered it there.
    – Kasper
    Sep 5 '17 at 19:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.