Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Line breack <br> showing


I'm new to Power Apps, I managed to do what I needed for now, however I have an issue I can't work out.

My data are in a share point list extacted from an Excel file. I want to display what's in the cell but I have the line breack <br> showing in the app.

How can I get rid of it ?


You are clicking on DataCardValue14. Click on the value above that as shown below:



Let me know if you are now able to set the default property as specified above by me. 


If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!


This worked !

Is there a way to substitute it with an actual line break instead of a blank space?

And how can I add a second symbol to the substitue formula ( I noticed I also have " &#58; " instead of " : ")

Glad it worked!

For your 1st question, you can use Char(13) instead of "". That should add a new line.

For your 2nd question, you can use a nested substitute function. Something like this:

Substitute(Substitute( String, "<br>", Char(13)), " &#58; " , " : ")

Let me know if this works.

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!


View solution in original post

This is perfect, thank you very much !👍

Glad I could help! 


Good luck with the rest of the app!


Feel free to reach out in case of any questions!



Hardit (Haman)


I'm really glad this works for you. If it were me, I would delete the DataCardValue14 textbox and insert a 'HTML Text' control instead. I would then set the HTML Text property to Parent.Default, rather than use the Substitute.

What you appear to be displaying is HTML, so the 'HTML Text' is the best control for this. At worst, if your input data contains other escaped characters, you'll need to Substitute every combination with the text equivilent.

eg &lt; for the < symbol, &gt; for the > symbol etc, etc.




And would it be possible to not display HTML ?

Cause have indeed more issues when I'm adding new entries to my sharepoint list.

I copy/past infos from pdf files but it's just a mess once in powerapps


Maybe it's a bad setting of my sharepoint list ?


In your screenshot, are you using the HTML Text Control as I suggested?

The HTML Text control will correctly render tags like DIV, rather than display the actual HTML markup.



Thanks but I finnaly found this HTML issue.

It was in the sharepoint list, I had to change the setting for all columns from "rich text" to "untreated text"


This way, all the HTML code disappared

Glad you found that setting @GGBB 

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,726)