cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CuriousX
Helper II
Helper II

Substring of a Dynamic Content

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?

4 REPLIES 4
ArchitectMadhan
Super User
Super User

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...

 

- Architect Madhan

Please click the "Accept as Solution" button and give thumbs up, if it is helpful to you.

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
Super User
Super User

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...

 

- Architect Madhan

Please click the "Accept as Solution" button and give thumbs up, if it is helpful to you.

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?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,152)