Create email address from text field

(1) Share

Report

Posted on by egornua1

364

Hello All,

can anyone suggest a way to create an email address from a text field

Text field = John Doe.

Basically i need to update a person group field but i dont have the email from source.

Thanks for your time.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @egornua1

Do you know the domain details of the email address. The you could use the split() and concat expression to construct the email. See below.

The expression I used above is as follows:

concat(first(split(outputs('Compose'),' ')),'.',last(split(outputs('Compose'),' ')),'@test.com')

Run Result:

Thanks

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report
Copy link

Link copied!

@abm - Thanks for your help on this.

The conversion to email address works well, but when i try to use the expression to update either person/group field or a single line text field, i get the below error.

Unable to process template language expressions in action 'Create_item' inputs at line '1' and column '32034': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Array'. Please see https://aka.ms/logicexpressions#split for usage details.'.

Any ideas?
Thanks again for your time and help.

Was this reply helpful? Yes No
abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @egornua1

Could you please post a screenshot of your flow?

Thanks

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report
Copy link

Link copied!

hi @abm,

its all good now, i didnt have the compose within the apply to each.
Once i moved it down, the flow ran fine.

Thanks for your support, initial response accepted as the solution.

Was this reply helpful? Yes No