Query to search and retrieve Files inside children's folder/subfolders using ‘Find Files And Folders’ activity in Office365 Scope

So I have a SharePoint from which I have to download files. the issue is the path is fixed until certain folder after which the folders name and number of subfolders are undefined. I am able to to retrieve folders after fixed path but after it the sub folders I am unable to get the inside subfolders and files. Anyways The folders name or number is not required only the files are important. So I am using query field input a string which will be always be there in all files for example : “Oracle”

but using these query I am able to get only those files and folders which are available in fixed path and not all the files in children’s path.

for example : fixed folder path/ 1. res folder 2. oracle folder 3. Jan oracle.xlsx. 4. config

inside 1 . res folder there are multiple files which contains oracle name but I am only getting 2 drive items i.e. oracle folder and Jan oracle.xlsx

1 Like

Hey @Akshay_Suryawanshi

Currently there is no direct option to all the child folders and files

But we have a workaround where you need to loop through and find each folder and files repeatedly until you don’t find any folder again inside.

Hope that make sense. Let me know for any clarifications.

Thanks
#nK

@Akshay_Suryawanshi

You can try using for each file/folder activity which has an option to include subfolders search as well…please check this

Hope this helps

Cheers

Hi Nk,

Sorry for late reply can you provide the workaround workflow, If possible?