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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How join values in "Ap...
Power Automate
Answered

How join values in "Apply to Each" to a value after Apply to Each ?

(0) ShareShare
ReportReport
Posted on by 1,724

I want to join all values in "Apply to Each" to a value after Apply to Each.

 

In my scenario:

In Apply to Each loop, create new values by Data Operations - Compose.

After the Apply to Each loop, create a value by join all values created in the loop.

This scenario can use to creating summary from some outputs from services.

 

1.png

 

 

 

 

Regards,

Yoshihiro Kawabata

 

 

Categories:
I have the same question (0)
  • v-micsh-msft Profile Picture
    on at

    Hi @yoshihirok,

     

    Could you please explain a bit regarding "Join all values" here?

    Have you checked the following article?

    Could the HTML Tables, or the CSVs table helps in your scenario?

    Build flows with HTML Tables, CSVs and other new features link OCR and image content detection

     

    Do you mean to add them all together?

     

     

    Regards,

    Michael

  • yoshihirok Profile Picture
    1,724 on at

    Hi @v-micsh-msft

     

    "Join all values" make from some values to a value.

    Yes, the blog "Build flows with HTML Tables, ..."

     

    So, I want to do same with Apply-to-each.

    Step 1. Get a array value.

    Step 2. Create new value in  Apply-to-each from each array items.

    Step 3. Create a new value from the values in Step 2 after Apply-to-each.

     

    Example scenario:

    Step 1. Get a array value by Excel - Get Rows.

    Step 2. Create new value in Apply-to-each from each Excel Row item

      by Data Operations - Compose, concat first column and second column.

      Example: "Col1 Col2 / Row 1"

    Step 3. Create a new value from the values in Step 2 after Apply-to-each with comma seperate

      Example: "Col1 Col2 / Row 1, Col1 Col2 / Row 2, Col1, Col2 / Row 3"

     

    Regards,

    Yoshihiro Kawabata

  • v-micsh-msft Profile Picture
    on at

    Hi @yoshihirok,

     

    Thanks for the update.

     

    I will try some tests, and share the result later.

     

    Appreciate your patience.

     

    Regards,

    Michael

  • Community Power Platform Member Profile Picture
    on at

    @v-micsh-msft

     

    Has this been solved yet?

     

    Is it possible to get the summary of an apply to each loop?

     

    I processed an array in the loop, then I want to send all the resulting values in one email. Not each result in 1 email.

  • fooshen Profile Picture
    11 on at

    I have a similar use case.

    Get a list of items from a REST API call, apply to each to perform some string manipulation and then I want to construct a string representing all the processed strings.

     

    1. Compose: "@createArray('a','b','c')

    2. Apply to Each: Output from 1

    2.1  Compose: "concat(item(), '-1')"

    3. Join: Output from 2.1, ";".

     

    Step 3 throws an error saying the output from 2.1 is null.

    Any suggestions?

  • fooshen Profile Picture
    11 on at
  • Verified answer
    yoshihirok Profile Picture
    1,724 on at

    Hi @fooshen

     

    Yes. Compose:"@join(outputs('Compose2'), ',')" can build a result from results in Apply to Each.

     

    Regards,

    Yoshihiro Kawabata

  • Community Power Platform Member Profile Picture
    on at

    Hi @yoshihirok

     

    I am using  the technique you describe but it is outputting the formula string and not the underlying variable e.g. ["@Join(outputs('First'),'')","@Join(outputs('First'),'')","@Join(outputs('First'),'')"]

     

    My formula is @Join(outputs('First'),'')

     

    Any ideas what I am doing wrong? Your help would be greatly appreciated.

  • Lexnnn Profile Picture
    94 on at

    I needed to send email to users only once and not repeat their email address.

    This is what I have done:

    if(empty(item()?['Address']),'blank',item()?['Address'])

    flow contains.JPGflow contains 2.JPG

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 291 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 238 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 109 Super User 2026 Season 1

Last 30 days Overall leaderboard