Unanswered

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

(0) Share

Report

Posted on by khanya

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?

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No
khanya 23 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

Hello @khanya ,

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

BR,

Marco

Was this reply helpful? Yes No
khanya 23 on at

Like (1)

Report

Hi Marco! There is only one email address per cell

Thanks! Khanya

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

Hello @khanya ,

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

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

Was this reply helpful? Yes No
khanya 23 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No
khanya 23 on at

Like (0)

Report

Hi Marco

I followed the instructions detailed here: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Power-Automate-Flow-Sending-emails-to-list-of-people-in-the/ba-p/1189517
I'm not sure why an array variable was initialized. Would you suggest I start a new flow from scratch?

Khanya

Was this reply helpful? Yes No
Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No
khanya 23 on at

Like (1)

Report

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

Was this reply helpful? Yes No