cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Otto
Level: Powered On

Replacing Characters

Hi Fellow Flow-ers,

 

I'm not familar with the replace expression so need some help please.

 

We have an issue where our website does not allow ; as a valid seperator for multiple email addresses.

 

We have found that if we transfer into ASCII it will go through but form cannot be saved by client without changing the ; to a ,

How can I change the ; (example below shows %3B) to , (example would be %2C)

 

test%40xyz.com%3Btest%40gmail.com.au to test%40xyz.com%2Ctest%40gmail.com.au

1 ACCEPTED SOLUTION

Accepted Solutions
Otto
Level: Powered On

Re: Replacing Characters

Hi @RobElliott thanks for your assistance on this.

I actually had some spare time and when through the forum and found that replace() may do the trick.

 

I ended up using compose and expression

replace(outputs('Email_Encoded'),'%3B','%2C')
 
So the ASCII semi colon (%3B) is converted to comma (%2C)
 

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Replacing Characters

Hi @Otto , one thing which you can try which worked in my test was to add a Compose action, add the addresses into it separated by a comma, and then use the Output from that in the To field of the Send an Email.

Rob
Los Gallardos

ComposeEmailAddresses.png

Otto
Level: Powered On

Re: Replacing Characters

Thanks but does not help me unfortunately. I need to replace the characters for my full flow to work
Highlighted
Super User
Super User

Re: Replacing Characters

The solution I gave does replace the semi-colons with a comma and my full flow worked fine. You'll need to give more detail about why it wouldn't work for you as sorry but I don't understand.
Rob
Los Gallardos
Otto
Level: Powered On

Re: Replacing Characters

Hi Rob,

Basically what I need to do is change semi colon to comma so when i fill a webform with the data it shows as email,email as email;email is not supported.

I believe i need to use the expression replace but im not 100%.

If your solution did this i did not realise.

My flow does the following,

Parses data from email by html to text then encodes it and sends the data via sms,email,xml for various systems.
Otto
Level: Powered On

Re: Replacing Characters

Hi @RobElliott thanks for your assistance on this.

I actually had some spare time and when through the forum and found that replace() may do the trick.

 

I ended up using compose and expression

replace(outputs('Email_Encoded'),'%3B','%2C')
 
So the ASCII semi colon (%3B) is converted to comma (%2C)
 

View solution in original post

Super User
Super User

Re: Replacing Characters

Hi Otto, that's good. I'm pleased you resolved it.

Rob
Los Gallardos

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 322 members 5,727 guests
Please welcome our newest community members: