Filter Array not working using Excel dates

(0) Share

Report

Posted on by aireland12

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

Categories:

Business Process Flows

All responses (1)

Answers (0)

Ana Almeida on at

Like (0)

Report

Re: Filter Array not working using Excel dates

Hello @aireland12 ,

Can you share a screenshot of the error?

Best regards,

Ana Almeida | Power Platform Support Engineer