Create String from Sharepoint List

[tlevine]

Hi Community - I think this may be a quick solution (hopefully) but I am struggling with my concat function to take a list of emails in a column from Sharepoint list. I am using this as a solution to send an email to users outside of my organization. 

What I want to do is take the "Email" column from the sample table below and concatenate all of the emails with a ";" in between each email.

Name	Email
Employee One	employee.one@gmail.com
Employee Two	employee.two@gmail.com
Employee Three	employee.three@gmail.com

So far; my flow is as follows:

1) Manually Trigger

2) Initialize Variable "Email String"

3) Get Items from Sharepoint List

4) Set Variable (this is where I am stuck on how to concatenate)

From there, I am able to apply this variable to my flow to complete the email.

Many thanks to the community in advance for the support.

I have tested the solution with a single email in a variable in order to send

[abm]

Hi @tlevine 

Follow the below steps

1. Initialise a variable outside the loop

2. Star the loop (Get items)

3. Add a compose inside the loop

4. Under the compose use the expression concat(). Pass the first parameter as variable and set second parameter as semi-colon.

5. Finally set variable value as output of the compose

Thanks

5. End loop

[Hardesh15]

@tlevine 

4) Set Variable (this is where I am stuck on how to concatenate) after this step use action- Append to string variable like this-

In value provide you email column from dynamic panel and add semicolon so that each email will be sep by semicolon.

Thanks

Hardesh

[abm · Accepted solution]

Hi @tlevine 

Here it is

[tlevine]

hi @Hardesh15  - thanks for the quick reply. are you saying that I don't need to use Set Variable or Concat functions for this solution? i have followed the steps with appending the string variable and including ";", but it is not clear if this is now a single string. 

[tlevine]

I believe this works now 🙂 thank you both @abm  and @Hardesh15  for your support here!

[Hardesh15]

@tlevine 

No set variable my apology. instead of that you have to initialize variable as shown by @abm in his screens.

Thanks

Hardeh

[abm]

Hi @tlevine 

Thanks for the reply. Just to clarify yes still append string will be a type of string. If you map the output in a compose you could see all the values are concatenated with semi-colon.

Thanks

[Amanthaper]

Hi,

Here's another method piggybacking off the previous suggestion using the concat function as:

concat(items('Apply_to_each_2')?['Name'],';')

Cheers,

Aman

------------------------------------------------------------------------------------------------------
If my post helps you with your problem or answers your question, please mark it Solved or Answered. This helps anyone with similar challenges. If you like my response, please give it a Thumbs Up.
------------------------------------------------------------------------------------------------------

[tlevine]

thanks @Amanthaper  - this is helpful for me to better understand concatenate functions in flow