Creating email string for outlook

(0) Share

Report

Posted on by DS-17101513-0

hi all,

how do i turn this -

{"Email":"j@eay.co.uk"};{"Email":"Peter@n.co.uk"};{"Email":"Josh.R@ail.co.uk"};{"Email":"Cr.Hll2@nail.co.uk"};{"Email":"se@ml.uk.com"};

into this -

j@eay.co.uk; Peter@n.co.uk; Josh.R@ail.co.uk; Cr.Hll2@nail.co.uk; se@ml.uk.com

and therefore make it useable within my flow, thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Where are you getting this outputs from? Can you share a screenshot of your current setup.

Normally you can use a Select action for that. In this approach the string is converted into an array. This way the select can retrieve the value of the Email property. After that you can join the values back into a string with the semi colon character.

From field in Select

json(concat('[',slice(replace(variables('ExampleOutput'), ';', ','), 0, -1), ']'))

Map field (switched to text mode with button on the right side

item()['Email']

Join it back into a string value again within the Compose with the below expression

join(body('Select'), '; ')

Test result

Was this reply helpful? Yes No
DS-17101513-0 16 on at

Like (0)

Report

thanks so much for this suggestion, here is my current flow -

the compose (unique email) gives the long list of email addresses, is as below -

the original email list is derived from -

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
In that case you could change the Select action. Switch the map field to text mode and remove the Email key.

1. Remove both the Email Key and the expression from the Map field

2. Use the T button on the right side to switch to text mode

3. Add the expression back to the Map field

4. After that you can use the same expression in your Compose

join(union(body('Select_-_user_emails'), body('Select_-_user_emails')), '; ')

Was this reply helpful? Yes No