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 Automate / Concatenate text from ...
Power Automate
Answered

Concatenate text from single row to multiple row item power automate

(0) ShareShare
ReportReport
Posted on by 18

Hi there,

 

I am trying to create a flow to update the agenda for our meeting every week. The topics will be entered and one day before the meeting, all the topic will be listed in the agenda and sent out to the manager. The scenario works like this.

xnguyen7_1-1687968129773.png

 

How can I combine all of those topics entered in the image into 1 agenda like:

Our agenda for meeting:

+ ddm

+counter

+ qmate okay

So far is what I tried:

xnguyen7_2-1687968301800.png

After apply to each, I am now get the single value of each row. But I have no idea how I can combine all of the rows into 1 row with multiple lines:

ddm

counter

q-mate okay

 

Does anybody have experience with it? Your help is highly appreciated.

Categories:
I have the same question (0)
  • Verified answer
    Matthy79 Profile Picture
    4,188 Super User 2024 Season 1 on at

    Hello @xnguyen7 

     

    You already have an array of all the items you need so you don't need an apply to each. You just have to transform it. You could use a "select" action. "From" is your value from "get items" and for "Map" you switch to text mode and use a formula like "concat('+ ', YOURCOLUMNFROMGETITEM)".

     

    Your flow can look like this. (you won't need join if you use it as a formula within the email action)

     

    Matthy79_0-1687983631428.png

     

  • xnguyen7 Profile Picture
    18 on at

    Hi @Matthy79.

    Thank you so much your your guideline. I can extract the topics into multiple lines. However, when I try to send out the email. The array converted back to one line. You can see details here.

    xnguyen7_0-1688024544650.png

    I try to combine the output of the select step to break the line by using join function but it still didn't work. Can you please show me what I did wrong and it would be great if you have solution for it. Thank you again. I really appreciate it. 

    xnguyen7_2-1688024788657.png

     

     

  • Matthy79 Profile Picture
    4,188 Super User 2024 Season 1 on at

    OK, so this is just a visibility problem when viewing the mail?

     

    I guess since it is an html mail you will have to do some line breaks. You can do this during the join action. Just use '<br>' to join the array together.

  • xnguyen7 Profile Picture
    18 on at

    OMG it works perfectly. I can't thank you enough.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard