This post will walk you through the steps required to parse an email address into two parts: the user name and the domain. If you are unfamiliar with Email-to-Flow, take a minute to review Introducing Email-To-Flow, a low-code Email Service.
This is a common request. The ability to parse the username and domain out of an email address. Luckily, it can easily be accomplished right within your existing flow.
For this example, let’s use “[email protected]“.
Parse UserName
To retrieve the user name, we are interested in all the content before the “@”. In our example, the user name would be “sean“.
To retrieve the username, we will be leveraging the following formula:
LEFT({!FromAddress}, FIND(“@”,{!FromAddress}) – 1)
To create the formula,
- Open you existing flow
- Navigate to Manager -> New Resource
- Create the following formula variable.
Parse Domain
To retrieve the domain, we are interested in all the content after the “@”. In our example, the domain would be “sproketlogic.com“.
To retrieve the domain, we will be leveraging the following formula:
RIGHT({!FromAddress}, LEN({!FromAddress}) – FIND(“@”,{!FromAddress}))
To create the formula,
- Open you existing flow
- Navigate to Manager -> New Resource
- Create the following formula variable.
