Excel rows send in only one email with condition

[Csaba3]

Hello,

Im am new in the Power automate, but i like it. How can i send all excel rows (from one table) in only one email with condition?

I would like to use simple condition like this  (if excel table is empty dont send email):

Thank you any replay!

[Jronash]

After your "List rows present in a table" action, add a "Filter array" action.  Use that filter on the values from your Excel Spreadsheet to select only the rows where the Date Checked column is not equal to null.

Next, use a "Create HTML Table" action.  Set the filter you just created as the source.

Finally, create the action to send the email.  Put the output from your Create HTML Table action in the body of the email.

[Csaba2]

Thank you for your replay!

How can i use the excel - empy filter in the Powerautomate?

The other settings is working good, include HTML, array settings, but I just don't know how to specify the settings for the empty excel condition.

Can you send to me a flow screenshot?

[Jronash · Accepted solution]

Looks like Date fields with no values are returned as empty strings, not as null - at least in my test.  In that case, you can set up a filter like this:

Select the Date created field, set it to "is not equal to", and leave the second field blank.  It will filter out all the rows with no date and return the rows that do have a date.

[Csaba3]

Thank you! Its working good.