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 / Get Files (properties ...
Power Automate
Answered

Get Files (properties only) multiple file types

(1) ShareShare
ReportReport
Posted on by 55
Greetings,
I've build a flow that checks for certain types of Excel files(csv, xlsx) and moves them.  I'm struggling with having the "get files" property recognize both types.  If I use .xlsx or .csv the flow works as designed.  If I try any combination of the two, no errors, just runs without moving any of the files.
 
Any thoughts?  Also, if it helps all files lead with a 2024*.* naming convention.
 
 
Categories:
I have the same question (0)
  • Suggested answer
    trice602 Profile Picture
    16,023 Super User 2026 Season 1 on at
    Hi,
     
    I wasn't able to do this directly with a filter query expression in Get Items but I was able to successfully make it work inside two conditions.  Here's my flow:
     
     
     
     
     
    Condition 2 I am checking:
     
    length(items('For_each')?['{FilenameWithExtension}']) greater than or equal to 4
     
    and
     
    substring(items('For_each')?['{FilenameWithExtension}'],0,4) contains string('2024')
     
     
    Works in testing.  I had one excel file that started with 2024.  So the actions you want to do with those files would fall under the condition 2 true side.
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     


     
  • Verified answer
    trice602 Profile Picture
    16,023 Super User 2026 Season 1 on at
    Hi,
     
    Also confirming this picked up a .csv file that starts with 2024 also.  Always glad to help!
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     


     

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
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard