Showing results for 
Search instead for 
Did you mean: 
New Member

Filter Array not working using Excel dates

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 

Community Support
Community Support

Hello @aireland12 , 

Can you share a screenshot of the error?


Best regards,

Ana Almeida | Power Platform Support Engineer

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,673)