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 |
---|---|
102 | |
39 | |
29 | |
24 | |
16 |
User | Count |
---|---|
132 | |
52 | |
51 | |
37 | |
26 |