News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Filter array from list...

Power Automate - Building Flows

Unanswered

Filter array from list excel date

(1) Share

Report

Report

Posted on by noviaanggriawan

14

Hai everyone, I have a problem with my flow, where the date presented in power automate is in integer format.

I have use adddays to change the format, but still fail.

This is my flow.

It get errors on the filter array part.

The "approved Date" is not converted correctly.

This is the excel format

All responses Img

All responses (1)

Answers Img

Answers (0)

Chriddle 7,791 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filter array from list excel date

In the Excel connector set the DateTime format to ISO-8601 (This makes the coonector returning date strings)

Remove the addDays(...int(...)) function from your expression (when using ISO 8601 formatted dates you don't need this)

In formatDateTime change the format string to 'yyyy-MM-dd' (checking if greater is a string comparison from left to right)

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans