Can somebody please assist as to why this flow will not send the email when I test?

(0) Share

Report

Posted on by Reaper

Here is the Spreadsheet it is pulling data from

Here is the flow with the condition function highlighted. I just want an email sent when the "ReminderEmail" date arrives. Thank you.

All responses (7)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Re: Can somebody please assist as to why this flow will not send the email when I test?

Hi @Reaper ,

Please check this test:

My Flow Overall Preview:

My Flow Configuration Parameters:

Do not choice any DateTime Format in List rows present in a table:

ReminderEmail ne '@{null}' addDays('1899-12-30',int(item()?['ReminderEmail']),'yyyy-MM-dd') utcNow('yyyy-MM-dd')

Best Regards,

Sunshine Gu
Reaper 6 on at

Like (0)

Report

Re: Can somebody please assist as to why this flow will not send the email when I test?

There is a lot more, please let me know if you want me to keep screenshotting
v-yetonggu-msft on at

Like (0)

Report

Re: Can somebody please assist as to why this flow will not send the email when I test?

Hi @Reaper ,

What is the error message in your flow? Please go to the classic designer to run the flow, and then please upload a screenshot of the output of your list rows present in a table to me.

Best Regards,

Sunshine Gu
Reaper 6 on at

Like (0)

Report

Re: Can somebody please assist as to why this flow will not send the email when I test?

Unfortunately it has failed again
v-yetonggu-msft on at

Like (0)

Report
Re: Can somebody please assist as to why this flow will not send the email when I test?

Hi @Reaper ,

Please use this expression in condition left:

if(empty(items('Apply_to_each')?['ReminderEmail']),null,items('Apply_to_each')?['ReminderEmail'])

Best Regards,

Sunshine Gu
Reaper 6 on at

Like (0)

Report

Re: Can somebody please assist as to why this flow will not send the email when I test?

I have completed these steps but still no email unfortunately
v-yetonggu-msft on at

Like (0)

Report
Re: Can somebody please assist as to why this flow will not send the email when I test?

Hi @Reaper ,

Please select ISO 8601 in DateTime Format in the list rows present in a table control, and then use this expression on the right side of condition:

utcNow('dd/MM/yyyy')

Best Regards,

Sunshine Gu