_BR_ENCODED_ markers are not replaced for text formula values used by Apex/Flow/Process when those values are populated in other text/text area fields
Last updated 2019-06-15 ·Reference W-2586676 ·Reported By 1000 users
When users attempt to use a text formula value which contains the BR() function for newline characters, the _BR_ENCODED_ markers are not being replaced with new lines as expected.
Currently, if an Apex Trigger or Flow/Process attempts to use the formula value as the value for another text/text area field, the _BR_ENCODED_ markers are displayed and stored within that new field.
1. Create a formula field ("Text_Formula__c") which returns multiple lines of text using the BR() function. Example syntax:
"Line 1"+BR()+"Line 2"+BR()+"Line 3"
This syntax displays in the formula field as
2. Create a Text Area field ("Text_Area__c") on the same object.
3. Create a Process (using Process Builder) on that Object. Add a Record Update action to update "Text_Area__c" with "Text_Formula__c". Activate this Process.
4. Trigger the Process on a new or existing record.
Expected Result: "Text_Area__c" is populated with the value of "Text_Formula__c" including the line breaks -- i.e.
Actual Result: "Text_Area__c" is populated with the value of "Text_Formula__c", but _BR_ENCODED_ markers are not replaced with actual line breaks -- i.e.
Line 1_BR_ENCODED_Line 2_BR_ENCODED_Line 3
Avoid using Apex/Flow/Process to populate a text/text area field with the value of a Formula that contains BR() functions. You could use workflow rules for the same.
Another option is to create an additional formula field that reflects the contents of the text area updated by the Process. That formula will display the value as expected. >>> e.g. Continuing the example above, you could create a formula like "Text Area Mirror" with syntax Text_Area__c, and place that formula on the layout.
Fix for this issue was released in the form of a Critical Update for Summer '19. For the fix to take effect, please activate Critical Update below:
Reported By (1000)
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.