How to Get and download file from SharePoint by using Office365

Help Activities
, , ,
1

Hi Team,

Could you please help on how to get and download excel files from Sharepoint by using office 365 scope . I attached the folder path in below screenshot.

The image shows a directory listing of an Excel Documents folder within a project structure, containing folders and Excel files with details on their names, modified dates, and sizes. (Captioned by AI)
The image shows a directory listing of an Excel Documents folder within a project structure, containing folders and Excel files with details on their names, modified dates, and sizes. (Captioned by AI)1663×557 49.4 KB

2

Hi @manojmanu.rpa

To work with the Sharepoint, we have activities in UiPath. Install the UiPath.MicrosoftOffice365.activities package and search for the Sharepoint activities in activities panel.

Use the Download File activity to download the files from the Sharepoint.

Check the below documentation for better understanding,

Hope it helps!!

3

How can we pass the input to download file activity?

4

Hey @manojmanu.rpa this link help you to For Downloading files from Sharepoint.

also there are some steps you need to do before using these activities

cheers

5

Check the below video to download the sharepoint file… @manojmanu.rpa

Hope it helps!!

6

@manojmanu.rpa

If using modern office activities then in download you can select the file and folder

If classic first use find files/folders activity then the response or output of that activity is to be used in the download file

In find files

Query : give the filename with extension
Sub folder : 2-ACTIVE\…\E-Excel Documents
Sp url - is the base url till name after sites in url
Document library - generally it is documents, unless you change the name

Cheers

7

Thanks, but find files/folder activity is not available

8

@manojmanu.rpa

Then you might be on modern…if on modern activities then you should be able to select the file directly

Also ideally find files should be available please check through activities…or share a screenshot here of the download activity you are trying to use

Cheers

9

The image shows a computer screen displaying the UiPath Studio Community interface with various Office 365 activities and properties panels visible for automating file and folder actions. (Captioned by AI)
The image shows a computer screen displaying the UiPath Studio Community interface with various Office 365 activities and properties panels visible for automating file and folder actions. (Captioned by AI)1920×1080 110 KB

Here is the screenshot of download file activity in office 365 scope.

10

@manojmanu.rpa

Find files is similar to get file…now what issue are you facing?

As I see you already configured the activities?

One thing you are missing is the authentication of scope …

Cheers