Special character not working with SharePoint activity

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:

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

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?

If you do have them, just remove them from the filename when you call the get file… see more here: https://support.office.com/en-us/article/invalid-file-names-and-file-types-in-onedrive-onedrive-for-business-and-sharepoint-64883a5d-228e-48f5-b3d2-eb39e07630fa

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


Mukesh

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:

Did you try to pass the filename without the #?

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 ‘#’.

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