Unanswered

Send Email based on date column

(0) Share

Report

Posted on by Avenue5

I have been having many issues when trying to automate a flow to send emails based on rent due date and late date in SP. I am getting the following error at the send email step in "ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied." and no email is sent out. Below is a few screenshots.

Categories:

Using connectors

I have the same question (0)

All responses (12)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Avenue5 ,
I guess the time formats on both sides of your 'condition' control are different, so flow skips the step of sending emails.
Please go to the Edit interface and post a complete screenshot of the flow configuration.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Avenue5 10 on at

Like (0)

Report
Copy link

Link copied!

Sunshine,
Please see below of the complete flow.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Avenue5 ,
Please show the content filled in on both sides of your 'condition' control.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Avenue5 ,
1)Set the DateTime Format of the 'list rows present in a table' control to 'ISO 8601'
2)Please set the time format on both sides of the 'condition' control to 'yyyy-MM-dd'.

formatDateTime('For_each')['ColumnName'],'yyyy-MMM-dd') formatDateTime(utcNow(),'yyyy-MMM-dd')

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Avenue5 10 on at

Like (0)

Report
Copy link

Link copied!

Sunshine,
When I make the changes, I receive the error below.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Avenue5 ，
Is your loop outside the 'condition' control a 'For each' loop or an 'Apply to each' loop?
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Avenue5 10 on at

Like (0)

Report
Copy link

Link copied!

Sunshine,
This is what I have outside.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Avenue5 ,
Remove the 'For each' control, add the 'Apply to each' control, and use this expression.

formatDateTime('Apply_to_each_2')['ColumnName'],'yyyy-MM-dd') formatDateTime(utcNow(),'yyyy-MMM-dd')

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Avenue5 10 on at

Like (0)

Report
Copy link

Link copied!

Sunshine,
I receive the same error.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Avenue5 ,
Please try this expression:
formatDateTime('Apply_to_each_1')['ColumnName'],'yyyy-MM-dd')
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No