cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Removing a character from an array

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. 

CParker_2-1596765109671.png

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).

CParker_3-1596765166261.png

 

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......

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @CParker,

 

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

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

Annotation 2020-08-07 112340.jpg

 

Annotation 2020-08-07 112341.jpg

 

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.

View solution in original post

5 REPLIES 5
Highlighted
Super User II
Super User II

@CParker 

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.

Highlighted

Hi @edgonzales!

 

It's coming from a CDS (ce) List action (from D365)

CParker_0-1596770366318.png

I'm not sure if/how a replace could be used with this......

Highlighted
Community Support
Community Support

Hi @CParker,

 

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

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

Annotation 2020-08-07 112340.jpg

 

Annotation 2020-08-07 112341.jpg

 

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.

View solution in original post

Highlighted

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.

CParker_0-1597017615025.png

 

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.)

Highlighted

Hi @v-litu-msft 

I worked it out!

 

I used the below code(?) to reinsert the Email header.

CParker_0-1597031609118.png

Also, the Compose/Join doesn't seem to be required as it gives the desired result without it.

CParker_1-1597031765929.png

 

Thanks for your help!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (11,729)