Answered

How to display rich text content in grid in model-driven app

(0) Share

Report

Posted on by tschopp

311

In our model-driven app, we have a custom table with a multi-line text field in it. On the form, we're using the Rich Text Editor control, which inserts HTML tags into the content. We are looking for a way to display the contents of that field in a subgrid with the HTML tags stripped out.

One idea I had was to add a second multi-line text field to the table that gets populated automatically by a workflow that strips the HTML tags. That field could be displayed on the subgrid instead of the original. The problem with this is the size of the duplicated data. This table typically has millions of records and the field contents can be up to 1 million characters. Nearly doubling that content size will cause an added expense to the database costs for our clients.

Anyone have any other ideas?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (1)

cchannon 4,702 Moderator on at

Like (1)

Report
Copy link

Link copied!

You could create a PCF control that just sits on the same multiline text control, then at runtime displays only the HTML content text and none of the formatting. That way it looks like a second field that stores the text without formatting, but really it is the same field just displayed differently. This would escape the storage concern, but you would need to code it.

Was this reply helpful? Yes No
Verified answer

Diana Birkelbach 3,072 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @tschopp ,

One way would be to use the standard subgrid control and write some javascript on the form: when a line of the subgrid is selected, you could show that data in another area on the form (maybe inside a dummy text area on the form, or maybe inside an own HTMLWebResource). It's not exactly the same, but it has similar purpose.

As @cchannon says, the PCF is a good idea too. But it takes pretty much effort to implement all the details.

I think Danish Naglekar has a PCF on pcf.gallery doing pretty much the same: https://pcf.gallery/hovercard-details-list/.

Hope it helps!

Was this reply helpful? Yes No
meelamri 468 on at

Like (1)

Report
Copy link

Link copied!

Hi,
You can also implement a plugin in PostOperation for the retrieveMultiple event. In your plugin, you will need to remove the html tags...
I already made a POC using the same principle, but I admit that it can cause a latency when loading the grid.

Was this reply helpful? Yes No
tschopp 311 on at

Like (0)

Report
Copy link

Link copied!

I tried using the Hover Card PCF control, but it doesn't render the HTML out of the box. I would have to customize the control. Instead, I implemented the OnRecordSelected idea and it works great! Using a temp multiline text field that I added on the parent record and to the form, I display the value of the selected record in it.

Was this reply helpful? Yes No