Unanswered

Links not sending correctly by email

(0) Share

Report

Posted on by 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!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Amatrox 109 on at

Like (0)

Report

Re: Links not sending correctly by email

@Sebastiaan1 -

you can try to replace the spaces with %20 within an expression:
replace(outputs('Link_to_item'), ' ', '%20')

Best regards,
André

Was this reply helpful? Yes No
Sebastiaan1 57 on at

Like (0)

Report

Re: Links not sending correctly by email

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

Was this reply helpful? Yes No
Amatrox 109 on at

Like (0)

Report

Re: Links not sending correctly by email

@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:

Was this reply helpful? Yes No
Sebastiaan1 57 on at

Like (0)

Report

Re: Links not sending correctly by email

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?

Was this reply helpful? Yes No
Amatrox 109 on at

Like (0)

Report

Re: Links not sending correctly by email

@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?

Was this reply helpful? Yes No
Sebastiaan1 57 on at

Like (0)

Report

Re: Links not sending correctly by email

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?

Was this reply helpful? Yes No
Verified answer

Amatrox 109 on at

Like (1)

Report

Re: Links not sending correctly by email

@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!

Was this reply helpful? Yes No
Sebastiaan1 57 on at

Like (1)

Report

Re: Links not sending correctly by email

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

Was this reply helpful? Yes No