Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

JOIN an array doesn't loop to the last element with the "join with"

(0) ShareShare
ReportReport
Posted on by 1

Hi all,

I define an array variable with the value like

 

 

["AMM2SZH","AMM2SZH"]

 

 

 I want to join the two elements together by using JOIN with some suffix characters, see pic

Mayer_0-1666334478701.png

 

What I expect is the output should be "AMM2SZH;AMM2SZH;", but it looks like the JOIN doesn't loop to the last element, so there's no ";" at the end of the string.

How do fulfill my requirement by using JOIN? Or other function?

Categories:
  • Sundeep_Malik Profile Picture
    Sundeep_Malik 6,480 on at
    Re: JOIN an array doesn't loop to the last element with the "join with"

    Hey @Mayer 

     

    You can use append to string variable for this.

    Something like this:

     

    Initialize two variables. One array to keep your data. Other one string.

    Sundeep_Malik_1-1666336156690.png

     

    After this use apply to each loop and pass the above array variable in that. And then use append to string variable in that with a semi colon at the end.

     

    Sundeep_Malik_2-1666336207977.png

     

    At the end just used a compose to pass the string variable to show you the output:

     

    Sundeep_Malik_3-1666336234920.png

     

     

    Final Output:

     

    Sundeep_Malik_0-1666336092160.png

     

     

    If this gives you the solution you were looking for, you can accept it as a solution.

     

    And if you liked the explanation, you can give a kudo/thumbs up the post. It really helps. Thanks.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard