Emailed hyperlink not working

[elDub]

Hello all,

I am successful at getting a SharePoint folder to trigger an email anytime a new document is placed in it. However, the email is meant to contain a clickable link to that document. Unfortunately the path and file name contains spaces. I have hard coded the path (including spaces) which is working with %20's but the file name with spaces breaks the hyperlink.  Is there a method to edit the flow to include spaces, insert %20's, or just plain work as a hyperlink?  I am not skilled in this area so forgive my asking for a detailed response on how I can resolve this.

Example:

filename in sharepoint- https://website.sharepoint.com/sites/team/Shared%20Documents/General/Remote%document%20Forms/sample text.pdf

filename in email- 
https://website.sharepoint.com/sites/team/Shared%20Documents/General/Remote%document%20Forms/sample text.pdf

Many thanks.

[tom_riha · Accepted solution]

Hello @elDub ,

you can use the replace(...) expression to replace the spaces with %20. Before you send the link, apply the expression:

replace(<the url>, ' ', '%20')

that'll replace all spaces in the whole link, including the file name.

[elDub]

Thank you for this.  Just to clarify, I wish to use Dynamic Content based on the file that was added to the sharepoint folder.  These files are dropped with spaces in the name.  Can I still use that expression or is there another way to incorporate the Dynamic Content with spaces in the file name. Note the Dynamic Content I have been using is x-ms-file-name-encoded

[elDub · Accepted solution]

Ignore the request, I realised I needed to create a variable first then call that variable in the trigger email.

[v-xiaochen-msft]

Hi @elDub ,

Has your problem been solved?

Is there anything I can help?

If your problem has been solved, you could mark the correct reply as a solution.

Best Regards,

Wearsky