Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have case that i have multiple rows with company name, contact person, and e-mail link (mailto://xx@xx.com))
I need button or some other solution to get all email-adresses at the table to open in outlook at one click.
I was thinking that text string, which starts with "mailto://aa@aa.com;bb@bb.com...." would work, but I did not had enough skills to do that.
Solved! Go to Solution.
I think i need to make tables that each one include one slicer's catecory to resolve the problem. Other solutioin might be to make string in excel to each kategory.
We can use CONCATENATEX() function to get the string like "mailto:xx@xx.com; yy@yy.com". However, as I tested, currently the mailto link type can only support single mail address, it doesn't work for multiple addresses.
It returns nothing when clicking on concatenated string.
I suggest you leave your comments on this idea.
Regards,
Thank you for your reply!
It work for me with this string:
I think i need just create that string like "mailto://:xx@xx.com; yy@yy.com; xx@xx.com"
To get that string, you can create a calculated column like:
mailtoall = "mailto://"&CONCATENATEX(ALL(Table1),Table1[Column1],"; ")
Regards,
It worked very well, but now i have new problem.
I'm using slicer to categorizate companys, becouse I have like 300 companies on that list. Now if i choose one category, mailtoall-link create link to all contacts, not that specified category. Is there any solution to avoid that?
That could be a problem. If you need your concatenation based on selection from slicer, you have to use slicer. However, we can't set "Web URL" data category for a measure so that it's not possible to click.
Regards,
I think i need to make tables that each one include one slicer's catecory to resolve the problem. Other solutioin might be to make string in excel to each kategory.
Thank you, I try it!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |