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

Parsing out a Subject line from an email

I have an email with a subject line like this:

Alert: #103378 COMPANY NAME 103378 > Servers WIN-AP02 Patch Status v2\nFailed

 

In my flow : 

Receive email -> HTML to text for subject -> Compose with a split

 

split(outputs('HTML_naar_tekst')?['body'], '')[0]

 

But this gives me the whole line and  i just like to have the number after the # , zo in this case 103378. How do I use split in this case?

 

 

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Ahammad_Riyaz
Super User
Super User

Hi @YasmineH 

 

Please find the attachment.

Ahammad_Riyaz_0-1649835096826.png

I was just passed in variable in your case pass in compose dynamic value as html as text output.

Ahammad_Riyaz_1-1649835169834.png

 

Output:-

Ahammad_Riyaz_2-1649835211222.png

 

 

 

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

VictorIvanidze
Community Champion
Community Champion

Try this:

split(split(outputs('HTML_naar_tekst')?['body'], '#')[1],' ')[0]
--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.

View solution in original post

4 REPLIES 4
Ahammad_Riyaz
Super User
Super User

Hi @YasmineH 

 

In this 103378 5 digit is constant or it may increase.

@Ahammad_Riyaz  it's a company number from our CRM. So I like to distract this number so I can re-use it as a new variable names "CompanyNumber"

Ahammad_Riyaz
Super User
Super User

Hi @YasmineH 

 

Please find the attachment.

Ahammad_Riyaz_0-1649835096826.png

I was just passed in variable in your case pass in compose dynamic value as html as text output.

Ahammad_Riyaz_1-1649835169834.png

 

Output:-

Ahammad_Riyaz_2-1649835211222.png

 

 

 

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

VictorIvanidze
Community Champion
Community Champion

Try this:

split(split(outputs('HTML_naar_tekst')?['body'], '#')[1],' ')[0]
--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (2,577)