Substring of a Dynamic Content

[CuriousX]

Hello everybody, 

Weeks ago, I was trying to get the e-mail address content from a text and this post really helped me to figure that out: 

https://powerusers.microsoft.com/t5/General-Power-Automate/Substring-of-a-Dynamic-Content/m-p/170012...

thanks to @ScottShearer  and @MarconettiMarco .

However, now I am trying to get multiple e-mail addresses from text inputs. Such as Name1 (email1), Name2 (email2) and Name3 (email3). When I try to get them in the same way, Power Automate automatically puts "the compose" into "apply to each". In this situation, I cannot get the outputs to put them into the "send an e mail (V2)" section. 

Any ideas to overcome this problem?

[ArchitectMadhan]

Hi @CuriousX ,

Instead of using split function and array variable you can directly use the Name1 (email1), Name2 (email2) and Name3 (email3) in To address of the "Send an email (V2)". Refer this post https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Parsing-Email-Text-in-Power-Automa...

[CuriousX]

Hello Madhan,

I am looking for a solution that works for the data that comes from the sharepoint. I will not be able to write e-mail adresses manually. The flow must accept multiple name+e-mails and extract e-mails for the Send an E-mail (V2) step. 

[ArchitectMadhan]

Hi @CuriousX ,

Then you have to read all the email addresses from SharePoint list by using "GetItems", create a string variable (varEmailAddresses) and use "apply to each" to form a single string like email1;email2;email3. Now in your "Send an Email (V2)" use the varEmailAddresses. So that you can send one email with all those people in To address, instead of sending email for everyone individually.

Please refer: https://powerusers.microsoft.com/t5/Building-Flows/Send-multiple-emails-from-SharePoint-list/td-p/93...

[CuriousX]

Do I understand correctly? According to a scenario the user enters two e-mail adresses, in another scenario the user enters five e-mail adresses. There will not be a regular e-mail adress list. Can I use your solution in this case?