I'm looking to build out a rather simple flow that will take certain information from a MS form and output it as an email sent from a shared mailbox.
My question however, is that for the email signature of the outgoing email, I'd like it to be in the format of "First Name/First Initial Last Initial" - example, "Chris/CM"
Is there a way to perhaps build a variable or something that if I were to extract their name using the Office 365 Get user profile function?
Thank you so much in advance.
Solved! Go to Solution.
Hi @crmart1n_mx ,
Maybe you could try the following expression:
concat(first(split(outputs('Get_user_profile_(V2)')?['body/displayName'],' ')),'/',substring(first(split(outputs('Get_user_profile_(V2)')?['body/displayName'],' ')),0,1),substring(last(split(outputs('Get_user_profile_(V2)')?['body/displayName'],' ')),0,1))
I have made a test for your reference.
Result Screenshots:
Best Regards,
Charlie Choi
Hi @crmart1n_mx ,
Maybe you could try the following expression:
concat(first(split(outputs('Get_user_profile_(V2)')?['body/displayName'],' ')),'/',substring(first(split(outputs('Get_user_profile_(V2)')?['body/displayName'],' ')),0,1),substring(last(split(outputs('Get_user_profile_(V2)')?['body/displayName'],' ')),0,1))
I have made a test for your reference.
Result Screenshots:
Best Regards,
Charlie Choi
This is brilliant and worked perfectly. It's much appreciated.
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |