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.

All responses (12)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Re: Send Email based on date column

Hi @Avenue5 ,
Do you want to check every day whether the following deadline is equal to today, and send an email notification if it is equal to today?
If so, I did a test for your reference.
In my scenario:
Please go to Classic Designer.
My complete flow:
formatDateTime(items('Apply_to_each')?['Date'],'yyyy-MM-dd') utcNow('yyyy-MM-dd')
Best Regards,
Sunshine Gu
Avenue5 10 on at

Like (0)

Report

Re: Send Email based on date column

Sunshine,
That is what I had as the expression.
v-yetonggu-msft on at

Like (0)

Report
Re: Send Email based on date column

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

Like (0)

Report

Re: Send Email based on date column

Sunshine,
I receive the same error.
v-yetonggu-msft on at

Like (0)

Report
Re: Send Email based on date column

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

Like (0)

Report

Re: Send Email based on date column

Sunshine,
This is what I have outside.
v-yetonggu-msft on at

Like (0)

Report

Re: Send Email based on date column

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

Like (0)

Report

Re: Send Email based on date column

Sunshine,
When I make the changes, I receive the error below.
v-yetonggu-msft on at

Like (0)

Report
Re: Send Email based on date column

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

Like (0)

Report

Re: Send Email based on date column

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

Best Regards,
Sunshine Gu