Answered

How to count remaining characters for a Rich Text box

Like (0) Share

Report

Posted on 29 Nov 2021 20:02:48 by Community Power Pla...

I have a Powerapps SharePoint List Form. On the form I have a Rich Text field that works perfectly and brings in the Rich Text into SP which is what the user is requesting. However, they also want to have a character count which I have and which works if the I was only using a plain text field. The character count field (characters remaining) doesn't work on rich text or a plain text whose default is the Rich Text because it counts all the HTML code in the background. Does anyone have a workaround for this?

All responses (2)

Answers (2)

Verified answer

CNT 10,919 Super User 2024 Season 1 on 29 Nov 2021 at 20:58:22

Like (1)

Report

Re: How to count remaining characters for a Rich Text box

@Anonymous Try this,

Len(PlainText(yourHtmlText))
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 29 Nov 2021 at 20:56:00

Like (1)

Report

Re: How to count remaining characters for a Rich Text box

@Anonymous

If you're just trying to count characters and ignore the html, then change your formula to:

Len(PlainText(yourInput.Text))

That will remove all the html and count them as you want.

I hope this is helpful for you.