Unanswered

My flow template successfully ran, but the action item (send an email) was not received

(0) Share

Report

Posted on by Community Power Pla...

I used Microsoft Flow's template "Send a Happy Birthday email to employees on their birthday" and whenever I would test the run, it would say "Flow Failed". I received help regarding this issue yesterday in Community Forums and now the flow says "Successful". However, the flow is supposed to send an email and it does not. It's been 24 hours. Why isn't the email being sent? Or if it is being sent, why am I not receiving it?

Here is a picture of my flow:

And here my condition in advanced mode:

@equals(equals(items('Apply_to_each')?['Birthday_x0020_Date'], formatDateTime(utcNow(), 'MM-dd')), true)

...and basic mode:

equals(items('Apply_to_each')?['Birthday_x0020_Date'], formatDateTime(utcNow(), 'MM-dd')) is equal to true

Here is a picture of my list in SharePoint:

Categories:

Using flows

I have the same question (0)

All responses (27)

Answers (1)

AlanPs1 2,471 on at

Like (0)

Report

Hi Monica.
What happens when you run it? Not test run but a real production run. If you go to your dashboard were all your Flows are there’s a play button. Press that and tell us what it does please.

Thanks, Alan.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @AlanPs1

Is this the button you're referring to (screenshot below)? I just tried a few minutes ago and have yet to receive an email. Additionally, I had a birthday set in my list to today so it should have ran on occurence this morning and sent out an email.

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

Yeah, that will do. Does it run successfully I.e green tick?

If so, click in to the successful or failed run to get the details of that run. Screen shot at least the output of the email action so we can see if it is or isn’t sending it please? Post back please.

Thanks, Alan.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@AlanPs1

Yes, there was a green tick! It looks like there is a problem with sending the email, see screenshot below. It says...

"ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email' skipped: the branching condition for this action is not satisfied."

Here is what I have in the email:

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Anonymous ,

In fact, the configuration of Send an email action is correct.

The reason for not receiving the expected email is that the result of Condition is false, so Send an email action will not be executed.

I noticed that the value of Birthday Date is 02-19, and the value of formatDateTime(utcNow(), 'MM-dd')) should be 02-21, so it is not equal.

Send an email action is only executed when the two values are equal.

You could configure two Compose actions above Condition to see if the values of items('Apply_to_each')?['Birthday_x0020_Date'] and formatDateTime(utcNow(), 'MM-dd') are equal, only they are equal, the result of Condition Will be true.

Image reference:

Alternatively, you can filter the items directly in Get items-Filter query. You could configure your Flow like this:

Please take a try again.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-bacao-msft
I have several test birthdays featured in that list and they consisted of dates for the entire week. So it shouldn't have not pulled because of my list.

I put in the two "compose" actions above the condition and it still came back as false when I ran the flow.

And I attempted to make the filter change you recommended, only now it won't find the correct email to send it to. I don't want to send it to the person who created (me), I want to send it to the email address tied to the list row.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

For some reason, it looked like it only pulled the top row so I changed that date to 2-21, but it still says False.

Here is a shot of my list. I changed all of the dates to today. Just to confirm, the Flow will look at every single date to confirm which matches up with today's date, right? And if there are multiple on the same day, it will send to everyone?

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Anonymous ,

You could click on See more to see more Dynamic content, including the Email you want to configure.

Note that you need to add single quotes outside the expression:

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I tried that way as well and the quotes didn’t make a difference.

I also clicked “see more” on dynamic content and was not able to find the email I needed.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report
Hi @Anonymous ,

Expression seems to have a problem.

Expression should be:

utcNow('MM-dd')

Also, if you don't see other Dynamic content, you can switch Limit Columns by View to "Use all columns (Do not limit)" and click See more.

Please take a try.

Was this reply helpful? Yes No