RichText 4000 characters - Workaround?

(0) Share

Report

Posted on by mrstian89

319

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 (5)

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 319 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Suggested answer

CU08052054-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi!

I just found a work around that worked for me -

I created a column and when selecting the data type I chose "Plain text" - This sets the Data Type as "Multiples Lines of Text" and the format as text. I named the column and saved it.

After it was created, I then went and changed the format to rich text - This lets me set the character limit to well above 4000 and it renders perfectly using the rich text editor control in Canvas Apps. I hope this helps!!

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,846 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI @mrstian89

Its the Microsoft Restriction to have 4000 Characters, are you going to use HTML content ? if yes then we need to have 3 different fields and merge it else create a TextArea.

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No