Answered

Blank email coming as a result of Flow

(1) Share

Report

Posted on by GM-22011819-0

Hello,

I've created a flow to have an email sent at 10am in the morning and then again at 4pm (to capture any new submissions received between 10:01am-3:59pm) in the afternoon every day that displays any new office closure entries that have been submitted into the office closure table of the office closure power app I've built.

I've added the Condition since I'd only like to send the email if there are new entries prior on that given day. I used the condition if the length of the result from the List rows is greater than 0, then proceed with sending the email.

This is the expression I used in the Filter Array: the 'created on' date 'is equal to' 'utcNow('yyyy-mm-ddTHH:mm:ssZ')' - This is to configure the filter to show items where the submission date is today.

The email comes through without any submissions, just a blank email. Is 'body' in the 'From' for the create HTML table not the correct dynamic content? Or is output in the body of the email not the correct dynamic content?

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

David_MA 14,499 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Look at a flow run and the output of the Create HTML table action. If it is blank there, that is why nothing is showing up in your e-mail notification. If there is nothing there and you know you have items, then your filter is not correct. Based on your screen shot, I doubt the filter is correct since on the right side of the filter you just have the expression utcNow(), which will return the current date and time and odds are that when the flow runs nothing will have been created exactly at the same time as when the filter is applied.

You probably want to change your filter to where CreatedOn is greater than or equal to this expression instead: startOfDay(utcNow())

This expression would return 2025-03-03T00:00:00Z and thus return everything created today (in the UTC time zone). Your current expression would return 2025-03-03T18:12:05Z instead if run right now, which means it is only going to return items created at 2025-03-03T18:12:05Z.

Was this reply helpful? Yes No
GM-22011819-0 72 on at

Like (0)

Report
Copy link

Link copied!

Thanks David! That makes total sense with the filter, and the clarity of your explanation is perfect, much appreciated!

I adjusted the flow as per your suggestion, but the email is still blank. I pasted the outputs from the filter array, which show as nothing. Perhaps the error is occurring from there?

Was this reply helpful? Yes No
Verified answer

David_MA 14,499 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Since you don't show your entire flow, I am guessing you are just putting the output of the body of the filter array action into the Create HTML table action? If so, that is not how that works. You would first need to use a select action and then use the body of the select action to create the HTML table that you can then put in the e-mail. I would think how you have it configured would cause the flow to fail instead, however.

This will show you how to use select and then the create HTML table action to send it via e-mail: How to Create an HTML Table in Power Automate?

Was this reply helpful? Yes No
GM-22011819-0 72 on at

Like (0)

Report
Copy link

Link copied!

You are 100% correct, that's how I have it setup. Thank you for the information, I'll check out the link now. I the entire flow below for anyone else who could use this thread.

Was this reply helpful? Yes No