web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Concatenate three colu...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 16
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
1  This is title 1 This is Decription1
2
  This is title 2
This is Decription2
3
  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:
  • WarrenBelz Profile Picture
    156,940 Most Valuable Professional on at
    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
  • WarrenBelz Profile Picture
    156,940 Most Valuable Professional on at
    @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
  • timl Profile Picture
    37,422 Super User 2026 Season 2 on at
    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>"
    )
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard