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)

v-yetonggu-msft on at

Like (0)

Report

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

Sunshine,
Please see below of the complete flow.

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

Like (0)

Report

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

Like (0)

Report
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

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

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

Like (0)

Report

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

Sunshine,
This is what I have outside.

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

Like (0)

Report
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

Sunshine,
I receive the same error.

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

Like (0)

Report
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