Turn Variable Into an Email Address

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Paulie78 8,422 Moderator on at

Like (1)

Report
Try this expression:

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

Screenshot:

Was this reply helpful? Yes No
frankc9 80 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

Mark-Shenouda Microsoft Employee on at

Like (1)

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

Use SplitText action to split the first and last name by Spaces
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
Finally you can concatenate them in a variable and do the desired operation
Hope this helps
Best Regards

Was this reply helpful? Yes No
frankc9 80 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No