web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter array doesn't f...
Power Automate
Unanswered

Filter array doesn't filter correctly

(0) ShareShare
ReportReport
Posted on by

Hey All,

 

Every day i get a file in a certain sharepoint map with the current date in the name of the file.

The flow i want to create is to delete "old"  file. So all the files that doesn't containt the current date in the name

So i created a array with a list of all the files.

 

I have an array with files from sharepoint, i want it to filter out 

I created a variable with the current date 'ddmmmyyyy'.

 

Capture.JPG

And then filter the Name of the file that doesn't contain the date.

But for some reason, this doesn't work while the variable are correct:

Capture1.JPG

 

But it doesn't filter:

 

Capture3.JPG

 

What am I doing wrong?

 

 

Categories:
I have the same question (0)
  • Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at

    @RLie 

    Hi there.  Is it possible the filter array is case sensitive?  Try wrapping your Compose expression in a toLower() and see if that works.

    -Ed

     

    If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

  • RLie Profile Picture
    on at

    Allright! that was not the solution but i found the issue!

    I used the wrong variable to compare, (see filter array in the first screenshot) 

    I used the expression instead of the variable from the compose step.

     

     

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard