Need help parsing the domain of an "Email" field and saving it to a separate field

(0) Share

Report

Posted on by Community Member

Hello,

I want to parse the domain portion of an "Email" field and save it as a separate domain field. For example, An email of "johnsmith@yahoo.com" will get saved to a "Domain" text field as "yahoo.com". How can I do this?

Thanks!

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

MikeC282 2,175 on at

Like (0)

Report

For an out of the box method, you can use Power Automate which is essentially going to replace workflows. I've created a dummy Flow with a single email address of "test@hotmail.com"

In the last step I took the email and performed a Flow expression to split the string by the "@" value and then extract the last item of the returned array. You'd obviously replace the first compose step with a CDS Flow step to extract an email from a CRM record but the second step where I transform it in the second compose still applies.

1. This will be whatever step in which you'll get the email address from.

2. This uses the below expression to split the email into a array and then extract the last portion (the domain).

Below is the result:

--------------------------------------------------------------------------------------------------

If this answers your question, please mark it as a suggested answer

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is perfect, thanks!!

Was this reply helpful? Yes No
Suggested answer

Pradip Raj 327 on at

Like (0)

Report

Expression are as below :

last(split(triggerOutputs()?['body/sender'],'@'))

Where From = triggerOutputs()?['body/sender']

Was this reply helpful? Yes No
Nee2ok 5 on at

Like (0)

Report

I need help to extract the first part of the domain of an email address, capitalize it and save to a different column.

For example, email address = test@gmail.com.

I want to use Power Automate to extract the "gmail" value and capitalize it as "GMAIL" and save it to column called "Title".

The data source is a Microsoft Form.

Any assistance is very much welcome. Thanks

Was this reply helpful? Yes No
Suggested answer

Pradip Raj 327 on at

Like (0)

Report

Hello,

last(split(triggerOutputs()?['body/sender'],'@'))

We can use above expression to get the gmail.com then need to use the same expression with different syntex to get the "gmail" value. We can use first() instead of last() to get the GMAIL value. Please use below links for more details.

zeitgeistcode.com/.../

www.youtube.com/watch

Or use below

String = 'test@gmail.com"

first(split('test@gmail.com','.')) = 'test@gmail'

last(split('test@gmail'),'@') = 'gmail'

Was this reply helpful? Yes No
AdrianQ9 4 on at

Like (0)

Report

How would you write the syntax if you wanted the end value to say simple "hotmail" and remove the ".com"

Was this reply helpful? Yes No
AdrianQ9 4 on at

Like (0)

Report

Never mind I just created another Compose with the value:

split(outputs('Compose_2'), '.')[0]

then made THAT Compose the value I reference.

Hope this helps anyone else out there!

Was this reply helpful? Yes No