Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Get Files (properties only) fails when "Included Nested Items"=YES

I have a document library with about 140,000 items, in nested folders.


I need to take action on every file in a given folder, including files in nested sub-folders.


Here is the action, very straightforward. In the final version the "Limit Entries to Folder" will be a variable, but this is a simplified test that still fails.



This should return 4 folders and 3 files, plus a few other files in the subfolders. it returns nothing:

{"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Vary":"Origin,Accept-Encoding","X-SharePointHealthScore":"2","X-MS-SPConnector":"1","X-SP-SERVERSTATE":"ReadOnly=0","DATASERVICEVERSION":"3.0","SPClientServiceRequestDuration":"247","SPRequestGuid":"556db397-0f38-4d91-a2f9-c7ded75f111d","request-id":"556db397-0f38-4d91-a2f9-c7ded75f111d","MS-CV":"l7NtVTgPkU2i+cfe118RHQ.0","Strict-Transport-Security":"max-age=31536000","X-FRAME-OPTIONS":"SAMEORIGIN","Content-Security-Policy":"frame-ancestors 'self' * * * * * * * * *;","MicrosoftSharePointTeamServices":"","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","Cache-Control":"max-age=0, private","Date":"Fri, 16 Apr 2021 15:38:00 GMT","P3P":"CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Type":"application/json; charset=utf-8","Expires":"Thu, 01 Apr 2021 15:38:00 GMT","Last-Modified":"Fri, 16 Apr 2021 15:38:00 GMT","Content-Length":"477"},"body":{"@odata.nextLink":"[server name here - hidden for privacy - GB].com%252F/tables/d144e7b2-84bd-4818-b5e6-8bad50a53e28/getfileitems?folderPath=%2fCommercial+Reports%2fEVR%2f12345&viewScopeOption=RecursiveAll&$skiptoken=Paged%3dTRUE%26RootFolder%3d%252fCommercial%2520Reports%252fEVR%252f12345%26ix_Paged%3dTRUE%26ix_ID%3d6419","value":[]}}


However, when I run with "Nested"=No, it returns the folder content correctly (without subfolder contents, of course).


So what's happening? Is it because of the large library? A bug with "Get items"? I am open to any suggestion on how best to solve this. (I have been trying HTTP action and List Folders -- neither give me the "nested" capabilities I need).


Thank you in advance,



Super User
Super User

Hi @GerryBrimacombe 

Could you try to enable pagination on the "Get files (properties only)" action, and get 1000 items, for example?:


 Hope it helps!


Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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.

Users online (3,314)