Unanswered

Help Please...Email Sending from Excel Failing

(0) Share

Report

Posted on 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

All responses (5)

Answers (0)

v-bacao-msft on at

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,
Skyebabi 11 on at

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?
Skyebabi 11 on at

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,
Skyebabi 11 on at

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
v-bacao-msft on at

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,

Community site session details

Help Please...Email Sending from Excel Failing

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

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

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates