Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create button/image to open outlook with dynamic multiple email Ids

Hi All,

 

Email IDs are stored in a table and mutilple email ids comeup on slections done in report.

 

Requirement : User should be able to send single outlook email to those email IDs consolidated in single email. Not individual email should trigger to all individual email id. one email having all email IDs that got filtetered on user selection.

 

Please suggest if anyone aware.

 

Thanks & Regards

Vaishali

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    3 years ago

    Anonymous create a new measure using the following expression and set its data category to image URL and that will do it.

     

    Email URL =
"mailto:" & CONCATENATEX ( VALUES ( 'Table'[Email] ), 'Table'[Email], "; ")

     

    👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

    If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️