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) is omitting and/or renaming random files

(1) ShareShare
ReportReport
Posted on by 14

Hello all,

This very straightforward flow is part of a larger flow I'm working on. [Get Files] was coming up empty in the larger flow so I created this one to isolate and test [Get Files]. It's finally outputting files and folders, but upon closer inspection, I noticed that it seems to be arbitrarily skipping some files. 

 

I dumped the raw output of the [Select] data op into Excel. I sort it and compare the listings to the actual contents of the SharePoint folders. Every folder I check is missing a random number of files. I've set the "Top Count" to 10 million and it's STILL omitting files from the result set.

 

Not only is it omitting files, but it's also dropping any prefixes on the file names it does list.

Files named "Documents Needed - Quarterly report 2024.xlsx" show up in the output as "Quarterly report 2024.xlsx". 

 

Any idea if this is by design or are these bugs?

Thanks in advance!

 

logicworkz_1-1710348019523.png

 

 

logicworkz_0-1710347428035.png

 

Categories:
  • trice602 Profile Picture
    16,699 Super User 2026 Season 2 on at

    Hi @logicworkz ,

     

    The maximum pull (without pagination options) is 5,000 files and is the root cause.  I can't speak to the file name variance but recommend you check and see if there is in fact another file named that.

     

    If you have a one-off project that requires more extensive file visibility, I recommend you move your project to Power Automate Desktop, "get files" in PAD is more efficient by design.

     

     

  • logicworkz Profile Picture
    14 on at

    Thx for the response!

     

    This task is for compliance at the enterprise level. I'm new to power automate. So would PAD will allow for triggered flows without being dependent on the desktop itself running...I'm only using cloud flows.

     

    As far as the files renaming, I'm certain. These are files that exist within a particular subfolder. And we're talking 8 files in a sub all missing the prefix portion. Very strange...

     

    logicworkz_0-1710349612279.png

     

    VS. SharePoint

     

    logicworkz_1-1710349676958.png

     

  • Verified answer
    logicworkz Profile Picture
    14 on at

    PAD is unable to create cloud flows so that wasn't a solution. I did stumble upon a setting that fixed the issue. Within the Get files (properties only) module go to the Settings tab and turn on "Pagination". I set the Threshold to 20,000 and I'm all good now.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 288 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard