cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
khanya
New Member

Hi! Scheduled flow runs successfully but does not send email as required

I set up a scheduled flow to send emails to a list of people in the excel worksheet. It has been running successfully but it still does not send any emails. Could someone please help me?

1 ACCEPTED SOLUTION

Accepted Solutions

ok @khanya ,

got it. In the link you provided the objective is to put all the email in the "To" field.

But, if you want to send the email to the address available in the "To Email" table column and put the "Email CC" in the "CC" email field, my solution should fit your needs.

 

Please let me know if the issue is fixed.

 

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

 

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

 

My blog site about Power Automate: https://powerautomatejoy.com/

 

BR,

Marco

View solution in original post

10 REPLIES 10
MarconettiMarco
Super User
Super User

Hello @khanya ,

would you please share in details:

- the flow in Edit Mode;

- the Excel table columns?

 

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

 

My blog site about Power Automate: https://powerautomatejoy.com/

 

BR,

Marco

Thank you so much for offering to help! I've attached what you asked for, please let me know if you need more info.

 

I will definitely be looking at your website, thanks for sharing!Capture29081.PNGCapture29082.PNGCapture29083.PNG

Hello @khanya ,

in each cell is there only one email address or many?

 

BR,

Marco

Hi Marco! There is only one email address per cell

 

Thanks! Khanya

Hello @khanya ,

you should be able to put the "To Email" and "CC Email" in the "Send an email (V2)" action as below:

MarconettiMarco_1-1661774957117.png

 

Power Automate will generate only one Apply to each loop.

Why are you trying to manage an Array variable?

 

Please let me know if the issue is fixed.

 

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

 

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

 

My blog site about Power Automate: https://powerautomatejoy.com/

 

BR,

Marco

This is what V2 looks like now, should I change it to what you suggested?Capture29085.PNG

 

I had initially set it to "string" but I was getting an error message and someone had suggested I change it to "array".

 

Thank you! 

Khanya

Hello @khanya ,

I do think so, but I'd to know why have you initialized an array variable, in order to understand if my proposal fits your needs.

 

BR,

Marco

khanya
New Member

Hi Marco

 

I followed the instructions detailed here: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Power-Automate-Flow-Sending-emails-to-...

I'm not sure why an array variable was initialized. Would you suggest I start a new flow from scratch?

 

Khanya

ok @khanya ,

got it. In the link you provided the objective is to put all the email in the "To" field.

But, if you want to send the email to the address available in the "To Email" table column and put the "Email CC" in the "CC" email field, my solution should fit your needs.

 

Please let me know if the issue is fixed.

 

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

 

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

 

My blog site about Power Automate: https://powerautomatejoy.com/

 

BR,

Marco

khanya
New Member

Thank you so so much, Marco! It works!!

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 (3,802)