Forum Discussion

Resolver II

7 years ago

Solved

Concatenating data within RELATEDTABLE output

My report has a list of email addresses, and the request from the users is to have a "mailto" hyperlink they can click to send an email to all addresses. The list needs to be dynamic based on slicer...

pdbenbow
7 years ago
I was able to get what I needed by converting the calculated column into a measure.

DAX:
Email All = "mailto: " & CONCATENATEX(VALUES(ENVH[Email]),ENVH[Email],"; ")

pdbenbow

Resolver II

3 years ago

We got it to work with a button. Not sure if this applies to your situation, but "mailto" has a limit of 2,000 characters. We found the button would not function if the concatenated list was over 2,000 characters long. We used slicers so our users could break the list down into smaller, more manageable groups. This allows them to get the "mailto" under 2,000 characters, which allows the button to function.

crjackson

Helper I

3 years ago

Hmmm. I have a slicer and it still doesn't work for me even with just two email addresses