Line breack <br> showing

[GGBB]

Hi,

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 ?

[PowerAddict]

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!

Hardit(Haman)

[GGBB]

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 " : ")

[PowerAddict · Accepted solution]

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!

Hardit(Haman)

[GGBB]

This is perfect, thank you very much !👍

[PowerAddict]

Glad I could help! 

Good luck with the rest of the app!

Feel free to reach out in case of any questions!

Thanks,

Hardit (Haman)

[timl]

Hi @GGBB 

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.

[GGBB]

@timl 

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 ?

[timl]

 @GGBB 

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.

[GGBB]

@timl 

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

[timl]

Glad you found that setting @GGBB