Answered

I can't send email to multiple users from PAD

(0) Share

Report

Posted on by SimonSeez

Hello,

I'm new to Power Automate so forgive me if I don't use the correct terms. I'm trying to create a send email workflow with data connected from SQL table. I have created the flow see below

This is the result of my second SQL Qeuery

But my currentitem variable returns just one item. the last email

Hence my email gets sent this way only dinesh.kumar receives the mail

Kindly help.

Best Regards,

Simon

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Do you want your send email inside the For Each Loop? So each %CurrentItem% gets an e-mail. If so, it needs to be below "For Each" and above "End" What I am envisioning is, the For Each runs with nothing in it, so it does:

For Each 'CurrentItem=1' #Do nothing
For Each 'CurrentItem=2' #Do nothing
For Each 'CurrentItem=3' #Do nothing
End For Each

Now do something with CurrentItem...#but CurrentItem now =3, so you only get 3.

It's possible I'm reading your question wrong, but that is what I got from up above.

I would have to see your SendEmail parameters to be able to help further if this is not the issue.

Best of luck!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SimonSeez
Not sure If I got your question correctly, but CurrentItem is used to loop into a list, retrieving one item at a time. That's why it's returning the last value of your list.
If you want to send one email to each address of your list, you have to put the 'Send email' action inside your 'For each' loop, with To: %CurrentItem%
If you want to send one email to all in your list, use 'Replace text' in your list, replace \n with ; or , (depending on your regional config). 'Use regular expressions for find and replace' must be activated. It will give you %Replaced% as variable produced. Use it as 'To:' in your 'Send email' action.

Was this reply helpful? Yes No
SimonSeez 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Anonymous

Thank you very much for your feedback. Adding the 'Send email' action inside the 'For each' loop resolved the issue.

Appreciate.

Was this reply helpful? Yes No
SimonSeez 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @MichaelAnnis

You described the issue correctly as well. Placing the "send email" between For Each and End solved the issue. Thank you very much.

Best Regards,
Simon

Was this reply helpful? Yes No