Get Certain information in email and send it to teams chat

[heprex]

Hello, I've been playing around with power automate and really found some useful case within my team. So we've been receiving hundreds or thousands of emails of system alerts and want to filter the most important ones to send it to teams chat. The email is in Rich Text format and not HTML.

So sample email is:

# Organization = BLA BLAH

# Machine Address = USA

# Machine City = BLA BLAH

# Machine State = BLA BLAH

# Machine Zip = BLA BLAH

# Machine Country = BLA BLAH

# Contact Name = BLA BLAH

# Alternate Contact Name = BLA BLAH

# Contact Phone Number = BLA BLAH

# Alternate Contact Phone Number = BLA BLAH

# Offshift Phone Number = N/A

# Alternate Offshift Phone Number = N/A

# Contact Email = BLA BLAH

# Machine Location = BLA BLAH

# Record Type = BLA BLAH

# Machine Type = BLA BLAH

# Serial Number = BLA BLAH

# Machine Part Number =

# Component =

# Component Release =

# Group Name =

# Hardware MT =

# Hardware SN =

# Error ID = FAILED HARDWARE

# Error Code = BLA BLAH BLA BLAH BLA BLAH

# Error Type = software

# System Version = SystemVersion

# FRU = None

# System Name = SystemName

And I want to get only the following lines or information to send to teams chat:
# System Name = SystemName
# Error ID = FAILED HARDWARE
# Error Code = BLA BLAH BLA BLAH BLA BLAH

and other information if required.

[kacaforyah]

Using a 'When an email is received' trigger you can use an expression like this for # Error ID

substring(triggerbody(), add(indexof(triggerbody(),'# Error ID ='),14), sub(nthindex(substring(triggerbody(), indexof(triggerbody(),'# Error ID =')),'#',2),1))

Let's break down this expression:

1. triggerbody(): This presumably gives the entire content of the email or whatever trigger you have set up in Power Automate.

2. indexof(triggerbody(),'# System Name ='): This finds the starting position of the text # Error ID = in your email content.

3. add(indexof(triggerbody(),'# Error ID'),10): This gives the position right after# Error ID (since # Error ID = is 10 characters long). This should be the starting position of the actual system name in your email content.

4. substring(triggerbody(), indexof(triggerbody(),'# Error ID')): This would give you the content of the email starting from # Error ID = till the end.

5. nthindex(...,'#',2): This nthindex is a function you're using to return the position of the second occurrence of # from the substring derived in the previous step.

6. sub(nthindex(...),'#',2),1): This is to subtract 1 from the position obtained in the previous step.

7. The entire substring function, then, would try to extract the string starting from right after # Error ID = and ending just before the next #.

-----

For System name because nothing comes after, you can use this expression:

substring(triggerbody(), add(indexof(triggerbody(),'# System Name ='),14))

[heprex]

Thanks! let me play with it a bit more as I'm new to this. kept getting this error

inputs at line '0' and column '0': 'The template language function 'indexof' expects its first parameter to be of type string. The provided value is of type 'Object'.

[AlexEncodian]

@heprex 

If you want a quick and easy build, you could use Encodian's Utility - Extract Text between Values action.

The end value I used was a line break. Just concatenate the start value back into the result.

The full flow:

1) When email arrives
2) "HTML to Text" action on email body (should work for RTF emails too)
3) Pass through result into Encodian's Utility

FYI –  actions with the “Utility“ prefix only consume 1/20th of an Encodian action count . For example, a Standard plan has 500 actions so utility actions can be used 500x20 = 10,000 times. They are designed to be an incredibly cost effective productivity boost for your flow builds! 

 
---- 

*Encodian Flowr is a Standard Power Automate connector with 150+ actions to supercharge flow builds. Conversion, merging, splitting, OCRing, data extraction, QR/Bar codes, searching and much more. And we just added "Utility" actions, which are almost free to use and accelerate solution builds and remove maintenance overheads with actions like Extract text between values, extract URLs, extract email addresses, Password/GUID/HMAC creation, escaping/unescaping HTML, parsing HTML tables, etc.   

[kacaforyah]

You can look at the output of your trigger runs and see what the exact property name is for the content. Might be like triggerbody()['content'] or triggerbody()['body']. If that doesnt work try casting it as a string:

substring(string(triggerbody()), add(indexof(string(triggerbody()),'# Error ID ='),14), sub(nthindex(substring(string(triggerbody()), indexof(string(triggerbody()),'# Error ID =')),'#',2),1))

[heprex]

Thank you. Manage to make it work. But some follow up question, how about if the next line doesn't start with "#"?

[kacaforyah]

From the sample that only happens at the end right? If there's nothing after that in the input, then you can use

substring(string(triggerbody()), add(indexof(string(triggerbody()),'# System Name ='),16))

Which will return everything after system name =. 

Alternatively, you can change the index character. If it's some html code then you can change that '#' to whatever is next in your data. And change the nthindexof function to indexof, which will return the first index of the character by default.

Heres what it looks like:

substring(string(triggerbody()), add(indexof(string(triggerbody()),'# System Name ='),16), sub(indexof(substring(string(triggerbody()), indexof(string(triggerbody()),'# System Name =')),'your character goes here'),1))