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

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
Highlighted
Otto
Frequent Visitor

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

8 REPLIES 8
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
Frequent Visitor

Re: Replacing Characters

Thanks but does not help me unfortunately. I need to replace the characters for my full flow to work
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
Frequent Visitor

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.
Highlighted
Otto
Frequent Visitor

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

Super User
Super User

Re: Replacing Characters

Anybody have a chart for other special characters?  I dont know what the heck these are called to even search for it.  Its not hex, nor ascii.  

Super User
Super User

Re: Replacing Characters

Apparently, its kinda hexy.  I dont know.  I tried to convert, and I didnt get the same thing... anywho:

 

URL Encoding of Special Characters

Some characters are utilized by URLs for special use in defining their syntax. When these characters are not used in their special role inside a URL, they must be encoded.

Character Code Points (Hexadecimal) Code Points (Decimal)
Dollar ("$") 24 36
Ampersand ("&") 26 38
Plus ("+") 2B 43
Comma (",") 2C 44
Forward slash/Virgule ("/") 2F 47
Colon (":") 3A 58
Semi-colon (";") 3B 59
Equals ("=") 3D 61
Question mark ("?") 3F 63
'At' symbol ("@") 40 64

Some characters present the possibility of being misunderstood within URLs for various reasons. These characters should also always be encoded.

Character Code Points (Hexadecimal) Code Points (Decimal) Details
Space 20 32 Significant sequences of spaces may be lost in some uses (especially multiple spaces)
Quotation Marks 22 34 These characters are often used to delimit URLs in plain text.
'Less Than' symbol ("<") 3C 60  
'Greater Than' symbol (">") 3E 62  
'Pound' Character ("#") 23 35 This is used in URLs to indicate where a fragment identifier (bookmarks/anchors in HTML) begins.
Percent Character ("%") 25 37 This is used in URLs to encode/escape other characters. It should also be encoded.
Miscellaneous Characters Some systems can possibly modify these characters.
Left Curly Brace ("{") 7B 123  
Right Curly Brace ("}") 7D 125  
Vertical Bar/Pipe ("|") 7C 124  
Backslash ("\") 5C 92  
Caret ("^") 5E 94  
Tilde ("~") 7E 126  
Left Square Bracket ("[") 5B 91  
Right Square Bracket ("]") 5D 93  
Grave Accent ("`") 60 96  

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,256)