RichText 4000 characters - Workaround?

(0) Share

Report

Posted on by mrstian89

315

Hi!
We have an app where the 4000 character limit is kind of annoying. Is there any way to work around this?

If we create 3 columns: Rich1, Rich2, Rich3.

Is there some way to use the RichText input seemlessly and make sure that the first 4000 characters are stored in one column, and the next in the second? Then shown like they are one?

Any way to code this, or any other suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

BCLS776 8,994 Moderator on at

Like (1)

Report

The Left() function will allow you to put out the first 4000 characters from a string, e.g. Left(myString, 4000)

That said, it is cumbersome to work with multiple columns for a string in this way. It sounds like you're using SharePoint as a data source - Dataverse offers text columns with higher capacity if you're able to make the switch.

Hope that helps,

Bryan

Was this reply helpful? Yes No
mrstian89 315 on at

Like (0)

Report

Thanks!
It is Dataverse, the RichText only allows for maximum 4000 characters unfortunately.
What if the HtmlText is at 9000 characterrs, how do I get character 4001 - 8000 to be added to the second column, and 8001 to 9000 to the third column?

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report

Use Len(myString) to check the length of it and help with conditional logic, then use Mid(myString, 4000, 4000) to get the second portion of 4000 characters and Mid(myString, 8000, 1000) to get the last 1000 characters in a 9000 character string.

Bryan

Was this reply helpful? Yes No