Sharepoint Path from variable not recognized

(0) Share

Report

Posted on by acepeda

133

Hi. I apreciate if anyone can help me with this issue,

I have a flow that gathering several records from an excel table. There is a field in this table called path where a Sharepoint path to excel file is placed. This path is stored in a variable SiteAddres as shown in the attached image and then is used it for getting the corresponding file and finally storage in a local folder.

My issue is that this flow works only when i use Classic Experience Sharepoint Path format:

https://mysite.sharepoint.com/teams/Legacy ......

instead of

https://mysite.sharepoint.com/:x:/r/teams/Legacy ......

and the second issue is presented when using special characters in the target excel file name like:

This-is an example & file.xlsx

My ideal solution is to be able to use the Modern Site Path format and file name with special characters with no alterations or, if no possible add some string manipulation or conversion to make it compatible with my flow.

Thanks in advance for any help.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@acepeda the link https://mysite.sharepoint.com/:x:/r/teams/Legacy is the sharing link of the file, you need the actual path of the file get the file in flows, so i dont you can get the file using sharing link, there are some graph apis using which you can get file properties using the sharing link, if you want to use that.

For file name to have special characters, there are some characters that SharePoint doesnt allow refer this https://support.microsoft.com/en-us/office/restrictions-and-limitations-in-onedrive-and-sharepoint-64883a5d-228e-48f5-b3d2-eb39e07630fa#invalidcharacters to know more

Was this reply helpful? Yes No
acepeda 133 on at

Like (1)

Report

Thanks @annajhaveri i'll follow your advise.

Was this reply helpful? Yes No