69
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 "/".
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)
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:
Share
Report
All responses (
Answers (
AddColumns(
DataSource,
FormattedDate,
Text(Date, "m.d.yyyy"),
NoHTML,
PlainText(
Substitute(
HTML,
"<br />",
Char(10)
)
)
)
I hope that helps!
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")
)
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
