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

help to extract email from string

Hello ,

 

Could you please help me to extract the email from string 

 

041780957_0-1604468733260.png

 

i got curly my hair when try to extract this string. thank you for you help

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
bibhupanigrahi
Resolver III
Resolver III

Hi @041780957 , to get the email address from your exact string, I used this formula:

 

substring(variables('email'), add(int(indexOf(variables('email'),':')),2), sub(int(length(variables('email'))),add(int(indexOf(variables('email'),':')),4)))

 

See example run below:

 

get-email-from-string.jpg

 

Hope this helps.

View solution in original post

Wow man, this is really cool.  thank you very much.

View solution in original post

2 REPLIES 2
bibhupanigrahi
Resolver III
Resolver III

Hi @041780957 , to get the email address from your exact string, I used this formula:

 

substring(variables('email'), add(int(indexOf(variables('email'),':')),2), sub(int(length(variables('email'))),add(int(indexOf(variables('email'),':')),4)))

 

See example run below:

 

get-email-from-string.jpg

 

Hope this helps.

View solution in original post

Wow man, this is really cool.  thank you very much.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,330)