Special character not working with SharePoint activity

Help
, , ,
1

I am trying to ‘get file’ from a SharePoint, everything working fine, except if the Excel has a ‘#’ in the name. Then I get a ‘file not found’ error.

Anyone had this issue and found a ways to fix it?

The SharePoint package:

image
image380×533 17.6 KB

2

that char is not even allowed in sharepoint filenames… i dont see how it could contain that…

3

Just looked it up in Google, its seems you can actually allow them. Guess the organisation I’m working for did because there is file with # in the name. Do you think there would be a work around or the only solution is to disable them?

4

If you do have them, just remove them from the filename when you call the get file… see more here: Restrictions and limitations in OneDrive and SharePoint

5

@MaxyArthes
How about Renaming the Excel file before processing in sharepoint.

–
Mukesh

6

I can’t rename it, as it’s need the original name to find it and the SharePoint activity can’t find it because of the ‘#’ :frowning:

7

Did you try to pass the filename without the #?

8

yeah, I tried item.Replace(“#”, “”) and had the “file not found.” error anyway, I can’t find out what the ‘#’ character is changed into as it’s only by the SharePoint activity.

edit: The “Get file” from SharePoint activity is working fine tho, if I print the list of file found in the SharePoint, it’s will show the name with the ‘#’.

9

Yes, but is only like a display name, but the path of the file itself does not contain those chars that are not allowed…

1 Like
10

@MaxyArthes, Facing the same issue. Did you get any solution for it?

11

for some reason I just seen your message, prob missed the notification.

Sadly no, the person working with the sharepoint were told to stop using special character instead