cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CParker
Advocate I
Advocate I

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
v-litu-msft
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

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

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

v-litu-msft
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

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

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,181)