web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    Re: Filter array doesn't filter correctly

    @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
    Re: Filter array doesn't filter correctly

    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard