cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jamy123
New Member

Extract number from email subject

Sorry if this has been posted previously.

 

I have a flow which is triggered by an email being received - exports email - converts to pdf- renames and then pushes to a drobox folder - this is all working successfully.

 

BUT I now need a condition that reads the subject line and looks for a 9 digit number - a customer might put this anywhere in the subject line, and then uses this number to name the exported email - the number will always begin with a 1 - can you suggest anything?

 

Thanks in advance 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@Jamy123 

Please try below expression, Replace outputs('Subject') with the subject from your email

substring(outputs('Subject'),indexOf(outputs('Subject'),'1'),9)

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

1 REPLY 1
Mira_Ghaly
Dual Super User
Dual Super User

@Jamy123 

Please try below expression, Replace outputs('Subject') with the subject from your email

substring(outputs('Subject'),indexOf(outputs('Subject'),'1'),9)

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,116)