Unanswered

How to perform multiple string functions in one expression?

(0) Share

Report

Posted on by TiagoSa

I have an array of emails: {"body":{"emails":["email@email.com","email2@email.com"]}} and I am trying to get the final result of

email@email.com,email2@email.com; .... Since I am trying to send an email to the emails in an array. To solve this I have 4 composes where I convert the array to string, then I substring the first 19 chars out of the string and then I substring the last 3 chars and finally use replace to remove quotes from the string for a final result of email@email.com,email2@email.com;

Is there a simpler/more efficient way of doing this?

Here's a screenshot of my flow:

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

If the emails are already in an array you can add the array to a for each loop. The action in the loop is an append to string. Just append each email from the array with an appropriate separator after it, like a comma or a semicolon. Then once you exit the loop you'll have a comma or semicolon delimited string. Depending on what you are doing with it you might want to drop the last character to get rid of the extra delimiter.

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (1)

Report
Hi @TiagoSa,

Since the email is a property of the object, so you can extract the array out firstly, then the join() function will be powerful in this situation, you can use the join() function to convert the array into a string and add the ";" into the array, then the array of Email addresses will be a string of email addresses separated by ";", for example:

join(outputs('Compose')?['body']['emails'],';')

Run result

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No