Turn Variable Into an Email Address

[frankc9]

Hello,

How would I go about taking a variable and turning it into an email address?

For example, I have a flow that retrieves a users first and last name that is stored into a variable and I need to send that user an email.

FirstNameLastInitial@domain.com

John Contoso > JohnC@domain.com

[Paulie78]

Try this expression:

concat
(
split(variables('Name'), ' ')[0],
substring(split(variables('Name'), ' ')[1], 0,1),
'@domain.com'
)

 Screenshot:

[frankc9]

Thank you for the quick reply!

I am sorry, I should have added if it would be possible to do this in Automate Desktop? Currently, I have an unattended desktop flow triggered by the cloud connection.

[Paulie78]

I have no doubt it is possible. But I have hardly use Power Automate Desktop, so I cannot tell you how to do it. It's something I hope to spend more time on very soon.

[Mark-Shenouda · Accepted solution]

@frankc9 
Hope you are well, 
I believe you can achieve this by using multiple actions, 

1. Use SplitText action to split the first and last name by Spaces
   
2. you will now have a list of text, that contains 2 items , now you can use the Get Sub text action to get the first character of the Last name as below 

   

3. Finally you can concatenate them in a variable and do the desired operation 

Hope this helps 
Best Regards

[frankc9]

@Mark-Shenouda 

Hope you are doing well yourself!  This was exactly what I was looking for and I was able to piece it all together.  At one point I was in the right spot, but couldn't figure out how to pull the first and last name from the split text.