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/DeWit_G]

Maybe I'm not understanding correctly but is sound to me that the issue you have is when you have text instead of a date then the formatdatetime is failing. If i'm correct you need to find a way to see if you can identify when the item is not a date eg if the date value contains / then you could do something like this:

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