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

[GerryBrimacombe]

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' 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

[fchopo]

Hi @GerryBrimacombe 

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

 Hope it helps!

Ferran

[ggobbo]

Same problem here. Including nested items makes the step return no files.

Weird.

[JasonHW]

Did you ever find a solution?  I'm working with a much smaller number of file and when I set nested items to yes, the flow doesn't work. 

[Amit_Sharma]

Hi @GerryBrimacombe 

Go to SharePoint list then go in site content and then confirm what's type your documents.

[jamiefeldman]

Selecting "Yes" sets the viewScopeOption to RecursiveAll, which includes folders and is probably what is causing the issues. 

I have been using FilesOnly and it works. 

To use FilesOnly select the Enter custom value option and type FilesOnly

Hope this helps others that are getting this issue.

[Daniel1987]

I tried your approach. But FilesOnly also didn't work for me. But with using Recursive instead of RecursiveAll I finally got a list of all my files in the specified folder and its subfolders.

[LynnSandy]

Using Recursive worked for me too. Thanks!

[Daniel_Coelho]

This was the solution for me thanks. Thank you!

[TMProgUser]

I am having the same issue.  Where did you put "recursive"?

@Daniel1987 

[jamiefeldman]

The field that says "Include Nested Items" instead of selecting "Yes" or "No" choose the "Enter custom value". Then you can type "Recursive"

[cheethdswa]

Hi, I had the same issue but this "Recursive" worked for me BUT as im using this to delete files they now no longer show up in the recycle bin in SP?  without the "Recursive" my power automate only deleted the files within the root folder i choose but the sub folders. but with "Recursive" added it deletes the files within the sub folders also as wanted, but now they do not appear in the recycle bin? very strange. 

[O1u]

If trying all of the above didn't work for you, you should;

1. Enable pagination on the "Get files (properties only)" action 
2. Change "include nested files" to Recursive

[FrostKO]

I was having the same issue.  Confirmed; this worked for me in a small grouping of (15) files.

[avatar]

same problem  i try Recursive but it did not fix the problem any other ideas? the issue appear only in "new folders"

[O1u]

can you share your flow?

[avatar]

of course, it is a very simple flow 

[avatar]

fixing Enable pagination on the "Get files (properties only)" thanks  O1u 🙂