I have already tried several options to try to download a complete folder in SharePoint. The 365 permission is ok but the “download file” activity is not able to download folders. Can anyone tell me how I can download an entire folder or at least all the files inside that folder?
If you are not using integration services then can go with find files and give only subfolder details and leave wuery emtpy so that all files from the given folder are retrieved can use for loop and download inside
As per error you tried downloaded folder and not file
-Get the List of Files in the Folder
Use the Find Files and Folders activity inside the Office365 Scope to get all files in the target SharePoint folder.
Set the folder path of the SharePoint library.
Filter the results if necessary
-Download Files from SharePoint
Loop through each file using a For Each activity.
Inside the loop, use the Download File activity to download each file from the SharePoint folder to your local directory.