I have a Sharepoint List that is being Added To/Edited by a Form in Power Apps. I have the two types of Multiple Line columns (Plain Text and Enhanced) in the Sharepoint List for testing purposes.
If I pull up the record in the Form, the Plain Multiple Line field displays in the field the way it was entered initially (the 2nd line of text appears below the first line):
When I pull up the Enhanced Multiline field, it shows it using the 2nd line on a new line, but has added html div information to it, but the div surrounds the entire text:
The problem with this is that when I'm trying to send the information in an email as HTML text, it shows up like this (these are both HTML Text controls where the controlname.HtmlText is being populated with the field contents):
So you can see that the line break that was originally entered into the field while editing is just being ignored here. The line break in the enhanced text DOES get included if I manually move the /div to the end of the first line on the enhanced text, but I don't want people to start manually including HTML in their text body because not everyone understands that. I'd rather just keep it Plain text:
If I use a regular Text Label to display the contents of the plain text multiline field, it shows properly:
The question I have is this: Is there a way that I can use a Plain Text Multiple Line SP column type but have my HTML output to an email respect the line breaks as they're entered & displayed in the form's Edit Multiple field? I've tried to have the HTMLText value to be "<b>" & Label1.Text & "</b>" but that again ignores the line break and puts it all in one bolded line:
I don't need enhanced text as 1) I hate seeing the html in the field contents and 2) I'm deciding which columns' data gets formatted and how it's formatted in the email. Just need plain text with line breaks respected.
