The dates are text fields in the Excel file and I need to check them against today's date. If they are 2 years prior to today, I need to send an email.
I have it set up like this - I'm getting an error message on the Filter Array step:
1. action List Rows in Table
2. action Filter Array
@equals(formatDateTime(item()?['Subs Initial Activation Dt'], 'yyyy-MM-dd'), formatDateTime(addDays(utcnow(),-730),'yyyy-MM-dd')
3. action Select
4. action Create HTML
5. action Send email


Report
All responses (
Answers (