cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karl_oliverio
Resolver I
Resolver I

Get files does not return all files in the library

Hi,

 

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.

4 REPLIES 4
Therese-Youssef
Microsoft
Microsoft

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.
Thanks.

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

karl_oliverio
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

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,031)