Answered

Email Not Sending

(0) Share

Report

Posted on by RT-28011822-0

I've created a flow to look at an Excel document and send an email reminder. The flow has tested successfully without errors, but the emails are not being sent. It appears that those steps are being skipped, but I have not been able to determine why. See flow below

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @RT-28011822-0,

Can you check if the Apply to each loop is actually running for all items after the union?

Also, please share a screenshot of the full run history showing the union, the loop, and the email action screen shot, that will help us see why the emails are being skipped.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!

Was this reply helpful? Yes No
Verified answer

Ellis Karim 12,163 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @RT-28011822-0,

I suspect that the issue is with the Filter Query in the "List Rows present in a table" action?

The expression needs to use CAPITAL MM for months. Lowercase mm will give you minutes.

Please also post some sample data for the ReminderDate so we can check if the filter is working as expected.

Please send us a screenshot of the runtime for this action too.

In the meantime, the following tutorial may be of some benefit:
Power Automate and Excel: Combine Multiple Rows Into One Email Per Recipient – Ellis Karim's Blog

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
RT-28011822-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, Ellis. I have updated the formula as you suggested, however when tested I am still not getting an email. I've posted screenshots below

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 12,163 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RT-28011822-0

(1) To see if the List rows present in a table action found any rows, click the Show raw outputs link:

I suspect you won't find any rows in the output.

I think what is happening is that the ReminderDate is read in the following format, which includes the time stamp: yyyy-MM-ddT00:00:00.000Z

But the time zone conversion from UTC to Pacific Standard Time outputs a date in the following format, which does not include the timestamp: yyyy-MM-dd

So, the filter query in will never match your local time zone because the text values are different.

Try the following:

(1) Filter out rows that don't have a ReminderDate:

(2) Add a Filter array action, to find the rows you need:

formatDateTime(item()?['ReminderDate'], 'yyyy-MM-dd') convertFromUtc(utcNow(), 'Pacific Standard Time', 'yyyy-MM-dd')

(3) In the Select action, use the output of the Filter Array action:

See also:

Power Automate: How to Read More Than 256 Rows from an Excel Table

Power Automate: Item() vs Items() in Apply to Each – Explained with Examples

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No