cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sebastiaan1
Regular Visitor

Links not sending correctly by email

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:

Sebastiaan1_4-1611831424435.png

 

Sebastiaan1_5-1611831497323.png

 

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

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions

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

Amatrox_0-1611851675578.png

 

 

Hope this works for you!

View solution in original post

8 REPLIES 8
Amatrox
Resolver I
Resolver I

@Sebastiaan1 -

 

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

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

Amatrox_1-1611834290461.png

 

Amatrox_0-1611834150259.png

 

 

 

Best regards,

André

Hi,

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

Thanks!

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

Amatrox_0-1611835097622.png

 

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?

 

Sebastiaan1_0-1611836871346.png

 

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

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?

 

1.png2.png

 

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

Amatrox_0-1611851675578.png

 

 

Hope this works for you!

View solution in original post

Hi,

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,550)