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

Parsing text from email subject

I would like to create a expression that grabs a persons first and last name from an email subject but I can't figure out how to do it. 

 

The subject line would be similar to this "New Hire Notification - FirstName LastName"

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Screen Shot 2021-04-20 at 2.47.18 PM.png

Where Ar1 is the name of the variable

View solution in original post

5 REPLIES 5
DamoBird365
Super User
Super User

Hi @usethegreymatte 

 

You probably just want to use the replace expression

 

DamoBird365_0-1618934013646.png

 

This returns the following:

DamoBird365_1-1618934051779.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

 

 

@DamoBird365, I get teh attached error when I use your expression, Here is my code: replace(outputs('Compose'),'New Hire Notification -')

 

Screen Shot 2021-04-20 at 2.32.44 PM.png

@usethegreymatte 

 

You're missing the final parameter ''.

 

replace(outputs('Compose'),'New Hire Notification -','')

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Screen Shot 2021-04-20 at 2.47.18 PM.png

Where Ar1 is the name of the variable

View solution in original post

@usethegreymatte 

Here is another way to approach your issue.  You can actually stop at my Get Name Compose action - the remaining actions just split out the first and last names.

image.pngimage.png

image.png

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

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,957)