Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
One of my visualizations includes contact info for customer and I was wondering if it is possible to make the email column into clickable urls that start a new email?
I have tried using data category to make it url but does not seem to work.
Anybody have some direction for me?
Thanks a lot.
Is there a way to remove "mail to" and only have the email id as a link?
Hi @jostnachs,
The previous response I added to this thread shows email addresses without the mailto... although I didn't post an image of it doing that 🙃
Hi @gaiusgw,
I'm sure you've sorted this by now, but in case any one else comes across this post, here's what I did to show working email addresses without the mailto: bit showing:
Email link = CONCATENATE("mailto:", DataSource[Email])
Things to note
Good luck 🙂
I tried this and i still see mailto
Hi @jostnachs ,
In the table visual where you are showing the email addresses, are you using the non-concatentated/original email address field from your original data?
You only need to use the concatenated column for the Web URL link bit.
Hope that helps 🙂
Hi,
I followed the exact steps given by you. but then i see along with the mail to 😄 dotn know what i missed.
Hi @jostnachs ,
Hmm, can you create the table with the normal email address from your data (without the link)?
Hi @gaiusgw ,
Please add "mailto:" to the mail address:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Adding mailto: in front of emails in an added column does work but it is not the most elegent solution persay. And any lines that do not have an email will appear as just mailto:. It would be strange if powerbi cannot recognize emails and make them clickable.
Hi @gaiusgw ,
Try work with IF function.
IF(ISBLANK([Mail]),BLANK(),CONCATENATE("mailto:",'Table'[Mail]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That did not work. mailto still appeared. Perhaps because those empty cells really have space characters?
Hi @gaiusgw, There is an element that might need to be turned on in the visualization settings, see below.
Hmm, i do not have that panel as far as I can tell. I am on version 2.91.7 and honestly nervous to update.
Here is what my panel looks like.
on another note, if i did update, do you know of any place i can download the version i have now? I have search for archives but cannot fine one.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
84 | |
76 | |
49 |
User | Count |
---|---|
143 | |
141 | |
109 | |
69 | |
55 |