I am using UiPath.Team.Sharepoint.Activities version 1.5.2
If file name starts with # then uipath bot is unable to download file from sharepoint or upload it from local to sharepoint
For other files it is working fine
Hi @rajat_dhammi ,
you can add an exception flow to use the gui to upload and download files if filename starts with #
Hello @shetanshudhar
Yes, my bot has handled all exceptions for this. I have marked this question as bug and looking for answer whether we can download or upload file from sharepoint which starts from # like #abc.jpg
Have you already given this activity package a go?
https://docs.uipath.com/activities/docs/office365-download-file
1 Like
Hi @loginerror
Thanks for reply. I have tried this package but i found difficult to download specific file from a sharepoint folder through this package.
Any quick help would be appreciated
Suppose, I want to download file abc.jpg file from “Document/UiPath Uploads/March/abc.jpg”
After configuration, how to pass the drive item of the file and download file
As per the activity on-hover description:
Which would look like so:
I would first give this a try, and then adapt it by putting the subfolder parameter and the name of your file:
Just wondering if there has been any update on the issue with “#” in filenames. I have found that it’s not just an issue with a filename starting with #, but just containing it. I cannot download any file that has the # character in the name. I just tried it with version 1.7 and it’s still an issue. I have tried substituting “%23” into the Item URL, but I still get a “file not found” with the Get File activity. I’ve tried substituting %20 for the spaces to make the URL match exactly what you see in Sharepoint with “Copy Link” (see below) but it doesn’t help when the filename contains #.
Sharepoint Copy Link: /Shared%20Documents/Automations%20TEST/AccountingPackageBuilderSBD/In/BNYM%20-%20$6,140.89%20Credit%20-%20Intracompany%20transfer%20back%20to%20corp%2020-21%207.19.21%20%231%20reverse%20072921.pdf
My Item URL value: /Shared%20Documents/Automations%20TEST/AccountingPackageBuilderSBD/In/BNYM%20-%20$6,140.89%20Credit%20-%20Intracompany%20transfer%20back%20to%20corp%2020-21%207.19.21%20%231%20reverse%20072921.pdf
My automations mostly run unattended, so there’s no option of manually copying the file when it fails. I might be able to get the Office365 activities to work for this, but my current infrastructure/library calls are based around the Sharepoint.Activities.
Any help you can offer for this issue is appreciated.
1 Like
Hi @rajat_dhammi,
As this issue is related to UiPath.Team.Sharepoint.Activities version 1.5.2, here by looping in @radu_bucur and @Diana_Mincu for their inputs.
Regards
Sonali
Hey guys, unfortunately the URL of the file can get a little bit weird depending on the special characters in the name of the file. Did you get a chance to look through the documentation of the package? you have a few instructions there.
Also, try to look through the file properties in SharePoint, you can find the exact URL there and then use it.
1 Like
@radu_bucur Thanks for the input on this issue. I still have not been able to resolve it, except to use Office365.Activities instead of Sharepoint.Activities. Replacing “special” characters with their html equivalent works in some cases, but not others. For example, when the last level of a folder name contains a “.”, I can replace the “.” with %2E, and it works. But converting “#” to %23 does not work.
According to Sharepoint, the path to the file “#2 test.xlsx” is:
…/Shared%20Documents/General/Test/%232%20test.xlsx
Here are some log messages from using the Get File activity in a loop to download the files in a folder:
Getting /Shared%20Documents/General/Test/LAMBDA%20Example.xlsx
Getting /Shared%20Documents/General/Test/Automations%20Launched%20since%20November%202020%20Proj223.xlsx
Getting /Shared%20Documents/General/Test/%232%20test.xlsx
Get file – Download each In file to the tempFolder In folder: File Not Found.
Any suggestions on how to make Get File retrieve a file that has a “#” character in the filename?