Unanswered

Email Notification Not Sent

(0) Share

Report

Posted on by Xinlin

Hi masters,

I have a flow that schedule to run at daily 00:00. The flow is supposed to run the Dataverse table and send out email notification if the date matched.

However, my flow show success despite not running and sending out the email notification. I've also tried to filter with 'eq' to the exact date but faced the same challenge as well. Below attached with the flow and result. Hope can get some insights or other workaround on this issue. Thank you!

Flow:

Result:

All responses (4)

Answers (0)

Xinlin 82 on at

Like (0)

Report

Re: Email Notification Not Sent

Hi @BCBuizer,
Tried it with the provided formula but email action didn't perform as well. I had set one of the column value to today's date to test out. 😥
BCBuizer 22,262 Super User 2025 Season 1 on at

Like (0)

Report
Re: Email Notification Not Sent

Hi @Xinlin ,

Can you try to update the filter expression to:

crf38_nextchaserdate eq '@{startofday(utcNow(),'MM/dd/yyyy')}'

From what I can see you are trying to get dates that are greater than or equal to today and less than tomorrow, which pretty much leaves items with today's date only...

Of course, when testing, make sure you have an item in your table that has today's value in the crf38_nextchaserdate column 🙂
Xinlin 82 on at

Like (0)

Report

Re: Email Notification Not Sent

Yes, it is from the List Rows action. I did have set one of the date to be 12/22/2022 in dataverse for the test case, which I don't understand why it return with no item.
BCBuizer 22,262 Super User 2025 Season 1 on at

Like (1)

Report

Re: Email Notification Not Sent

Hi @Xinlin ,

What, in your example, is the output from the List Rows action? It seems to return no items, hence no mails are sent out.