Manipulating text in flows

i occasionally need to iterate over a list of records in a sObject collection, and display values from the records in a screen.

back in the day i got some crucial help from salesforce yoda / mark ross on this developerforce post, which pointed at the approach.

use a text variable to store the final concatenated text for display.
call it : vaFinalText

use a loop to iterate over your collection. in the loop, use an assignment element with a text template that references the loop variable to add data to the final text variable
call it : ttLoopText

and use a constant, with a value of < br /> to add line breaks between each loop (which i cribbed, probably from this post)

this approach of using the <br /> in a constant works fine in many cases, but not in email, as flow emails are strictly plain text, so the <br /> comes through exactly as entered.


i had seen some solutions for this that involved a text template and a substitute function, which i was hoping to avoid. so after about 13 failed attempts, i found a winning recipe:

create a constant, w/ a value of globalconstant.emptystring
call it : conGCES


in a text template, add the constant, a line break (ie click enter), and the constant again. call the text template ttLineBreak


use that text template to insert line breaks. you also could just wrap your loop variable text with conGCES in ttLoopText


and voila, a flow email, with line breaks.


flow doesnt come easy…makes you work for it…


Now read this

Creating a Global Picklist with custom API values

Global picklists are great. As is the ability to customize the API names separately from the label. But while you can create picklist values via copy/paste, you have to update the API values individually. For small picklists its not that... Continue →