Help Please...Email Sending from Excel Failing

Like (0) Share

Report

Posted on 29 Aug 2019 04:45:53 by Skyebabi

Hi,

I am trying to send an email based on criteria in an excel spreadsheet for reporting schedules. The intention is to have a daily scheduled trigger to match "today's" date (yyyy-mm-dd), and then send an email using additional conditions from the spreadsheet - being the email address, subject etc.

Within the Apply to Each control, the "send an email" is coming back with email ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email' skipped: the branching condition for this action is not satisfied.

I have attached images of my flow - can you please help me out? PS the blanks are filled in I've just blanked them out for privacy.

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (0)

v-bacao-msft on 02 Sep 2019 at 07:39:41

Like (0)

Report

Re: Help Please...Email Sending from Excel Failing

Hi @Skyebabi ,

Could you provide a screenshot of the error message?

According to your description, this is only because there are no eligible records in the Excel table, not the error of the action configuration.

Best Regards,

Was this reply helpful? Yes No
Skyebabi 11 on 02 Sep 2019 at 00:59:31

Like (0)

Report

Re: Help Please...Email Sending from Excel Failing

Can anyone please help me with this? I don't have an error in the Table function, the error is sitting with the email function. The instructions provided aren't clear to me and I've a large project resting on this one.

Any guidance to this very new-to-flow person?

Was this reply helpful? Yes No
Skyebabi 11 on 30 Aug 2019 at 05:02:50

Like (0)

Report

Re: Help Please...Email Sending from Excel Failing

Hi @v-bacao-msft

Can you help me figures this out? The link you sent through hasn't provided me with an answer to the send an email error I am getting.

Any help please and expertise would be great.

Cheers,

Was this reply helpful? Yes No
Skyebabi 11 on 30 Aug 2019 at 01:17:28

Like (0)

Report

Re: Help Please...Email Sending from Excel Failing

Hi and thanks, @v-bacao-msft .
This is the expression that I am using below which looks the same as the link you kindly provided. I want the current date to trigger the run and match the table. Should the date match, then the email will trigger.

utcNow('yyyy-MM-dd') is equal to add Days('1899-12-30',int(item()['10 Date']),'yyyy-MM-dd').

When I go through the run history the only error I am getting is at the send an email where I get the action branching condition not satisfied error.
I'm very new to this and have tried multiple ways, but can't seem to get it to work.
Cheers

Was this reply helpful? Yes No
v-bacao-msft on 30 Aug 2019 at 00:44:11

Like (1)

Report

Re: Help Please...Email Sending from Excel Failing

Hi @Skyebabi ,

Have you checked the contents of the run history-List rows present in a table action?

10 Date field has a value equal to the current date?

In addition, if the type of the 10 Date field in the Excel table is Date, then the value output in Flow may be Number, please refer to the following thread to restore the 10 Date column value to Date for comparison:

https://powerusers.microsoft.com/t5/Building-Flows/Excel-file-to-list-flow-date-issue/m-p/279258#M28826

Best Regards,

Was this reply helpful? Yes No

Community site session details

Help Please...Email Sending from Excel Failing

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Help Please...Email Sending from Excel Failing

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates