_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

Fixed - Summer '19

Summary
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.

Repro
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
-----
Line 1
Line 2
Line 3
-----

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.
-----
Line 1
Line 2
Line 3
-----

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
-----

Workaround
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.

Updates
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:

https://releasenotes.docs.salesforce.com/en-us/summer19/release-notes/rn_forcecom_flow_cruc_br.htm

Reported By (1000)

Héctor Martínez Saizad Prasla Ben Hill Paul Johnson Jake Rudman Sowmya Vutukuru David Marx Stefan Fostier James Ota Ariel Lopez Paul Carass Copado ServiceUser Juan D. Robles Swaminathan Ganesan Jodie Jones Ryan Christie Masahiro Suzuki ThreeDot Developer Kivanc Oner Bill Florio Anthony Scannicchio Claudia Gomez Gaël Perriot Yuta Hattori Rebecca Crahen Charlotte Anongos Patrick McCormick Premier Admin Benoit BONNEFOUS Arlene Owens Dimitri DEBAERE Quy Luong Victor Abraham Kristin Cecil (work) Edson Hidalgo Peter Wonson Dave Laver Trevor Weimer Peter Wouda NETU NETU Ian Dexter Maya Heather Simoneau Ivan Kliavakin Dan Sherman Chris Gerardo yoko kumada Maria Malczyn Pamela Barrios Laleh Moossavinassab Christopher Smith Eric van Horssen Dency John Michelle Mallo Peter Tschaekofske Kevin . Ben Schauerhamer Jake Richter Richard Francis Atsuhiko Kimura Bill Fox Daniel Ramirez Eshwar Chandrasekaran Scott Rich Daniel Schell Adam Benaroch Evaldas Micius Emilie Jensen Cameron Boyce Guillem Bergadà Wes Hamasaki Erem Örs Jesse Hendricks Charni Wiggins Stefan OHalloran Sofiane Hakim Rebecca Turner Krishna Narne Irvin Ocanto Ben Scarborough Elizabeth Pembridge Tish Sherwood Jean-Bastien Dussart Kazuhiro Nishino 和紘 西野 Theodore Blagg Dani Jay Mitch Ebin Challas Ray 美帆 飯塚 Yann Arrouet Shixin Qiao Gage Staruch ADAM ERSKINE Chris Hajdu Sascha Horn CRM Science Glenn Montano Cody Sanders Travis Wasson Barry Clark Colson Griffith Citlalli Del Villar Nick Kennedy Bill Tsatskas Wicky Rampersad C Harris Micahel Andreacchio Dominic McCarthy Girish Kotgire Kirk Carpenter Jason Siders Nils Tertling Stephanie Ouadah A. Miah Sara Forbes Yamato Chino Clay Hilte Hallie Hemingway Drew Kennedy Aaron Lucas Luke Van Blaircum Maria Prieto John Kuhne Tsuyoshi Watanabe Tasos Papadatos Derhyk Doggett 諒太朗 原 Robert-Jan van Erp ADM Stefanie Meyer Leela Nalluri Douglas Gardner Thanh Binh Tran Ravi Shankar Kandepi Edie Harrison Ayami Yamasaki Remit SBI Marco Wittig Neema Rawat Chris Uttley Hans Hong Sean Regan Sean Regan Ed Scott Amanda Anderson Chloe Courtois Cindy GUILLET Meredith Choy Melanie Markham Jorah Larocca Michael Torchedlo Ashley Jones Meaghan Gilmore Ryan Frazee Taylor Boyer Peter Bengov Matthias Guenther Pete Premier Lawrence Lam (TS) Bree Beach Edward Zaragoza Landen Wasserstrom Anne Nuguid Jason Hoult Takuma Ogura Mark Mogridge Dylan Stai Brandon Walton Erik Burton Sam Floyd Melissa De Pau Bill Hoke Kris DeTrano Laura Gomez Peter Premier Eric AMIEL Jaroslavas Karmazinas James Goerke Chris Forsha Matt   Brandon Chang Patrick McNeal Christopher Magnell Nagraj Gornalli David Bruce Michael Grandel Richard Wasserman Arnt Haering Matt Hagey Greg Althoff Patrick Pilvines Marta Paddeo Taha Syed Mayank Sharma Robert Méndez Adam Steinhoff Sujay Kothapalli Rachel Sellers Richard Hensley Harmen Korfage Annie Waddill Orest Skoropad Edgar Sampson Andrey Klyuyev Denis O'Leary Neil Scott Yoann Beurier Ben McLeod Glenn Lehner Gavin O'Brien Jonatan Adebäck Thomas Fursdon Stephen Rathjen Ram Pratap(UPI_L1)_TBSS Amr Khalil 宗平 魚谷 Will Joice Impact Box Shadé Loggenberg Stephen Cormier Wim van Strien Chloe Aiani Casey Bomar Giulia Mosca Lyubov Zarodova Jon Kraybill Jon Sweet Eszter Huszar Christina Whitfield Jeff Battles Paul Rebman Bradley Haines Elisa Pelegrina Dean De-Viell Dorel Nasso Ben Falter Carl DeCecchis Samantha Reilly Remy d'Arras Lorenzo Alali Admin NTT Leonardo Sasounian Bongiovanni Gary Davis Christen Bejar John Smith Hannu Holopainen Craig Berko Per Eric Johansen 風也 三輪 John Assheton John Shea Rabel Racka Stas Dunayev Maciej Sobkowicz Paweł Fronczak Andrew Mondy Patrick Pilvines Alexis Kasperavičius suyu xie Simon Lafont Dan Kamins Stuart Smith Felipe Kuninory Akitaya Ben Wells Ursula Schreiner Ralph Blanco Sri Vidya Bommineni Isabella Pellegrino Michelle Lavalette Isabella Thompson Jason Terrell Tommy Strickland Tracy Gibbs Amber Venzke Tsuyoshi Miyake AVS ADMIN Hannah Hoersting Wendy Bouman Ray Mallaire Samuel Frost Jennifer Dunn Dmitry Borisov Matt Kent Karsten Maaß Anupam Jaishwal Akihiro Aizawa Coline Ludwig Arjun Gupta Kris Ryan Olga Loza Bernard Verhoeven Camille Lambert hikaru kurono Yidan Wang Damian Kowalski Ryosuke Kawamura Bertie O'Brien Adrian Camua Juri Hizume Adam Burns Parker Edelmann Dimitris Mitsios Joshua Troglia Chelsea Feltham Ariel Litman Benedikt Eping Matthew Danna Ramesh Varatharaj Jacob Landis Tony Kayyali Yelena Slobard Sarah Chen Brandon Baldwin Luke Osmundson Dan Donin Scott Eng Flore Meric Kamran Khan Sandra Cameron Jean Jaenicke Christine Hearn Ciaran Roe Chris Vickery Ken King Arpit Gupta RJ Palombo Angela Day-Keith Christopher Blachowski Juan Hernandez Daniel Morgan Matt Edmonds Stephen Clayton Friendly Tester Sam Mohyee Paul Hardacre Rob Evans Piers Anderson Mark Pieter Shruti Bhiwapurkar 昌美 小澤 Mendy Ezagui AppSolve Team Brian Runyan Derrick Abbey Alastair Batchelor Nathan McMahon Masaru Tanaka 毅 髙橋 r t Alex Ekblad Michael Wehner Virginia Lux Lawson Teo Chris Gooding Alastair Dinning Phil Medina dan hopkins Katie Nix Matt LaMond Himanshu Nath Marc Lehmberg Starrdata Admin sanchit Kaushal Guilherme Tuacek Summa Admin Bernd Claßen Amy Gorham Dan Moore Leslie Waters sergio Alvarez Alonso Richard Thompson Charlton Hua Mark Seifert Monisha Sarkar Maraike Stein Matthew Sai Mohammad Housaini Bill Miller Jessica Puckett Marina Shuman Esti Gershonowitz Doug Burkhart Oliver Khan Hui Newnham Andy Nguyen Kyle McKay Alain Anterieux Stephen Burgess Sravanthi Yarava Caden Reiman Korhan Mulcar Katharine Anderson Aaron Allport Brenden Burkinshaw Cameron Cohran Nele Depraetere Ross Dickson Chris Fezza Nayana Suresh Marja Yli-Karhula Stephanie Boggs Erik Wintrich Peter Doten Cory Bennett Sai Inavolu Jon Brewer developr'"><script>alert()</script> asda Mike Hyer Jennifer Buck Joe Mitchell Kevin Liu Marketo Sync William McLaughlin Jesse Wolff Admin User Pamela Barrios John Flaherty Guylaine Gauthier Zev Grunsweig Mohd Hafizi Khiruddin Hector Cabrera Diaz Hunter Kim Kyle Corsaro Brian Mathews RE RETEam Sabrina Trampal-Bertolero Ed Pashkin Nicole Edwards Devin Rhoades Shane Jensen Alicia Rozeboom Breeonah K Mike Bogunov Anthony TRINH Isaac Lewis Christian Fritz Louise OBrien Dennis Welter Natalie Davis vijay gangani Bonita Elevario Kamilia Bouraoui Brent N James Underwood Joe Englert Christine Blakeney Julie Bond Elle Regan Steve Kellenyi Jeffrey Wong Kim Jenkins AVS Monica Thornton Venkat Kali Danny Abdeljabbar Geetha Kandukuri Janise Dismuke Yann Seddik Peter Sinka Sean Etherington Anna Loughnan Steve MunLeeuw Sri Lakshmanan Matt Elstad Jason Walke Kayla Greenberger Lauren Kamrad Susan Nordquist Igor Tenyuta Raksha Meanger Jason Vance Shailendra Singhai Anna Freund Mark Bailey James McVicar Ambrose Alward Admin Support Daisuke Akaza Graham Hopgood Prateek Kumar Alberto Minardi Marko Stankovic Radhika Kollepalli Sam Howle Oliver Preuschl Raghavendra Akunapuram Desarae McColley Prakash Sriram Eva Mooney Alon Waisman Martin Krchnak Jericho Ruan Mattias Nordin Jim Clifton IT Admin Hugues Beaurivage Braden Perry Robert Howell Sam Fenn Kannan Raju Carolina Röller Ben Prozinski Brad Mampe Mike Mikula Jennifer Bower Cate Schlarman AGS Admin mandy ensign Kalue Her Luke Fitzwater Stephen Eaton Itzik Winograd Erik Nejman Jacob Marshall Bernhard Leitner Brad Gross Dominique Wallace Saket Kolhapure Admin TM TW Jacob Marshall Michael M Gabriel ESSEMINI haritha peddireddy gari CopperHill Consulting Valli Gopalakrishnan Joseph Buege Joe Buege Raz Yogev Federico Segundo Rubio Jeanette Hagan Manas Mishra Nana Gregg Andrew Blair Carl Herman Gorav Seth Daniel Morán Christoffer Andersson Chris Lightley 昭弘 相澤 Morten Justesen Eric Smith Jeffrey Malin Terry Miller Karen Brown Pierre Crouzet Alan Faubel Tim Lomison karen brown Padam Sharma Liat Erez Charlotte Koocheki Jamie Buck-Tomek John Graf Natali Stratieva Chris Kilburne (ext.) Bud Heaton Nate Bunker Audrey Marlow Neil Kim Laurence Taylor Carlos Frias Seth Partridge Ram Efe Cameron Aiello Christian Sack Rachel Dew Jack Linstead Jon Casey Rajasekhar vemula Renan Moreira Tawfik El-Sarrag Bill Ramsay Grace Anderson Gillian Reynolds Jim Weldy Will Rus Jodi Jenkins Kid Jansen Donovan Kruger brett thompson Muhammad Bilal Martin Vyskocil Steve Blackwell Amanda McKellar Crystal Karanovich Brian Bacharz Elizabeth Akerman Carl Anderson Paarth Jolly John Thiltgen Stephanie Foerst Marc D Behr Ruth Whincup David Poynter Christian Reichert Wai Keong Wong Nur Husnidha Hussain Theodore Blagg Kurtis Teel Adam Braxton Vinny Poliseno Amanda Kohser Matt Denault Constance T Jack Hammond Matt Young Megan Brooks Vinu Vijayan Ed Castillo Ashwini Natarajan Philippe Labat Charlotte Noordsy Kendall Newby Adrianna Carlesimo Sadahiro Suzuki Tanya Woods Alexandre Mendes Martijn Reekmans Ian Brown Ralf Wittenberger Antonio Torres Kristopher Estrada Nigel Le Brett Morgan K R Ben Bromberg Jeff Honnold Wilfredo Morillo Cody Kindschuh Mike Elms Anna Bilevskaya Judy Tang Andrew Barash Anurag Joshi Nick Petersohn Andy Lavelle Grant Garrigan Lindsay Holmes Josh Sangster Chuck Tomlinson Nicolas Devillierre Stephen Long Jim Delaney Stacy Hyatt Laura Naselli Alex Maier Adam Saal James Winter Christopher Shade Balaji Sai Pavan Ayta Lars Nielsen Patrick Nylen John McElroy Chris Lance Chad Harris Evan Arbeitman Jason Gladstone Erin Yamaoka Chris Govett Dan Howell Arturo Rodriguez Martinez Benjy Hunt Deepthi Kudrathaya Aziz L Hilary Henderson Virginia Giraut Adam Moreno Michelle Mallo Joe Smith Santosh Dantuluri Tee Yong Lim Lisa Walker Carena Ng JULIEN HILD Chris Appels Manisha Palsana Jake Harrison John-Paul DX Krishna Kanth David Smith Mark Lester Cabrera Brian Shor Tim Shores Rob Crossley Brian McKenzie Sam Satterfield Alex Packard Eric Hoskote Emma Henderson Brian Strack Jake Romphf Mary Tagler Trinh Harrison Janelle Gardner John Alexander Constance HUA Jeff Chan Jhomann Carreon Fabian Peters Kenneth Dillon Daniel Dynon Rob Cowell Lisa Mashkouri Ross Collinson Jay Jordan Shaun Bridges Miho Kaizuka Kimberly Dy Tim Meehan Matthew Gladman Data Ops Julie Force Jan Griesgraber Candice Allen Sandi Zellner Michael Tombrello Salesforce Admin Salesforce Admin Ralf Hamester IsochronixMind isochronix Milena Voronkin Kyle Broeckel Chris Kellie Carissa Crittenden Michael Torchedlo Scott Rosemary Melissa Frievalt Mohammad Asim Ali Rob Rung Mark Dodgshun Steve Rosner Rohith Raj Chenna Ben Johnstone Mark Brown Alex Townsend Kit Shepetys Blueprint Wealth Lawson Teo Emma Henderson Admin Manpower Admin Chattry Meas Tim Slijp Service Account Frank Reed Ian Womack Brian Zehnle Gloria Gutierrez Pattie Heintz Leanne Ardley Joseph P. Smith Dominic Ionadi Zac Otero Alexander Schätzle Kari Abbott James Foxon Leslie Tilton Olivia Nixon Erin Sherrell Samuel Lau Liz Vokolek Lisa Clossey Mapfre RE Derek Anderson Mondaycall Consultant Fabian Peters akshay kumar Stephen Wood Agustin Bruno demo user Matthew Steiner Jen Bowen Elena King lauren l Daniel Richards 康志 大網 Noris Pasic Nick Cafarchio Dong Zhao Craig Zelley Brian Fey Litify Services+PLSG Albert Martí Vance Miller Robert Spielman Kevin Kneip Igor Corti Cloudreach Admin Jack Lish Krisztian Pozsa SF Admin Matthew Wolfe Rachide Ibrahim Kerry Desberg Matt Garnett Chris Benoit Corey Hayden Tyler Carey Ivan Todorov Reda Benhemmouche Margaret Fleischaker Adam Erskine Alek Gokiert Daniel Quisdorf Shane Steele Bruce Morgan Pamela DuPont Andy Jimenez Kelly Strauch Gabriel Csanalosi Doug Ayers Robert Peck Virginie Chevalier Kristen Roberts Frazer Lewis Peter Lai Kenny Clark Eric Schubert Sidhant Agarwal Gustavo Tavares Marçon Canpango Support Stacie Davis Ron Langtiw Kevin Hart Wyatt Spielman Harmen Korfage Richard Sweetnam Bob Morrison Jennifer Dunn A.J. Seo Julia Gachet Guilaume Bougel Quentin Dalmazir Kaamil Siddiqui Vegard Østhagen Fabrice Cathala Dan Barrett Lori Smith Jason Herforth Lauren Wild Martin Topiwala Seth Turman Spencer Foreman Dan Grossberg loic maxwell Daniel Clemente Dustin Strickler Allison Letts Fred Squires Pablo Martinez Ben Van Zee Brad Currier Inactive User Alessandro Iaconi Luke Thackray Tobias Brand Joe Mellott David Banda Marcel Becher Shaun Pendrigh Dev Ops Eric Vaanholt Rob Howe Salesforce Admin Tas Ranson Antoine PEYTAVIN DE GARAM Ellen Taussig Adam Kebeck Edgar Sampson Jonathan Mercier Anil Madithati Jaimin Patel Ben Brenner Daniel White Murad Al-Yasin Ragnar Thurén BioSpine Institute Nicholas Labrada Pavan Kumar Tina Hill Eric Schubert Mike S Claire Jones Bhavana Singh Ofri Heffetz B. A. Baracus Vincent Lippens Mary Johnson Brett Gilbert 忠 下之段 David Speck Geoffrey Flynn Clever Admin Jacqueline Raymond Edgar Sampson Matthew Souther M M Jenna Berkowitz Allanah San Miguel Christopher Cook Takashi Ueno Shilpa ADMIN Joe Nagy Peter Bender Marjorie Marcus Travis Arnold FERNANDO DOMINGUES David Brenner Chris Evans Irene S Kim Galant Delinda Tinkey System Administrator Christian Eichhorn Tom Blamire Justin Burgard Trefor Williams Wenda McMahan Alexander Placidi Jennifer Wisner Emilio Perez 和男 大越 Jackie Travieso Susanne Mcgregor Eric Su Dave Masom Maxim Rydlev Rob Burkett Denver Greene Lee Yakiwchuk Admin User Jason Cookman Mike Reynolds Ellie Matthewman Vincent Drader Peter Kim Serguei Zoubak Carla Llewellyn Nicole Guerra Alexander Shumski Azfer Pervaiz Phillip Front Mark Bruso Patrick Maxwell Andrew Halim Sjef Wijnen Terrence Blindauer System Architect Mark Guilday Jenny Mosunova Katie Timmerman Michelle Martin Michal Skara Richard Kao Jeff Hagopian Hanno Verweij Sean Wohlfert Rafal Bolimowski Johan Yu Ryan Morgan James Sweeney Cassie Supilowski Chad Kelly Brian Collins Nicholas Brownell Joshua Lenton Brent Downey Julia Smetanina Jon LaRosa Antonia Trasatti Robin Wijnen Sneha Bhatkande Sneha Bhatkande Kristin Hasna Daniel Kimball Jim Marous David Kemp Jeanne Leon Samtest Taylor Michael Cullen Holly Lee Erica Dean Kelly Allen Julian Miksch Jennifer Vigran Andrew Sample Michael Hupe Sara Herrera Justin Edelstein Holly Ryall Roger Mitchell Ted Todorov Ted Todorov Daniel Fard Ferdie Klok Rich Englhard Michiel Verwater Admin Admin Rosalind Holland William Young Luke McKenzie 講平 覚野

Is it Fixed?

AP0 AP3 AP4 AP5 AP6 AP7 AP8 AP9 AP10 AP11 AP12 AP13 AP14 AP15 AP16 AP17 AP18 AP19 AP20 AP21 AP22 AP28 CS1 CS2 CS3 CS4 CS5 CS6 CS7 CS8 CS9 CS10 CS109 CS108 CS107 CS106 CS105 CS102 CS101 CS100 CS115 CS110 CS117 CS114 CS113 CS112 CS111 CS11 CS116 CS12 CS129 CS128 CS125 CS124 CS123 CS137 CS138 CS13 CS133 CS132 CS14 CS148 CS142 CS15 CS152 CS151 CS16 CS17 CS18 CS19 CS20 CS21 CS22 CS23 CS24 CS25 CS26 CS27 CS28 CS29 CS30 CS31 CS32 CS33 CS34 CS35 CS36 CS37 CS40 CS41 CS42 CS43 CS44 CS45 CS47 CS50 CS51 CS52 CS53 CS54 CS57 CS58 CS59 CS60 CS61 CS62 CS63 CS64 CS65 CS66 CS67 CS68 CS69 CS70 CS71 CS72 CS73 CS74 CS75 CS76 CS77 CS78 CS79 CS80 CS81 CS82 CS83 CS84 CS85 CS86 CS87 CS88 CS89 CS90 CS91 CS92 CS93 CS94 CS95 CS96 CS97 CS98 CS99 EU7 EU8 EU10 EU12 EU13 EU14 EU15 EU16 EU17 EU18 EU19 EU25 EU26 EU27 EU28 EU29 EU30 EU31 EU32 NA104 NA107 NA109 NA100 NA101 NA103 NA102 NA105 NA119 NA116 NA110 NA118 NA112 NA111 NA115 NA114 NA113 NA117 NA121 NA124 NA122 NA120 NA126 NA129 NA130 NA134 NA136 NA135 NA132 NA131 NA146 NA142 NA141 NA154 NA155 NA171 NA174 NA196 NA21 NA32 NA37 NA39 NA44 NA45 NA46 NA47 NA49 NA52 NA53 NA54 NA57 NA58 NA59 NA60 NA61 NA62 NA64 NA65 NA66 NA67 NA68 NA69 NA70 NA71 NA72 NA73 NA74 NA75 NA76 NA77 NA79 NA80 NA81 NA82 NA83 NA84 NA85 NA86 NA87 NA88 NA89 NA90 NA91 NA92 NA93 NA94 NA95 NA96 NA97 NA98 NA99 UM1 UM2 UM3 UM4 UM5

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.