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

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,110)