Answered

PowerAutomate Flow Unable To Enter Folder Contents

(0) Share

Report

Posted on by IceQueen

Hello,

So, I have a flow that is to transverse all the folders and files and email notifications on files that are about to expire.

The flow worked on test folders with nested files, however on the final "Contacts" folder (where there are about 200 folders and 5000 files), it only transverses the folders.

I am very confused on why the flow only works for the test folders (the test folder is one of the "Contracts" folders) and not the "Contracts" folder. Is there a specific reason or perhaps the other folders have some sort of protected content property?

(Note: I did not originally create this library so not sure if there is some property in place that is preventing the flow from transversing all files)

Flow Below:

(Note: Ignore the condition after the "If No", that was me trying to figure out what the flow was doing - transversing folders only)

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

JacksonTeo 35 on at

Like (0)

Report

Hi @IceQueen
Is it because you select the Limit entries to folders of your test folder? try to just select the parent folder and test.

Was this reply helpful? Yes No
IceQueen 42 on at

Like (0)

Report

Hello @JacksonTeo

Apologies for that confusion. The flow seems to work when I direct it to that folder but not for the general "Contracts Folder." That is the issue I am trying to figure out.

Not sure if this is the issue, but I also get a lot of weird stuff when trying to set the folder path:
This is weird since I don't know all the other folders that have an _ before them and also when navigating in the library, there is only Documents/Contracts - not Shared Documents/Contracts.
Is the flow running into an issue with these "hidden" folders?

Was this reply helpful? Yes No
mgrachii 206 on at

Like (0)

Report

Hello!
This also happened to me some weeks back. The "Get Files" and "List files in folder" cards don't seem to work on folders/sites where there are too many nested files - I don't really know why.

The only way I found to workaround this was by using the "Send HTTP Request to SharePoint" card, then I just added a Parse JSON action to access and loop the files. The flow worked for me after I started using the HTTP card.

Just select the Site Address, then Method shouold be GET and the The URI structure is as below, always starts with "_api/web/GetFolderByServerRelativeUrl" then indicate the part between parentesis and then end with "/files"
-> _api/web/GetFolderByServerRelativeUrl('/Shared%20Documents/your-folder-path-goes/here')/files
hope this helps!

Was this reply helpful? Yes No
mgrachii 206 on at

Like (0)

Report

Hello!
This also happened to me some weeks back. The "Get Files" and "List files in folder" cards don't seem to work on folders/sites where there are too many nester files - I don't really know why.

The only way I found to workaround this was by using the "Send HTTP Request to SharePoint" card, then I just added a Parse JSON action to access and loop the files. The flow worked for me after I started using the HTTP card.

Just select the Site Address, then Method shouold be GET and the The URI structure is as below, always starts with "_api/web/GetFolderByServerRelativeUrl" then indicate the part between parentesis and then end with "/files"
-> _api/web/GetFolderByServerRelativeUrl('/Shared%20Documents/your-folder-path-goes/here')/files
hope this helps!

Was this reply helpful? Yes No
Verified answer

IceQueen 42 on at

Like (0)

Report

Hello,

Thanks for your advice. However, after a colleague helped me, it seemed to be the issue that the flow only runs 100 items. This link helped resolve the issue:
https://powerusers.microsoft.com/t5/Building-Flows/get-items-only-returns-100-records/td-p/136883

Was this reply helpful? Yes No