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.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,515)