Answered

Convert Array into Reformatted String of Email Addresses

(1) Share

Report

Posted on by CU18091915-0

Hello,

I need to have the output of an array that includes values from a Sharepoint List converted into a string with only the emails. The column it is pulling from is of type Choice.

The output is a list of email addresses, but the values are currently being pulled with extra characters, which means I cannot add the output as Dynamic Content in the 'To:' section of the 'Send an email (V2)' action. I've seen other solutions online that only seem to work if you want to send a separate email to each user with the Apply to Each function, but I want to send 1 email to all unique users.

Output I'm trying to fix:

I need this to instead be returned as just a string of the email addresses, separated only by a space, at most.

Or, I need an additional action/ expression that will convert it to that format.

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

Here is the whole list of actions ('Get items' action used to access Sharepoint List items is above these):

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

Action Details:

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

'BuyerEmail.Value' Expression: item()?['BuyerEmail']?['Value']

'Compose - Remove Duplicates' Expression: union(outputs('Compose_-_Empty_Array'),body('Select_-_Users'))

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

Thank you for taking the time to read this.

Thank you in advance for any help.

Cheers

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

You need to first update the Select action. Switch to text mode

This will return the array as:

[
"john.doe@example.com",
"jane.smith@example.com",
"david.johnson@example.com",
"emily.brown@example.com",
"michael.wilson@example.com"
]

Then use join action

Final Output

Was this reply helpful? Yes No
CU18091915-0 39 on at

Like (1)

Report
Copy link

Link copied!

@SudeepGhatakNZ Amazing. Fixed in 10 minutes what I've spent a few hours troubleshooting. Sincerest thanks.

For posterity, the main issue causing the extra characters was fixed by just using item()?['BuyerEmail']?['Value'] expression in the text mode of the Select action, and deleting all other characters that had automatically populated. The '?['Value]' part of the expression is only used because the Sharepoint List column is Choice type, and this keeps it from pulling in other metadata characters.

The only change I made to Sudeep's suggestion was using a space instead of a semicolon for the 'Join with' value in the 'Join' action. This is because my email addresses were already stored with a semicolon on the end.

Again, sincere thank you, Sudeep.

Was this reply helpful? Yes No