Modern controls Table HTML column / Date column

(1) Share

Report

Posted on by IonutHzd

Hello everyone,

I am trying out the new Table control using SharePoint as a database and the rich text column looks like this:

And I can't find a setting to convert the HTML automatically. Is that even possible currently?

Also on the formatting topic, I would like the dates to show up with "." instead of "/".

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

rzuber 552 Moderator on at

Like (1)

Report
Copy link

Link copied!
In both cases, you are going to have to change or add columns with the format you would like to see.

Check out the AddColumns function to see how you can add columns to your table.

AddColumns, DropColumns, RenameColumns, and ShowColumns functions - Power Platform | Microsoft Learn

For example:
AddColumns( DataSource, FormattedDate, Text(Date, "m.d.yyyy") )

Was this reply helpful? Yes No
IonutHzd 87 on at

Like (1)

Report
Copy link

Link copied!

Thank you! @rzuber

That solved the issue with the Date. Could you elaborate on how to change the HTML column to formatted text?

Was this reply helpful? Yes No
Verified answer

rzuber 552 Moderator on at

Like (2)

Report
Copy link

Link copied!
I don't think you will be able to convert it to formatted text.. but you can remove the HTML code from it by using the PlainText() function...
EncodeHTML, EncodeUrl, and PlainText functions - Power Platform | Microsoft Learn

Note you might want to use the Substitute() function to convert some of the HTML tags to line breaks..
Replace and Substitute functions - Power Platform | Microsoft Learn

For Example:
AddColumns( DataSource, FormattedDate, Text(Date, "m.d.yyyy"), NoHTML, PlainText( Substitute( HTML, "<br />", Char(10) ) ) )

I hope that helps!

Was this reply helpful? Yes No
IonutHzd 87 on at

Like (1)

Report
Copy link

Link copied!

@rzuber The PlainText will work just fine.
Thank you!

Was this reply helpful? Yes No
rzuber 552 Moderator on at

Like (1)

Report
Copy link

Link copied!

Might I suggest another option?

I have recently been playing with the HTMLText control, and using a gallery over the top of that for selecting records.. In the gallery, I place a slider that covers the entire record. I use the column widths of the table to determine where the user clicked on the slider to determine which field they clicked on. If you need to show the HTML as it is formatted, the only way you're going to do that is with the HTMLText control. Check out the calendar component I made in this component library if you want an example of how I do this.
Calendar Component With Automatic Holidays, Workda... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
IonutHzd 87 on at

Like (1)

Report
Copy link

Link copied!

@rzuber Currently I am trying to familiarize myself with the new modern controls.
If it turns out the HTML formatting is 100% required, I will reconsider using the new controls.

Thank you for the suggestion!

Was this reply helpful? Yes No