Update: Get all folders does not return all values

[XAEA12]

Hi, 

I am doing a get files properties only on a SharePoint library which has over 20000 documents/folders. Under Shared Documents I have around 11 folders (and multiple sub-folders on each). The Get only returns 7 of these 11 folders. The flow looks like below.

Tried to index the title column but does get the correctly. I tested in another tenant where I put the same folder structure and populated the library with over 5000 folders and the Flow works beautifully.

Any ideas? To me it looks like some bug.

[Johnnyg · Accepted solution]

Hello XAEA12,

This is one known limitation. Please check following Doc and Community post with similar request
https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-g...

https://powerusers.microsoft.com/t5/Building-Flows/Get-File-Properties-sharepoint-more-than-5000-lim...

[XAEA12]

Thanks for your input!

But still this is a weird behavior, if trying to go deeper in my folder structure, so that I narrow it down, it still does not pick up one of my sub-folders, instead it goes straight to a sub-sub folder.

To me it still does not make sense.