cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GerryBrimacombe
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.

GerryBrimacombe_0-1618587438715.png

 

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' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com;","MicrosoftSharePointTeamServices":"16.0.0.21131","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":"https://flow-apim-msmanaged-na-eastus2-01.azure-apim.net/apim/sharepointonline/shared-sharepointonl-fabf0e50-484e-4907-901f-123dfd118c33/datasets/https%253A%252F%252F[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,

Gerry

 

1 REPLY 1
fchopo
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?:

pagination.png

 Hope it helps!

Ferran

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

Helpful resources

Announcements
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)