cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JosueCR
Frequent Visitor

how to use data from an array to send an email? | como usar los datos de un array para enviar un correo?

Saludos tengo un problemita que no logro resolver.

Obtengo los datos de correo electrónico de una lista SharePoint para luego poder enviarles un correo a todos.

Pero como puedo pasar esos elementos del array a una solo string.

 

PD.. la cantidad de correos puede ser variada, correos puede ser N cantidad, desde 1 solo hasta 20 o 30 usuarios .

 

asi.

 

 

 

[
  {
    "correo": "jgonzalb@ccss.sa.cr"
  },
  {
    "correo": "psdelao@ccss.sa.cr"
  }
]

 

 

 

a : "jgonzalb@ccss.sacr;psdelao@ccss.sa.cr"

 

 

adjunto capturas.

JosueCR_0-1644861644298.png

 

JosueCR_1-1644861658545.png

 

RESULTADO.

 

JosueCR_2-1644861696088.png

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Super User
Super User

Hi @JosueCR 

 

You can use the value from get items in a select and enable text mode by clicking on the bottom right hand corner of the select before inserting the email field.  This gives you an array of emails.  Then you can use Join on a ; to create a string of emails.

 

DamoBird365_0-1644867841260.png

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

View solution in original post

2 REPLIES 2
DamoBird365
Super User
Super User

Hi @JosueCR 

 

You can use the value from get items in a select and enable text mode by clicking on the bottom right hand corner of the select before inserting the email field.  This gives you an array of emails.  Then you can use Join on a ; to create a string of emails.

 

DamoBird365_0-1644867841260.png

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

Me tomo algo de tiempo comprender lo que dices, pero lo logre.

 

Gracias. 😀

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,714)