Sending FileLocation with hyperlink using send email activity

Help Studio
,
1

Hello!

I need help with the following issue:

I have built a process where the robot needs to send the output to different recipients using the send e-mail activity (office 365). As this process runs everyday, the folder name changes every day so the path looks something like this "\Company\Folder" + Today.ToString(“yyyyMMdd”) + “File.xlsx”. When I sent the excel file as an attachment, the robot copies the file, making it read-only and sends it via the mail. This is not preferable as my colleagues cannot edit this file and have to download it manually, resulting in many different versions of the file on different user accounts.

So what I need is a hyperlink to the actual file, which is not read-only, where my co-workers are able to edit it in a shared location. The problem is that when I try to put the file location in a hyperlink syntax, it doesn’t work, I have tried several different solutions.

First I assigned a variable FileLocation to the folder path, then I tried making the FileLocation a hyperlink using the syntax: “these links:
.” directly in the body of the email message as text. This doesnt work as the result is one long string instead of a hyperlink.
Then I tried assigning a new variable Hyperlink to the filelocation using the syntax and passing the new variable as text this also doesnt work as the bot just reads it as a string. I have changed the variable type to hyperlink Xelement.
Finally I have tried to add the FileLocation/Hyperlink as an HTML item instead of text with different syntaxes, al of these seem to be failing.

So what is the best option for passing a FileLocation as a hyperlink in the send email activity? Any help would be appreciated.

Studio version is 2023.8.0.
Excel version is Microsoft® Excel® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit .

Kind regards, Job

2

Maybe we did misunderstand.

  • File is located to local FileSystem
  • Filepath within an URL was generated to the local File
  • Url was shared with others via the Email

As the file is only present at the local machine’s filesystem, so others cannot use the URL and access it.

When the file is located

  • Shared Drive
  • OneDrive / SharePoint / …

then a appropriate LINK can be used, and others can use it (Assumption: access & permissions is given)

3

Hi Peter,

Thank you for your reaction.

The issue I’m facing here is that I don’t know how to put the variable of Today(“yyyyMMdd”) into the folder path link. When I put the folder path in the body of the HTML editor, with the date fixed it works, so like this: \Company\Folder\File 20231214.xlsx it generates a link that is clickable and leads to the shared location.

However, when I try to put the date as a variable, it doesn’t generate a link anymore. Like this: “\Company\Folder\File” + Today.ToString("yyyyMMdd) + “.xlsx”. So my question is, how do I write the date in a folder path as html item so that it keeps generating the link.

Thanks in advance!

Kind regards, Job

4

which one?

Maybe the following helps

grafik
grafik799×177 19.4 KB