Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

Get files does not return all files in the library



I am working a report that will generate all the document inside a library. I succeeded creating the flow but I noticed that it does not return all the files in the library. I checked the item count in the site contents and it shows that I have 5147 files in my library but my report only gets 5047.


I already turned on the pagination setting on the get files action on my flow and I set the threshold to 100k but still returns the same file count. 


Please help.


Hi @karl_oliverio

Could you please share some more details about the flow? Specially Get files action part.

Also are these files contained in the same folder?

For now, you can give a try to List folder action, it returns files contained in a SharePoint folder.
Then compare the outputs of these 2 actions.

If this answers your question, please mark your post as Solved.

Hope the above content may help you.

The files are stored in the library and they are not inside a folder.


The items in this library contains 5105 files. 

library item count.PNG


However, my get files action from my flow only returns 5047

Get files.PNG

Resolver I
Resolver I

Hi Sir @Pstork1 ,


Have you experienced this when using get files on your flows? Do you have any solution in mind? 


Thank you! 

I wouldn't trust the UI metrics on the library.  Double check that there are no folders in the library.  It also might be a problem with certain restricted file types.  But I don't really have an obvious solution to offer.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,868)