Removing a character from an array

Like (0) Share

Report

Posted on 7 Aug 2020 02:32:10 by Community Power Pla...

Hi All,

I'm trying to use Power Automate with some email records and have come to an issue with ;'s in the array I have.

This is the array I have (below) and I'd like to remove the semi-colon (;) from the end of the email addresses.

I went down the path of converting the array to a string, then using split to turn it back into an array (using ; as the delimiter), which removed the ; but I ended up with more unwanted characters than I had previously (see below).

I was hoping that someone had a non-convoluted way to solve my issue, of simply removing the ; symbols from the array stored in varQuickCampCandEmailAdd......

All responses (5)

Answers (1)

Community Power Pla... on 10 Aug 2020 at 03:56:38

Like (0)

Report

Re: Removing a character from an array

Hi @v-litu-msft
I worked it out!

I used the below code(?) to reinsert the Email header.
Also, the Compose/Join doesn't seem to be required as it gives the desired result without it.

Thanks for your help!
Community Power Pla... on 10 Aug 2020 at 00:03:55

Like (0)

Report

Re: Removing a character from an array

Hi @v-litu-msft ,

Thanks for getting back to me and your advice.

They've given me the key data that I'm after, but the header (Email) is missing from the output (see below). I'm not sure if that will be a problem for the next steps in my flow or not.

Do you have any ideas of how to insert the "Email" header back into the array?

(I've got another question which will involve the use of this cleaned array, but I'll create a new post for that one.)
Verified answer

v-litu-msft on 07 Aug 2020 at 08:23:41

Like (0)

Report
Re: Removing a character from an array

Hi @Anonymous,

You could following these steps and expression to remove ";" and convert the array into a string:

replace(item()?['Email'],';','')
join(variables('Emails'),',')

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.
Community Power Pla... on 07 Aug 2020 at 03:20:37

Like (0)

Report

Re: Removing a character from an array

Hi @edgonzales!

It's coming from a CDS (ce) List action (from D365)
I'm not sure if/how a replace could be used with this......
Ed Gonzales 4,531 Most Valuable Professional on 07 Aug 2020 at 02:40:23

Like (0)

Report

Re: Removing a character from an array

@Anonymous

How are the email addresses being added to the array? Is there an opportunity to use Replace() as they are added?

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.