Solved: Re: div class showing in datacardvalue

Peakoverload · ‎08-10-2020

I'm a complete newbie whose stumbled into PowerApps simply because I wanted to create a custom form for a Sharepoint list.

I have a column in my Sharepoint List called Narrators and it's type is set to Multiple lines of text.

When I created the custom form app from this, the datacardvalue for this column displays in the app as <div class="ExternalClass.....

I understand that this is the division for the multiple lines of text but how do I get this to display as a multi line text box and not as code? I've set it's mode to Multiline but the code is still showing

v-siky-msft · ‎08-11-2020

Hi @Peakoverload ,

That is because the text stored in Multiple lines of text is HTML Text, you need to replace the Text Input in data card by RichTextEditor to display or edit HTML text. Please try this.

1. unlock the data card

2. add a RichTextEditor in it, set Default property: Parent.Default

3. delete the original text input control, modify Update property of data card: RichTextEditor1.HtmlText

4. modify the Y property of ErrorMessage: RichTextEditor1.Y + RichTextEditor1.Height

Hope this helps.

Sik

View solution in original post

Peakoverload · ‎08-10-2020

Hmm, just found that this only happens for existing records where this column is blank. For new records it display correctly.

v-siky-msft · ‎08-11-2020

Hi @Peakoverload ,

That is because the text stored in Multiple lines of text is HTML Text, you need to replace the Text Input in data card by RichTextEditor to display or edit HTML text. Please try this.

1. unlock the data card

2. add a RichTextEditor in it, set Default property: Parent.Default

3. delete the original text input control, modify Update property of data card: RichTextEditor1.HtmlText

4. modify the Y property of ErrorMessage: RichTextEditor1.Y + RichTextEditor1.Height

Hope this helps.

Sik

Peakoverload · ‎08-12-2020

Yay! Perfect, thank you. Really appreciate that as I was pretty stumped there.

Anonymous · ‎03-09-2021

I've stumped at this issue for a while either. My solution to set the default as "PlainText(Parent.Default)". This formula helps to remove html tags and display only text.

infamouslysin · ‎03-16-2021

This is such a beautifully simple solution! Exactly what I was looking for, especially since I do not want rich text and my SharePoint list data ultimately is used in excel worksheets. You are fantastic!

I successfully used PlainText(Parent.Default) on all of my multi-line boxes and eliminated the HTML coding.

Anonymous · ‎03-16-2021

😎

Anonymous · ‎05-20-2021

Its really helpful for me, without any changes in column level we able to show data.

thank you for posting this answer.

grazee73 · ‎02-25-2022

This is very helpful. Ty.

Anonymous · ‎10-27-2022

Hello I had the same issue. Because it took hours to find the solution, I want to share my experience with you. I connected Power App with a SharePoint list. The aim was to create a form in Power Apps that fill the lines in the SharePoint List. I've got the div class in the value I entered into the Power App field. The solution was quite simple. I had to change the column settings. While I created the column, unfortunately I activated "Use enhanced rich text". After I cleared the option, I just gained the text and no HTML code.