Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : EHXQkVSEqcRTp6JzmNn2gw
Power Platform Community / Forums / Power Automate - Building Flows / Filter array from list...
Power Automate - Building Flows
Unanswered

Filter array from list excel date

Like (1) ShareShare
ReportReport
Posted on 8 Jul 2024 03:33:19 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.

noviaanggriawan_2-1720409501799.png

It get errors on the filter array part.

noviaanggriawan_1-1720409373384.png

 

The "approved Date" is not converted correctly.

noviaanggriawan_0-1720409353095.png

This is the excel format

noviaanggriawan_3-1720409580478.png

 

 

  • Chriddle Profile Picture
    Chriddle 7,934 Super User 2025 Season 2 on 08 Jul 2024 at 07:07:17
    Re: Filter array from list excel date
    1. In the Excel connector set the DateTime format to ISO-8601 (This makes the coonector returning date strings)
    2. Remove the addDays(...int(...)) function from your expression (when using ISO 8601 formatted dates you don't need this)
    3. In formatDateTime change the format string to 'yyyy-MM-dd' (checking if greater is a string comparison from left to right)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans