Download Files from Sharepoint using 365 activities

Help Studio
1

How to download more than 200 files from sharepoint using microsoft 365 activities?

2

@Rohit_Nandwani

For each file or get use find files and download in a loop…there is no bulk donwlaod readily available

cheers

3

@Anil_G Already did that but its picking up 200 files only may be its a limitation or something.

4

@Rohit_Nandwani

Using find files has 200 limit

but for each file I guess you dont did you try that also?

cheers

5

Hi @Rohit_Nandwani

Use the Get Files activity to retrieve a list of all the files and set the Top property to a high number to ensure all files are retrieved then use a For Each loop activity to iterate through the list of files.
Within the loop, use the Download File activity to download each file to your local system.
If you want to download files in batches, you can use the Take and Skip LINQ methods to limit the number of files processed in each loop iteration.

Thanks!!

6

Yeah exactly find files is returning 200 files only but there are more than 200 files in that folder. Is there a way to get rid of this limitation @Anil_G

7

@Rohit_Nandwani

Try this instead

https://docs.uipath.com/activities/docs/office365-for-each-file-folder

Or after 200 move them and then get again yo get next 200 files

Cheers

8

@Anil_G For each files/folder does not work with application secret and application id. Is there a way to download a folder?

9

@Rohit_Nandwani

Download of folder is not possible…

So your other way would be to go with would be to move the files once downloaded so that uou canget next set

And integration services provide multiple authentications…can check once

Cheers