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 Automate - Building Flows
Answered

Get Files step also returns folders, not just files

(0) ShareShare
ReportReport
Posted on by 68

Hello, I'm using a 'Get files (properties only) in my flow hoping to get an array of files as per a filter query I have set up.

 

The flow runs successfully however this step also returns folders (as items) in its output, not just files. For example, if I have a "File A" inside "Folder A", then the flow may returns 2 rows (one item: "File A", second item: "Folder A") which is not what expected/desired.

 

Any thoughts? Many thanks in advance.

 

AntDim_0-1712329907481.png

 

I have the same question (0)
  • Verified answer
    ManishSolanki Profile Picture
    15,089 Super User 2025 Season 2 on at
    Re: Get Files step also returns folders, not just files

    Hi @AntDim 

     

    The action 'Get files' returns both files & folder in the output. To get only files, you can use filter query as shown below:

    ManishSolanki_0-1712331573869.png

    FSObjType eq 0

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

  • AntDim Profile Picture
    68 on at
    Re: Get Files step also returns folders, not just files

    thank you @ManishSolanki , this is exactly what I was looking for. really appreciate your swift response ☺

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard