Creating email with cell value

[Unicorn_Tech]

Hi.  I have  created a column that concatenates several values, resulting in:

<a href=matilto:email@email.com?subject=http://documentlink</a>

Document link is location of an invoice, and each record has a seperate invoice.  I'm looking for a way for a user to click on this concatenated cell, and receive the document link to their inbox.  Is there a better code to achieve this?  I've formatted the above as a web url, but it's not opening anything. 

Thank you.

[v-jayw-msft · Accepted solution]

Hi @Unicorn_Tech ,

URLS must start with one of the following:

• http
• https
• mailto
• ftp
• news
• telnet

So in your case you will need to modify the url to:

matilto:email@email.com?subject=http://documentlink

Then change the data category to web url and turn on url icon.

Best Regards,

Jay

[Fowmy]

@Unicorn_Tech 

You Turn-on the "URL Icon" under Values:

[Unicorn_Tech]

It's on, but unfortunatley there is no change.

[Fowmy]

@Unicorn_Tech 

Hope the following document will be of help. You also share a sample Power BI file that represents your issue.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables.

[Unicorn_Tech]

Hi.  I've managed to fix the code, so it now opens an email the way I would like (removed the hrefs).  Is there now a way to hide the complicated code, with some kind of icon?