Unanswered

Joining to a string array

(1) Share

Report

Posted on by nstoney

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:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

trice602 15,332 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
nstoney 19 on at

Like (1)

Report

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

Was this reply helpful? Yes No
trice602 15,332 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
nstoney 19 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
trice602 15,332 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
nstoney 19 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
trice602 15,332 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post joining to a string array in this category general discussion from 10/23/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 6 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,332 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No