Forum Discussion
wolfy_
Helper I
Helper Imailto: dynamic mail's using measure
Hi, It is possible to creat a measure off mailto: whit the mail adress being dynamic created based on client and team. I have this 3 tables and are linked between them whit relationships. ...
v-chenwuz-msft
Community Support
Community SupportHi wolfy_ ,
The best way is to unpivot team table and client table. Let the table looks like this:
| team | team member's |
| team_1 | user_1 |
| team_1 | user_2 |
| team_2 | user_3 |
| team_2 | user_4 |
| team_3 | user_1 |
| team_3 | user_5 |
| team_4 | user_6 |
Then use function CONCATENATE() or CONCATENATEX() to get the result.
But what the link looks like?
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
wolfy_Helper I
Helper IHi, the link would be a mailto: so when I click on the projectID link it will open a new mail whit all the necessary parties, client, and team menbers mail's