Unanswered

Concatenate three columns of table to put result in a Rich text field

(0) Share

Report

Posted on by CU25101055-0

I have got a Dataverse table three of which fields I would like to join together and put the result in a Rich Text Editor through its default property. I tried to make a collection but the results are table which are not taken by a Rich text editor. The three columns of the table being like below

Order

Title

Description

This is title 1

This is Decription1

This is title 2

This is Decription2

This is title 3

his is Decription3

............. there are other fields and records in this table also

On the Default property of the Rich text editor I want to concatenate the columns so that it shows in rich text editor in the power apps application like below after sorting on Order (which is a whole number but user has to provide a value for each row in the selection.. All other fields are Text)

1. This is title 1 : This is Decription1

2. This is title 2 : This is Decription2

3. This is title 3 : This is Decription3

,.. and so on.

Tried SortColumns, AddColumns, Concatenate and Concat functions but somehow getting error,

Any solution is highly welcome,

Categories:

General Questions

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 151,686 Most Valuable Professional on at

Like (0)

Report
Concatenate three columns of table to put result in a Rich text field

Hi @CU25101055-0

Try making the Default (I have used ThisItem assuming they are in the same record - remove if not the case)
ThisItem.Title1 & "<br>" & ThisItem.Title2 & "<br>" & ThisItem.Title3

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 151,686 Most Valuable Professional on at

Like (0)

Report

Concatenate three columns of table to put result in a Rich text field

@CU25101055-0

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
timl 35,805 Super User 2025 Season 2 on at

Like (0)

Report
Concatenate three columns of table to put result in a Rich text field

Hi CU25101055-0

It sounds like you want to concatenate both the rows and columns of your collection. If that's the case, you should be able to do this by setting the Default property of your Rich Text editor like so:

Concat( Sort( YourCollection, Order, Ascending ), Text(Order) & ". " & Title & " : " & Description & "<br>" )

Was this reply helpful? Yes No