Links not sending correctly by email

[Sebastiaan1]

Hi all,

Currently I use a recurrence flow with get files (properties only) which will sent out an e-mail to a specific file with the url.

However since a few days the url is not working correctly and seems to be formatted in spaces instead of %20.

Old Situation:

https://............sharepoint.com/sites/S....../Shift%20Reports/2021/01-January%202021/03.doc?d=wf132fa02b121475296593fca1ce1b2dd

New situation:

https://............sharepoint.com/sites/....../Shift Reports/2021/01-January 2021/27.doc?d=wf0bd7572db1144779fa28f864fbb6f9d

Flow:

Anyone any idea on what it can be and how to solve it?

Thank you!

[Amatrox]

@Sebastiaan1 -

you can try to replace the spaces with %20 within an expression:

replace(outputs('Link_to_item'), ' ', '%20')

Best regards,

André

[Sebastiaan1]

Hi,

Maybe very silly question, but where do I place this expression? Did try different options, but no luck so far.

Thanks!

[Amatrox]

@Sebastiaan1 -

no worries! You have to replace your "Link to item" with the new "Link without space" compse-action in the email body like this:

[Sebastiaan1]

Perfect the link is indeed clickable now, but it will only bring me into the main folder of the year.

What we have is every day a new .doc document in a monthly folder, before the link would bring the other users directly into the new file/modified files. Is there an option to bring that back?

[Amatrox]

@Sebastiaan1 -

can you please compare the output link from the flow and the link to the .doc file directly from the sharepoint? Are there any differences?

[Sebastiaan1]

So currently the result e-mail will show this:
https://........sharepoint.com/sites/S....../Shift%20Reports  

While before it generated a clickable link directly to the file(with the link changing towards the new file name everyday) as example this:

https://................sharepoint.com/sites/S...../Shift%20Reports/2021/01-January%202021/25.doc?d=w9381378d389c4247bb770fa00eb5f2cd    

This there something that I overlook?

[Amatrox · Accepted solution]

@Sebastiaan1 -

ok, I see the mistake. Looks like you misunderstood me.
With your current flow, you can´t access todays file, because you predefined the url in the "Link with spaces" compose-item and used it in the flow. You wrote "https://.....sharepoint.com/sites/..../Shift Reports" and that´s why you only get to this point. The rest of the link is missing.
You have to use the dynamic content "Link to item" from the sharepoint (like you already did) and replace the spaces with %20.

My first description was just an example of how thinks work with the replace operator and not the 1:1 solution. But to make it more understandable, I have recreated a 1:1 solution for you....

Hope this works for you!

[Sebastiaan1]

Hi,

Thank you so much! It is working now, fantastic and once again thank you!