Skip to main content

Notifications

Power Automate - General Discussion
Suggested answer

Joining to a string array

(1) ShareShare
ReportReport
Posted on by 19
Hi
I'm building a flow to process employee PTO requests.  The PTO approvers are our consultants' project manager(s) which are located in a SP List; if a consultant has multiple PMs, the consultant is on multiple rows in the List with each PM on a separate row. Most consultants have only one project manager, but some (and possibly more in the future) have multiple project managers who all need to approve PTO.
 
The problem: I'm able to retrieve the PMs' email addresses from the SharePoint List, but I am unable to join them to the string array (variable "PM") with a semicolon separating the PM email addresses.  WHen I look at the output from the Compose action, the email addresses like this:

name1@company.comname2@company.com 
 
rather than
 
name1@company.com; name2@company.com
 
What am I doing wrong?  Thanks in advance!  I'm new to this (self-taught) and Google and YouTube have not been able to help this time.
 
Here is the flow I currently have:
 
 
 
 
 
Categories:
  • nstoney Profile Picture
    nstoney 19 on at
    Joining to a string array
    Tom - sorry to bother. I'm trying to select your two answers as the answers by selecting the "Does this answer your question?" box. But it's not "saving".  Any idea why?
  • trice602 Profile Picture
    trice602 11,845 on at
    Joining to a string array
    Nice!  Always glad to help!  Please mark one or more of my replies as a verified answer to help others find this too!  Respectfully, Tom
  • nstoney Profile Picture
    nstoney 19 on at
    Joining to a string array
    TOM!
     
    That's it! 
     
    I had entered exactly what you had typed in the function/expression area (not realizing I needed to select my dynamic content - duh!). But I followed your second set of instructions - and VOILA.  It's working!
     
    THANK YOU so very much. You don't know how much blood, sweat, and tears I've spent on this project getting this far.  Thank you so very much for your help! I'll be sure to mark your replies as the answer.  Have a great day!
  • trice602 Profile Picture
    trice602 11,845 on at
    Joining to a string array
    Hi,
     
    Here's how to enter the expression.  With your cursor in the Value field, click on the fx icon.
     
     
     
    Next, type in the expression concat().
     
     
     
    With your cursor inside the (), click on 'Dynamic content' tab
     
     
    Next, select the Dynamic content 'Mail'.  In my example I am using Get My Profile, but you will use Get requestor's PM profile (V2).  Clikc on Mail.
     
     
     
    Notice my dynamic content Mail is added to the expression, shown below.
     
     
    Next I concat the Mail with a semicolon, shown below.  Your expression should look similar below.  Then click Add button
     
     
     
     
    So your expression will look like this in the value field.
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     

     
  • nstoney Profile Picture
    nstoney 19 on at
    Joining to a string array
    Thanks for responding, Tom!
     
    So, again, I'm a newbie.
     
    I entered the expression just as you had it, and I got the following error (when looking at the compose outputs).  ??? I'm still lost!
     







    Here's what I entered

    ​​​​​​​
  • Suggested answer
    trice602 Profile Picture
    trice602 11,845 on at
    Joining to a string array
    Hi,
     
    Please try and make this an expression:
     
    concat('dynamic_Mail',';')
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     

     

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,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard