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:

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Xinlin 82 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
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 🙂

Was this reply helpful? Yes No
Xinlin 82 on at

Like (0)

Report

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. 😥

Was this reply helpful? Yes No