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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,534)