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!
Accepted Solutions
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!
you can try to replace the spaces with %20 within an expression:
replace(outputs('Link_to_item'), ' ', '%20')
Best regards,
André
no worries! You have to replace your "Link to item" with the new "Link without space" compse-action in the email body like this:
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?
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?
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!
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
