mailto: dynamic mail's using measure

[wolfy_]

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.

Is that possible to creat the link mailto: dynamically depending on client and team?

Project table

project	client	team
project_1	client_1	team_1
project_2	client_2	team_3
project_3	client_3	team_1
project_4	client_1	team_4

client table

client	client mail
client_1	cliente_1_user1; client_1_user_2; client_1_user3;
client_2	client_2_user1;
client_3	client_3_user1; cliente_3_user2;

and team table

team	team member's
team_1	user_1; user_2;
team_2	user_3; user_4;
team_3	user_1; user_5;
team_4	user_6;

[v-chenwuz-msft]

Hi @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_]

Hi, 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