Answered

Power Automate removing text inside of greater than and less than symbols

(0) Share

Report

Posted on by sphenna

Hello,

I have a flow that is taking information entered into an MS Form and sending an email with the results of that form submission.

One of the pieces of information collected is an email address. I have noticed that some users are copying the email address straight from an outlook message, and in this case, the text entered into the field includes "<" and ">" symbols around the email (i.e. "<bob@gmail.com>"). When this happens, the email address does not populate over into the body of the email that is sent with the results of the form submission.

I think power automate is deleting the information that is between the "<" and ">" symbols. Is there a way to stop this from happening?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Hello,
can you just remove these angle brackets?

Was this reply helpful? Yes No
sphenna 31 on at

Like (0)

Report
Copy link

Link copied!

I'm not the one submitting the form, many other users in my organization are submitting the form. I've included instructions to not include the brackets, but some users forget. I have found a workaround using a split expression that splits the entry based on a "<" symbol. I'm hoping to experiment and maybe get a cleaner solution using an if expression, but this works for now.

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!
I mean you can use the replace() function:

replace(replace(variables('var1'),'<',''),'>','')

Was this reply helpful? Yes No
sphenna 31 on at

Like (0)

Report
Copy link

Link copied!

Oh, I see. Yes, thank you, that will work nicely!

Was this reply helpful? Yes No