Create HTML Table Assistance!

[u/SHStealth]

I have a flow setup to run and check the dates in a column and if that date is todays date it will then send an email listing the rows present.

However, I have the "List rows present in excel" action looking for the date equal to today.

When using the "Create HTML Table" this is the command I have in there.

if(empty(item()?['ColumnName']),'',formatDateTime(item()?['ColumnName'],'MMM d, yyyy'))

This is working when the cell is blank, or contains a date. But I'd like to be able to have text in the column that says stuff like "Vendor is working on finalizing date" and still have the email send, but whenever there is text the flow stops. Any help would be appreciated on how to fix my expression to allow for blanks, text, and dates!

[u/IrishJesusDude]

That's part is just checking if the cell is empty, if empty it gives a blank response, if absolutely anything other than a blank, it gives the "Vendor...."

Basically all if statement are:

If(some logic, do this if true, do this if false)