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
Hello @aireland12 ,
Can you share a screenshot of the error?
Best regards,
Ana Almeida | Power Platform Support Engineer
User | Count |
---|---|
5 | |
5 | |
4 | |
2 | |
2 |